Skewed Wait Times

From: <Rajesh.Rao_at_jpmchase.com>
Date: Sat, 09 Feb 2002 01:44:08 -0800
Message-ID: <F001.0040B208.20020209013318@fatcity.com>

Hello All,

After setting timed_statistics to true, I am finding something strange with the wait times in v$system_event for the event 'db file sequential read'. The wait times far exceed the uptime of the database. What I can think of is, say there are 10 sessions waiting for a single hot block for say 1 ms. The wait is actually for 1ms, but for the 10 sessions it add to 10ms.

Or that the times are skewed. I remember reading about this in 'Practical Oracle 8i' where Jonathan Lewis had addressed these issues. There was also a script in there to create your own version of v$system_event, reading from two x$ tables. I dont have the book handy with me now. Would someone be kind enough to forward the same to me?

Thanks
Raj

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: Rajesh.Rao_at_jpmchase.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Sat Feb 09 2002 - 03:44:08 CST