Hi Friends.
I queried v$session wait to see tjose active sessons waiting or an event.
Most sessions have SQL*Net message from client event (server process waiting for for client process to arrive)
The statistics are as follows.
SID EVENT SEQ# P1 P2 P3 WTime
---- ------------------------------ ------ ----------- ----------- ----- ------
35 SQL*Net message from client 56992 1413697536 1 0 0
36 SQL*Net message from client 268 1413697536 1 0 0
37 SQL*Net message from client 732 1413697536 1 0 0
Can anyone tell me what the 3 parameter columns detail and also interpret the wait time. Does a wait time of 0 mean that it is currently waiting or has waited for 0 seconds ?
Thanks
Suresh
Once you have eliminated all of the impossible,
whatever remains however improbable,
must be true.