This content has been marked as final. Show 3 replies
SELECT name, header_status, path FROM V$ASM_DISK
Edited by: user12032091 on May 17, 2012 11:26 PM
You can create UDM on database target instead of ASM. Some of the tables like v$asm_disk you can query even in database, doesn't have to be on ASM.
Thanks for the responses.
Using a UDM to get the information from a database instance is not an ideal solution as I would only want to report the situation once per server.
Typically we have 3-6 instances per server and over 300 servers, so it would not be feasible to configure a UDM for only one isntance per server.
I have now raised an enhancement request with Oracle for this.