Re: Script Determine Which TableSpaces > 90% Full

melliott42_at_yahoo.com (Michael) wrote in news:91721cf.0407151650.4eaab67e_at_posting.google.com:

> Hello,
>
> I have been tasked with creating a .sql script to determine which
> TableSpaces in a database are > 90% full. This script must work on
> both Oracle8 and Oralce9 systems.

Ratios can be meaningless indicators of performance.

I create tablespaces based upon the "size" of the object it will hold in fixed/uniform extent sizes
Small - 128K
Medium - 4M
Large - 128M

I have a SMALL tablespace that is 2GB is size; which means it can hold 16384 extents.
At the 90% full mark it still has room for 1638 extents. At the present growth rate, this tablespace won't fill up for a decade. The alarm threshold needs to take into account the growth rate of the objects in the tablespace along with other factors. Otherwise you might get the alarm message seconds before slamming into the wall. Received on Thu Jul 15 2004 - 20:11:51 CDT