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

Steve,

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;

P1RAW

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       

--
http://www.freelists.org/webpage/oracle-l