SQL*Net message from client The server process (foreground process) waits for a message from the client process to arrive.
Wait Time: The time it took for a message to arrive from the client since the last message was sent to the client
数据库后台进程等待客户端进程数据的发送,等待时间是指等待自上一次客户端数据发送后数据到达花费的时间。
SQL*Net message from client :
SQL> set linesize 200
SQL> select sid,event,p1,p2,p3 from v$session where sid=299;
SID EVENT P1
P2 P3
---------- ---------------------------------------------------------------- ---------- ---------- ----------
299 SQL*Net message from client 1413697536
1 0
SQL*Net message from client ;
SQL> select name,PARAMETER1,PARAMETER2,PARAMETER3 from v$event_name where name='SQL*Net message from client';
NAME PARAMETER1 PARAMETER2 PARAMETER3
------------------------------ ---------- ---------- ----------------------------------------------------------------
SQL*Net message from client driver id #bytes
表示会话正在等待客户端端要求会话做事情
P1:1413697536 表示TCP连接