Re: General Instance Performance Monitoring

  • From: Yong Huang <yong321@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 2 Apr 2008 13:47:01 -0700 (PDT)


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

Yong Huang

> From: John Brown <oradbaus@xxxxxxxxxxx>
> 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.

Other related posts: