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.
--
-- ASM Diskgroups Attached to a Database
--
SET PAUSE ON
SET PAUSE 'Press return to Continue'
SET LINESIZE 300
SET PAGESIZE 60
SELECT
a.instance_name, a.db_name, b.name dname,
a.status, a.software_version
FROM
v$asm_client a, v$asm_diskgroup b
WHERE
a.group_number = b.group_number
ORDER BY
a.instance_name, a.db_name, b.name
/
Published on
Published 18th June 2025