Re: Wait time for SQL*Net message
Make your PRO*C program faster. The wait-event SQL*Net message from client on the server-side is indicating that 61% of time is spent waiting for the client-side to say something, anything... Seeing the SQL*Net more data to client wait-event indicates that you're probably using array-fetching already, no? Spend some time with a profiler utility (i.e. standard UNIX prof utility?) to understand where your client-side C program is spending all that time... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 5:58 AM 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 EventWait(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 sync1788 0.23845087 SQL*Net message to client530 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman 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).
Re: Wait time for SQL*Net message
10 Gigabit Ethernet ;) On Thu, May 30, 2002 at 03:58:31AM -0800, S B 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 EventWait(cs) %wait --- SQL*Net message from client 463790 61.85186173 CPU used by this session 229327 30.5834578 SQL*Net more data to client 323884.319321455 db file sequential read 216982.893683986 log file sync1788 0.23845087 SQL*Net message to client530 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). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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).
Re: Wait time for SQL*Net message
Hi Type more and a lot faster and hit more enters while sending querries to the database. :-) I would not worry about SQL*Net message from client, it simply means that your client has received the data from the last request and now the server is waiting for the next. If you have a sql*plus session open it useually just sits there doing nothing (generating SQL*Net message from client events) There are some exceptions as somebody on the list recently pointed out (forgot who but would guess mr.Wilton) Jack S B bhulubhuli@yahooTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .comcc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: Wait time for SQL*Net message [EMAIL PROTECTED] 30-05-2002 13:58 Please respond to ORACLE-L 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 EventWait(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 sync17880.23845087 SQL*Net message to client530 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). == De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
Re: Wait time for SQL*Net message
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 EventWait(cs) %wait --- SQL*Net message from client 463790 61.85186173 CPU used by this session 229327 30.5834578 SQL*Net more data to client 323884.319321455 db file sequential read 216982.893683986 log file sync1788 0.23845087 SQL*Net message to client530 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).
RE: Wait time for SQL*Net message
* * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552 (b) (4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward 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).
Re: Wait time for SQL*Net message
Hi, I always see "SQL*Net message from client" as a problem if I see "SQL*Net message to client" is a problem. Of course, this can not be a rule, but may be useful in practice to start a performance analysis. In your case "SQL*Net message to client" is 5.30 seconds. It's too low for your case. But your "SQL*Net more data to client" is 323.88 seconds = 5.398 minutes. Although it looks like a problem, I think it's a consequence. Of course you can tune your array operations to client. But, important thing here is that if you need to send many SQL*Net packets to client ??? I mean do you need to process many Oracle blocks. If you can reduce number of Oracle blocks processed by you, this will reduce both "SQL*Net more data to client" and "CPU used by this session". Important thing in your statistics is that your "CPU used by this session" is 2293.27 seconds= 38 minutes. What was the interval of your observation ? how many CPU have you got ? is there a bottleneck in CPU ? Bottlenecks in CPU causes distorted Oracle wait measurements. Some of time are missed, some of time are assigned to Oracle wait events. As a result Oracle waits may become overvalued. There is a sample in my paper MRRP (not published yet). In this sample, "buffer busy waits" is measured 260.54 seconds by Oracle, but it was 112.03 seconds in practice. That means 57% of "buffer busy waits" is measured wrong by Oracle because of a bottleneck in CPU. regards... danisment http://www.ubtools.com S B 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). -- Danisment Gazi Unal http://www.ubTools.com
