How To List Files and Sizes within an ASM Disk Group

dbtut

6 years ago

We can see asm files in Oracle ASM disk group without asmcmd. You can run the following query to view files and sizes in all disk groups.

select f.group_number, f.file_number, bytes, space, space/(1024*1024) "InMB", a.name "Name"
from v$asm_file f, v$asm_alias a
where f.group_number=a.group_number and f.file_number=a.file_number
and system_created='Y'
order by f.group_number, f.file_number;

select f.group_number, f.file_number, bytes, space, space/(1024*1024) "InMB", a.name "Name"

from v$asm_file f, v$asm_alias a

where f.group_number=a.group_number and f.file_number=a.file_number

and system_created='Y'

order by f.group_number, f.file_number;