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.

bumped to the homepage by Community 19 hours ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

  • SQL Developer might have some pre-built Reports that are useful. How did you see "GB Free"? – Michael Kutz 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 acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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