If you 100 table spaces so how to find which table space is growing and which one is volatile?

supportdba8910
Profile Answers by supportdba8910 Questions by supportdba8910
Nov 16th, 2007
2
1888

Showing Answers 1 - 2 of 2 Answers

hemant.agarwal03
Profile

Mar 17th, 2008

select sum(bytes),TABLESPACE_NAME from dba_segments group by TABLESPACE_NAME
order by sum(bytes) desc
/

narendra05
Profile Answers by narendra05

Oct 2nd, 2009

In 10g the AWR repository keeps track of data for 60 days by default and can store the information of tablespace growth for this period.

Alternativey you can set the threshold in entreprise manager for a tablespace to respective which can trigger email alert if configered.