Re: General Instance Performance Monitoring

From: Yong Huang <yong321_at_yahoo.com>
Date: Wed, 2 Apr 2008 13:47:01 -0700 (PDT)
Message-ID: <829813.89819.qm@web80605.mail.mud.yahoo.com>

John,

I just wrote a note "Process-Oriented Performance Monitoring" to bring to DBAs' attention that general instance performance monitoring is inadequate and process or session specific data must be acquired. The example script is meant to be lightweight yet essential. Some comments may be interesting in general, such as querying v$sqlstats in 10g instead of v$sql, cross-reference of `top' and Oracle sessions, etc. See
http://yong321.freeshell.org/computer/Perfmon.html

Yong Huang

> From: John Brown <oradbaus_at_hotmail.com>
>
> 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.

---

You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost. http://tc.deals.yahoo.com/tc/blockbuster/text5.com

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

Received on Wed Apr 02 2008 - 15:47:01 CDT