Re: Extent grab ...

2002-02-14 Thread Anjan Thakuria
I guess I should be more specific. I am trying to find out the growth rate of a table on a 7.3.4 database. I did not get any info from the previous DBA. Can somebody tell me if there is a was to find out from the data dictionary how many extents by which this table has extended and when; the

RE: Extent grab ...

2002-02-14 Thread Jamadagni, Rajendra
you'll have to capture that information manually. Of course if you need a shortcut, use DBA module of TOAD, when you view tablespaces, it can create scripts and dbms_job to activate space monitoring. It can then show you space usage in a graphical manner for tablespaces and datafiles. It doesn't