Re: question about statspack
Date: Wed, 12 Mar 2008 17:51:05 -0700
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 http://www.linkedin.com/in/johnkanagaraj http://jkanagaraj.wordpress.com (Sorry - not an Oracle blog!)Received on Wed Mar 12 2008 - 19:51:05 CDT
** The opinions and facts contained in this message are entirely mine
and do not reflect those of my employer or customers ** -- http://www.freelists.org/webpage/oracle-l