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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > 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: [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). __________________________________________________ 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: [EMAIL PROTECTED] 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: [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).
