Table Stats [message #23120] |
Tue, 19 November 2002 04:38 |
Munish
Messages: 21 Registered: November 2001
|
Junior Member |
|
|
Hi,
I just want to know the table growth in bytes over aperiod of time. Lets say yesterday it has 100 rows and today teher r 200 rows so how much bytes of data has been increased. I want in a select query and not in a procedure. Also not with DBMS_Space package. howq is it possible plz let me know.
Thanks
./mk
|
|
|
Re: Table Stats [message #23122 is a reply to message #23120] |
Tue, 19 November 2002 06:54 |
|
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
i beleive, unless u enable auditing or some kind of counter ( triggers?) you can't get that kind of information.
an option is to anaylyze the table and look into the statistics in DBA_TABLES. event that, will be not be that accurate.
but something like this is possible(its different case, as im not looking into ACTUAL ROWS inserted)
the displayed text is partial output of my monthly report script
********************
Database growth rate
********************
MONTH_YEAR GROWTH_IN_MEG
-------------- -------------
July 2002 1,536
June 2001 2,925
May 2002 1,500
November 2002 6,344
October 2002 50
-------------
sum 12,355
|
|
|