depends on what is causing the wait time. if it's because this is an
interactive application and you are waiting for the person to enter
data into the screen, teaching them to type faster would do it. :)
it could be your network lag time or the processor speed on the machine
that is the client. You have to find out what is causing it before you
can speed it up. There may actually be nothing you can do, or as Cary
Millsap pointed out in another post to this list, this "idle wait"
might actually be something you can speed up
- S B <bhulubhuli_at_yahoo.com> wrote:
> 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).
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: Rachel Carmichael
INET: wisernet100_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 - 09:43:44 CDT