| What do Oracle waits mean [message #332161] |
Mon, 07 July 2008 13:26  |
lunaut
Messages: 6
Registered: July 2008
|
Junior Member |
|
|
I am a bit confused with definition Oracle waits. For instance, OEM or other Oracle tools indicate that a session has a long wait. There could be 3 cases
1) it is waiting for resources used by other session, more like a blocking
2) waiting for Oracle complete the job for it, like loading data blocks (disk io)
3) combination of the above 2.
In this case how to tune the query. For case 1, we should tune the blocking session, and we can identify the blocking session in v$session. For 2, this very query need to be tune.
The confusion is if a session waits for a long time and no blocking session is found, does it mean that this query causes much the overheads. In other words, we can identify the heavy queries for tuning by the longest nonblocking waits.
Thanks
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
