Re: question about statspack

From: John Kanagaraj <>
Date: Wed, 12 Mar 2008 17:51:05 -0700
Message-ID: <>


You did not mention the Database version, but if it is 10g, then the
*spread* of timings for various events is provided in snapshots of
V$EVENT_HISTOGRAM. Look for skews in snapshots of this view. Unfortunately, STATSPACK in 10g records this while AWR does not.

John Kanagaraj <><
DB Soft Inc (Sorry - not an Oracle blog!)

** The opinions and facts contained in this message are entirely mine
and do not reflect those of my employer or customers ** --
Received on Wed Mar 12 2008 - 19:51:05 CDT

Original text of this message