Wait time for "SQL*Net message"

From: S B <bhulubhuli_at_yahoo.com>
Date: Thu, 30 May 2002 03:58:31 -0800
Message-ID: <F001.0046F465.20020530035831@fatcity.com>

The following statistics is for a
server-side application ( pro*c ). The connection is established between proc*c to server as "LOCAl=yes and PROTOCOL=BEQ(sqlplus usr/pass) i.e bypassing the tnsnames.ora and listener.ora

Event                            Wait(cs)  %wait
-----------------------------------------------------------
SQL*Net message from client      463790	61.85186173
CPU used by this session         229327	30.5834578
SQL*Net more data to client      32388	4.319321455
db file sequential read          21698	2.893683986
log file sync                    1788	0.23845087
SQL*Net message to client        530	0.070681745
log file switch completion       188	0.025072015

Can anyone tell me about how to reduce the wait time for "SQL*Net message"

TIA
Bhulu

---

Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: S B
  INET: bhulubhuli_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (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). Received on Thu May 30 2002 - 06:58:31 CDT