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: "Pradeep Chetal" <Pradeep.Chetal@xxxxxxxxxxxxxx>
  • To: <tim@xxxxxxxxx>
  • Date: Tue, 4 Nov 2008 12:56:56 -0500


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@xxxxxxxxx]
Sent: Tuesday, November 04, 2008 12:22 PM
To: Pradeep Chetal
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx
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

image/com

Other related posts: