Nope. That version of v$system_event would also show me the max wait that was done on an event, and not just the total time waited. Its there in his book, somewhere in a chapter that also talks of v$filestat and IO tuning, I think.RajConnor McDonald
Sent by: root@fatcity.com02/09/2002 10:28 AM PSTPlease respond to ORACLE-L To: Multiple recipients of list ORACLE-L cc: bcc: Subject: Re: Skewed Wait Times You're thinking of v$mystat, but v$session_event isavailable in 'vanilla' oracle.hthconnor --- Rajesh.Rao@jpmchase.com wrote: > 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@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@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).=====Connor McDonaldhttp://www.oracledba.co.uk (mirrored athttp://www.oradba.freeserve.co.uk)"Some days you're the pigeon, some days you're the statue"__________________________________________________Do You Yahoo!?Everything you'll ever need on one web pagefrom News and Sport to Email and Music Chartshttp://uk.my.yahoo.com--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: =?iso-8859-1?q?Connor=20McDonald?= INET: hamcdc@yahoo.co.ukFat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: Rajesh.Rao@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@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 - 19:56:47 CST
