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: Tim Gorman <>
Date: Tue, 04 Nov 2008 10:21:57 -0700
Message-ID: <>



Search MetaLink for the RDA overview (note #314422.1) -- the RDA version for RAC merits its own note #359395.1.

One portion of RDA is the "health check validation engine" (HCVE) which is documented in MetaLink note #250262.1, which will explain how to run the RDA script with the "-T hcve" option, which will then provide a list of validation scripts depending on whether you are checking the RDBMS, app server, portal, etc.

The old "" scripts are still available for download, and while these have the advantage of being easier to install and run, they are also no longer maintained and are quite out-of-date (i.e. 2004-2006 timeframe is most up-to-date).

Hope this helps...
Tim Gorman
consultant - Evergreen Database Technologies, Inc.
P.O. Box 630791, Highlands Ranch CO  80163-0791
website   =
email     =
mobile    = +1-303-885-4526
fax       = +1-303-484-3608
Yahoo IM  = tim_evdbt

Pradeep Chetal wrote:


We have a 3-tier application and in some installations, the customer is responsible for DB installation/upgrades. There have been times that we have found issues in the DB installation which make the application come to a crawl.


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?




-- Pradeep

Pradeep Chetal
Sr. Director - Infrastructure Architecture

Mformation Technologies Inc.
Switchboard: +1 732 692 6200


Visit WWW.MFORMATION.COM and see how the MFORMATION SERVICE MANAGER can help you to transform your business

Please consider the environment before printing

-- Received on Tue Nov 04 2008 - 11:21:57 CST

Original text of this message