ashmasters.com : Simulating ASH and ASH Analysis
From: kyle Hailey <kylelf_at_gmail.com>
Date: Mon, 2 Jun 2008 10:47:52 -0700
Message-ID: <6f373fd20806021047l11b48a6ds1fbbd380c4f10361@mail.gmail.com>
Date: Mon, 2 Jun 2008 10:47:52 -0700
Message-ID: <6f373fd20806021047l11b48a6ds1fbbd380c4f10361@mail.gmail.com>
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.
Best
Kyle
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jun 02 2008 - 12:47:52 CDT