Detect OMF and ASM Programatically

[Thargy]

I am trying to detect the use of OMF and ASM within a PL/SQL procedure, i.e. I want to create two functions called
ASM_IS_BEING_USED and OMF_IS_BEING_USED which return booleans, indicating whether or not the instance involved is using ASM and OMF respectively.

The Oracle ASM doco (

http://download.oracle.com/docs/cd/B28359_01/server.111/b31107/asmdiskgrps.htm#i1009568)

doesn't appear to show whereabouts in the data dictionary this information is held. To detect ASM, I therefore intend to count the number of rows in V$ASM_DISK, and if it's > 0 set the boolean to true.

Does anyone have a more precise method than this, and does anyone know of a way of determining the same information for OMF?

Regards

T

 

[hoinz]

Not sure about it, as I don't use ASM;
but what about the parameter instance_type ?

select value from v$parameter where name = 'instance_type';

regards

 

[Thargy]

Thanks for the suggestion. I've tried it, and on an ASM instance it just says type is "RDBMS". Sadly there's no mention of ASM.

Regards

T