Re: SQL*Net message from client waits on local import
Date: Sun, 8 Jun 2008 19:40:22 -0700 (PDT)
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 HuangReceived on Sun Jun 08 2008 - 21:40:22 CDT