Oracle: information about ASM

Get the information about ASM disks:

select GROUP_NUMBER, DISK_NUMBER, TOTAL_MB/1024 GB, NAME from v$asm_disk;

Get the information about ASM diskgroups (including used space and the free space):

select GROUP_NUMBER, NAME, TOTAL_MB/1024 TOTAL_GB, FREE_MB/1024 FREE_GB from v$asm_diskgroup;

Topics: Oracle, space | Submitter: checkthis

Comments

You must be logged in to post a comment.