Definition of wait event [message #343639] |
Wed, 27 August 2008 13:13 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
lunaut
Messages: 6 Registered: July 2008
|
Junior Member |
|
|
The definition of WAITS is not quite clear to me. As I read from an article : At any given Moment, every Oracle process is either serving a request or waiting for something specific to happen. If a process is searching the buffer cache for certain data block, it is busy. The ARCO process is said waiting when it is waiting for LGWR to signal that an online redo log needs archive.
Then if a process is searching/loading data blocks from disk, is it also BUSY, or waiting? I guess it is waiting, as there is a waiting class 'User IO'. Why serching buffer cache is BUSY while searching/loading disk is WAIT? Just because disk IO take longer?
I have a session which has the wait events ‘db file sequential read’ and the wait class is User I/O. Does the session wait for the data blocks it requires to load to the memory from disk, or its request is waiting in queue for other process’s disk IO to finish.
If it is waiting for disk IO of other processes, shall we say that is BLOCKING? If so we need to tune sql statement of the other processes. But how to find the sessions/queries that are waited for?
Thanks
|
|
|
|
|
Re: Definition of wait event [message #344071 is a reply to message #343639] |
Thu, 28 August 2008 13:06 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
lunaut
Messages: 6 Registered: July 2008
|
Junior Member |
|
|
I read the guild and believe my post followed it.
How can I get a simple answer on 'A wait event means a session is waiting for its own job, like disk IO, or waiting for other's session?'?
I did search the docs, and web, some docs imply that the wait is on it self's action. But would that means BUSY?
|
|
|
|
Re: Definition of wait event [message #344077 is a reply to message #344071] |
Thu, 28 August 2008 13:16 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68678 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Each process is either:
- non-existent
- busy
- waiting
If it exists and is not executing cpu instructions then it is waiting, if it is waiting for something then it is not busy.
Do this answer your question?
Regards
Michel
|
|
|