Oracle Version:

I had about 100 GB freespace on my +ASM diskgroup on Friday.

When I came back on Monday, I see only 45 gigs. How can I find what consumed my space?

Or is there a SQLPlus command (or) TOAD method we can use?

Your help is my salvation.

  • SQL Developer might have some pre-built Reports that are useful. How did you see "GB Free"? Oct 9 '18 at 10:25

Just use asmcmd, where you have cd, ls and du.

If you insist on doing this through SQL, then you can use views such as V$ASM_ALIAS, V$ASM_FILE, V$ASM_DISKGROUP.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.