Storage Management (ASM ACFS DNFS ODM) (MOSC)

MOSC Banner

SELECT * FROM v$asm_diskgroup_stat; No rows selected

edited Aug 5, 2015 6:34AM in Storage Management (ASM ACFS DNFS ODM) (MOSC) 11 commentsAnswered

For some systen with ASM 11.2.0.4 oracle we are not getting output for

select 'DATA' dum1, free_mb/decode(type, 'NORMAL', 2,'HIGH' , 3, 'EXTERN', 1) SPACE_AVAIL, (total_mb - free_mb) SPACE_USED from v$asm_diskgroup_stat where name = 'DATA_QA' and (state= 'MOUNTED' OR state= 'CONNECTED');

I have found some online doc http://docs.oracle.com/cd/E11882_01/server.112/e18951/asmdiskgrps.htm#OSTMG94121 explaining about discovery "How A Disk is Discovered" Will this be useful ?

Also there is BLOG available on this issue http://www.killdb.com/2011/10/10/oracle-restart%E4%BD%93%E9%AA%8C%EF%BC%88%E7%BB%AD%EF%BC%89.html

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center