Re: How to capture information to analyze high load peak?

AnySQL (d.c.b.a) wrote:
> Hi all:
>
> When managing a lot of databases, some databases always hit
> short-time load peak, it's hard to monitor, so need to write program to
> capture the information to analyze it to find the root cause of the
> load peak.
>
> What information usually required? Any currently avaiable tools?
>
>
> anysql from china
> http://www.anysql.net/en/

9i ... Learn StatsPack ... Tom Kyte recommends running it routinely every 15-20 minutes

10g ... Learn to use AWR ... Use DBMS_WORKLOAD_REPOSITORY package to alter default behavior to take snapshots every 15-20 minutes.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)