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连接