: Simulating ASH and ASH Analysis

From: kyle Hailey <>
Date: Mon, 2 Jun 2008 10:47:52 -0700
Message-ID: <>

New blog from John Beresniewicz, Graham Wood and I dedicated to ASH or Active Session History.
Included on the blog are queries on ASH to give

   Overview of database performance
   Aggregations of top sql, session, package, procedure    Drilldowns into information on buffer busy waits, IO, Locks etc

as well as tools to

   simulate ASH ( a licensed option on 10g) on any version of Oracle from v7 on up

   graphically monitor ASH ( like OEM 10g, another licensed option) via 10g ASH or simulated ASH (S-ASH)

The idea of the blog is a to create a place to exchange ideas on how to best harness this new powerful, multidimensional datasource for performance monitoring and tuning.


Received on Mon Jun 02 2008 - 12:47:52 CDT

Original text of this message