How are Oracle Tools for capturing historical performance data?
I have been demoing DBFlash and it seems really cool for identifying
troublesome wait events over various time periods. Do any of Oracle's
tools do anything similar? (Oracle Expert, SQL Analyze, Performance
Manager, etc...)
I just started reading the book "Oracle Wait Interface: A practical
Guide to Performance Diagnostics & Tuning" and they have a technique
using a database logoff trigger as a performance data collector. I will
have to see how beneficial this is for monitoring our PeopleSoft Apps.
It's a pretty good book so far.

Thanks, Roger

RogBaker@gmail.com wrote:

> How are Oracle Tools for capturing historical performance data?

Great. In 10g look at AWR and ASH.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)