The New Home of Oracle-wiki.net
The New Home of Oracle-wiki.net
All things oracle...
All things oracle...
A website for IT Professionals involved with Oracle database.
--
-- List ASM Diskgroups and Files
--
SET PAUSE ON
SET PAUSE 'Press return to Continue'
SET LINESIZE 300
SET PAGESIZE 60
SELECT
c.name dname, a.name fname,
( b.bytes / ( 1024*1024 ) ) gbyte, b.type ftype
FROM
v$asm_alias a, v$asm_file b, v$asm_diskgroup c
WHERE
b.file_number = a.file_number
AND
b.group_number = c.group_number
ORDER BY
c.name, a.name
/
Published on
Published 18th June 2025