Are you certain the connection isn't going thru the listener? Check tnsnames.ora and verify that PROTOCOL=BEQ.
[EMAIL PROTECTED] wrote: > > A developer/analyst was running 4 reports on our datawarehouse, connecting > locally using SQL Plus from a telnet session on the Unix box. He then > started 4 queries, spooling the output to the unix server (again, local). > > He was curious as to why the sessions were both taking so long and why they > alternated between showing as Active and Inactive in v$session. > > When I checked v$session_wait for his sessions I saw that they were a mix of > SQL*Net message from client > and > SQL*Net message to client > > Since he's not connecting through the listener, why would this wait event > show up? There should be no network activity at all (I double checked that > the SQL is not using any database links). Any ideas? > > Oracle 8.1.6.2 > Solaris 2.6 > > Thanks, > Jay Miller > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Suzy Vordos INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
