Why command and seconds_in_wait are both greater than 0 in v$session
Hi,
DB: 11.1.0.7.0 64bit Standard Edition on RedHat Enterprise Linux 5.3
In what situation can the command and seconds_in_wait be both greater than 0 in v$session while the event is "SQL*Net message from client"?
USERNAME SID SERIAL# COMMAND SQL_STAR PREV_EXE EVENT WAIT_TIME SECONDS_IN_WAIT
-------- ---------- ---------- ---------- -------- -------- ----------------------------------- ---------- ---------------
CUE 85 62890 3 16:44:47 SQL*Net message from client 0 472
CUE 127 62676 3 16:52:34 16:52:34 SQL*Net message from client 0 3
In my understanding, the event "SQL*Net message from client" means Oracle is waiting for new command from user, and the command=3 means Oracle is "selecting" data. And select won't be blocked ever.
DB: 11.1.0.7.0 64bit Standard Edition on RedHat Enterprise Linux 5.3
In what situation can the command and seconds_in_wait be both greater than 0 in v$session while the event is "SQL*Net message from client"?
USERNAME SID SERIAL# COMMAND SQL_STAR PREV_EXE EVENT WAIT_TIME SECONDS_IN_WAIT
-------- ---------- ---------- ---------- -------- -------- ----------------------------------- ---------- ---------------
CUE 85 62890 3 16:44:47 SQL*Net message from client 0 472
CUE 127 62676 3 16:52:34 16:52:34 SQL*Net message from client 0 3
In my understanding, the event "SQL*Net message from client" means Oracle is waiting for new command from user, and the command=3 means Oracle is "selecting" data. And select won't be blocked ever.
0