Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am looking for generating a Database Volume Consumption Report in Oracle 11g based on a specific time period. For e.g 1) Total Volume( Excluding Index Size) at 12 AM 2) Total Volume( Excluding Index Size) at 4 AM

Once I have the above info, I take the difference in the volume which gives me the database consumption that happened during this period of time. I have tried using dba_hist_tbspc_space_usage. I wanted to ensure whether this is the right view where I have to hit for the above information. Also the Index Size need to be excluded.

Please let me know your thoughts on this.

share|improve this question
    
Off topic; belongs on dba.se –  Kermit May 13 '13 at 1:52
add comment

migrated from stackoverflow.com May 13 '13 at 3:36

This question came from our site for professional and enthusiast programmers.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.