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

Tim,  

This is excellent. As Jared said, start from an older version and improve it locally, and learn along the way.  

As someone else mentioned, will go thru RDA also.  

Thanks,  

• Pradeep

  ---

From: Tim Gorman [mailto:tim_at_evdbt.com] Sent: Tuesday, November 04, 2008 12:22 PM To: Pradeep Chetal
Cc: oracle-l_at_freelists.org
Subject: 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  

Pradeep,

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_at_EvDBT.com
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?  

Thanks,  

• Pradeep

Pradeep Chetal
Sr. Director - Infrastructure Architecture

Mformation Technologies Inc.
Switchboard: +1 732 692 6200  

Visit WWW.MFORMATION.COM
<mailbox://C%7C/Documents%20and%20Settings/Tim%20Gorman/Application%20Da ta/Thunderbird/Profiles/cjwu3zzh.default/Mail/Local%20Folders/Inbox.sbd/ ORACLE-L?number=52820806&header=quotebody&part=1.2> and see how the MFORMATION SERVICE MANAGER can help you to transform your business

Please consider the environment before printing  

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

Please consider the environment before printing

--
http://www.freelists.org/webpage/oracle-l