Re: SQL*Net message from client waits on local import

From: Yong Huang <>
Date: Sun, 8 Jun 2008 19:40:22 -0700 (PDT)
Message-ID: <>


In addition to what Cary said, you can tell what protocol "SQL*Net message to (or from) client" waits are really using by looking at its p1 value, preferably in hex:

$ sqlplus user/pass

SQL> select p1raw from v$session where sid = 2186;



62, 65, 71 in hex are beq in ASCII. 2186 is my current session connected locally, sqlplus user/pass. SQL*Net does not necessarily mean TCP, at least in this context.

Yong Huang       

Received on Sun Jun 08 2008 - 21:40:22 CDT

Original text of this message