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