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.