A nice script ...
Regards
MOHAMMAD RAFIQ
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 28 Aug 2001 08:16:17 -0800
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.ph
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 tablesp
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
w
);
END LOOP;
end;
-Ursprungligt meddelande-
Från: Denmark 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
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 growt
Analyze tables then look at dba_tables.num_rows. Doing it on a daily will
give you what you want.
HTH,
Michael
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, August 27, 2001 15:58
> Hi DBA's
>
> Does an Oracle Stored Procedure or funct
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 kno