Weatherburne [mailto:[EMAIL PROTECTED]]
Skickat: den 28 augusti 2001 0:59
Till: Multiple recipients of list ORACLE-L
Ämne: Efficient way to monitor table growth...
Hi DBA's
Does an Oracle Stored Procedure or function exist that returns the row count
by table in each tablespace?
I've observed
Here's a script (for Oracle 8) that will show you exactly how much space a
given table uses, as opposed to how much space its extents have reserved.
It takes one parameter, the name of the table being looked at. It can take
a long time to run so I'm not sure if that counts as efficient. If you
I have a script I wrote a while ago that may be of some use. If you goto:
http://www.vampired.net/scripts/php/tablespace.php
And look at FreeSpace by Tablespace script it is very useful.
I will return:
Tablespace Name
Total Mb
Free Mb
Used Mb
Percentage Free
Total Objects
For all your
Hi DBA's
Does an Oracle Stored Procedure or function exist that returns the row count
by table in each tablespace?
I've observed that one of our production tablespaces is has only 8% free
space. Perhaps it could be fragmented. I'll have to find a script that can
provide these statistics. I
In general, you don't need to know the rowcounts
if you know the typical size of a row and the total
space usage for a table/index. An analyze will
get you these figures as a starting point.
After that, you need only track the object's
high water mark using the dbms_space package
to track