How To List Files and Sizes within an ASM Disk Group

dbtut November 25, 2018 ORACLE

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;

Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

How To List Files and Sizes within an ASM Disk Group

About dbtut

Leave a Reply Cancel reply