SQL*Net message from client

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