Re: General Instance Performance Monitoring

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Tue, 1 Apr 2008 22:35:57 +0100
Message-ID: <7765c8970804011435v457c5df1k2894a270a07d6c58@mail.gmail.com>


I'd say OEM (memo to self make sure none of the OakTable sees this - ooops) as an interface to ASH, with one *huge* caveat that of cost. ASH measures pretty much the right things whereas statspack and AWR (as generally delivered) don't. OEM makes it really really clear in nearly all cases where you should be looking. If you are a command and script person (as I am) then you really really have to compare and contrast fault finding using the OEM and ASH combo to your old scripts. Better yet get a newish dba or developer to walk through the same exercise.

Niall

On Tue, Apr 1, 2008 at 1:29 PM, John Brown <oradbaus_at_hotmail.com> wrote:

> Hi guys,
>
> What is the best tool to use for general instance performance monitoring:
> statspack or awr? It seems that these both tools produce nearly identical
> reports. However awr requires additional licensing to access dba_hist views.
> What is the difference? Is anyone using spViewer or similar tools to perform
> analysis of database performance problems?
> Thanks.
>
>
> ------------------------------
> Discover the new Windows Vista Learn more!<http://search.msn.com/results.aspx?q=windows+vista&mkt=en-US&form=QBRE>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Apr 01 2008 - 16:35:57 CDT

Original text of this message