Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Space used by each DB in a ASM.

628871Jun 1 2010 — edited Jun 7 2013

Hi All,

Is it possible to find out the space used by each database in the asm using ASM view?

We got 30 dbs running in a server on a single 11gR2 ASM instance.

I need to get 2 liner for all the database space from ASM.

Eg:-

Diskgroup total_mb free_mb
------------- ------------- --------------
data 200g 50g
flash 200g 100g

The above information I got it from v$asm_diskgroup but I am struggling to get the below output.

DBNAME DISKGROUP USED SPACE
------------ --------------- --------------------
orcl data 25g
orcl flash 40g
orcl1 data 15g
orcl1 flash 20g

I will be really helpful.
I tried from v$asm_file and v$asm_Client view but find hard to get it.

If you guys have any ideas please share with me.

Server & oracle detais
OS :- RHEL5
ORACLE:- 11gR2 cluster,ASM & 10gR2 home with 30 database running from 10g home.
RAC :- yes 3 nodes.

Thank you.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 5 2013

Added on Jun 1 2010

#automatic-storage-management, #performance-availability

10 comments

3,716 views