Re: Is there a list of things (automated tool or otherwise) to see if a DB install done by someone else is reasonably good (performance wise) for an application

From: Jared Still <>
Date: Tue, 4 Nov 2008 09:12:26 -0800
Message-ID: <>

On Tue, Nov 4, 2008 at 8:53 AM, Pradeep Chetal <> wrote:

> Is there any automated tool or a list of things to check to see if a DB
> installation (RAC or otherwise) is in decent condition and none of the
> obvious things are missing?

IMO that would be highly dependent on your definition of 'decent condition'.

Only some things are obvious outside the context of an application:

  • no invalid objects
  • enough room to grow a bit, and this is very subjective.

You would need to supply a list of parameters that are required for the applications in question:

* pool sizes ( if manually managing memory)
* db_cache_size
* sga_maxsize
* sga_target (if using AMM)

Whether there are any apps that automate this, I don't know.

Personally, I would write my own, as canned apps for database management tend to be unwieldy.

It probably wouldn't be too difficult to do this with a standardized text file for
configuration, and a SQL script and shell script driver.

Though personally I would use Perl for something like this.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Received on Tue Nov 04 2008 - 11:12:26 CST

Original text of this message