Re: How to find database Object growth

From: Igor Laletin <ilaletin_at_usa.net>
Date: 24 Apr 2002 05:16:24 -0700
Message-ID: <f9226414.0204240416.c6d54ae@posting.google.com>

rk_oracle_at_yahoo.com (Rajesh) wrote in message news:<12e37fd7.0204231443.60ff8ee9_at_posting.google.com>...
> Hi
>
> How we can find the Historical Object Growth in a database.

You may want to have a look at Capacity Planner from OEM Diagnostics Pack.

> Anyone has a script to do this?.

Well, many dbas collect historical data so, yes, such scripts exist. Still you may be better off writing your own version. It's easier to schedule a job to select bytes, extents, etc from dba_segments than to review someone else's code.

I do have a few ksh scripts to collect hp-ux, oracle and tuxedo stats and to load them into a database. Apache and htp/htf packages are used to provide a (very basic) interface to data via browser. I use it when a client doesn't have a real tool. But ... are you willing to check if the scripts work well in your flavour of unix, download/compile gnuplot (for graphs), patch zlib, configure environment (no real docos), etc? Probably not.

>
> Thanks in Advance.
>
> RK

Cheers,
Igor Received on Wed Apr 24 2002 - 07:16:24 CDT