Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: wait events and v$session_event
wait time vs. service time has appeared here a few times lately.
I believe Cary addressed this in another thread today.
service time = amount of time required to complete a task.
eg. db_file_scattered read.
wait time = amount of time spent waiting for a resource to become available
eg. buffer busy waits
Oracle reports disk reads as wait events, but the time includes service time.
Jared
<ryan.gaffuri_at_cox.net>
Sent by: oracle-l-bounce_at_freelists.org
05/11/2004 07:32 AM
Please respond to oracle-l
To: oracle-l_at_freelists.org cc: Subject: wait events and v$session_event
I have one batch process running and there are alot of waits. I thought waits were caused by concurrency?
If this is unreadable, please ignore. Hard to format with web email. Basically, I have large waits for DB_FILE_SCATTERED_READ, DB_FILE_SEQUENTIAL_READ, and for RAC Cache Fusion due to the load balancing.
SID EVENT TOTAL_WAITS TOTAL_TIMEOUTSTIME_WAITED AVERAGE_WAIT MAX_WAIT TIME_WAITED_MICRO
![]() |
![]() |