Oracle-L: forecasting db growth

From: Jeroen van Sluisdam <jeroen.van.sluisdam_at_vrijuit.nl>
Date: Wed, 26 Jun 2002 06:58:24 -0800
Message-ID: <F001.004887F3.20020626065824@fatcity.com>

Hi,

I have build a script in order to predicate db growth. It calculates the current size in use of a tablespace, the growth since the last day, stores it in a table.

A select can then calcultate a predication based on this data and the size of the tablespace
for how many time is left with this space. Unfortunately this doesn't work when tables are not uniformly sized and this is the case here. I'm looking for ways to improve this and 1 way might be calcultating with most likely
tables to have new extents. Any ideas about this?

Second question related to this, how can I see for which tables, indexes extents have been created recently?

Details: Oracle 7.3.4, HP-UX 10.20

Tia,

Jeroen
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Jeroen van Sluisdam
INET: jeroen.van.sluisdam_at_vrijuit.nl

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Jun 26 2002 - 09:58:24 CDT