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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
