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
Date: Tue, 04 Nov 2008 10:21:57 -0700
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 "validate.pl" 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 = http://www.EvDBT.com/ email = Tim@EvDBT.com mobile = +1-303-885-4526 fax = +1-303-484-3608 Yahoo IM = tim_evdbt
Pradeep Chetal wrote:
-- http://www.freelists.org/webpage/oracle-l Received on Tue Nov 04 2008 - 11:21:57 CST
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?
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