FAQ
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).

Search Discussions

  • Tim Gorman at May 30, 2002 at 12:58 pm
    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"
    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

    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).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Tim Gorman
    INET: Tim_at_SageLogix.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).
  • Ray Stell at May 30, 2002 at 1:03 pm
    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

    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).
    --
    ===============================================================
    Ray Stell stellr_at_vt.edu (540) 231-4109 KE4TJC 28^D
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Ray Stell
    INET: stellr_at_cns.vt.edu

    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).
  • Jack van Zanen at May 30, 2002 at 1:08 pm
    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

    .com> cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL)
    Sent by: Subject: Wait time for "SQL*Net message"
    root_at_fatcity.com

    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

    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).

    ==================================================================
    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
    algemene voorwaarden worden u op verzoek kosteloos toegezonden.
    =====================================================================
    The information contained in this communication is confidential and is
    intended solely for the use of the individual or entity to whom it is
    addressed. You should not copy, disclose or distribute this communication
    without the authority of Ernst & Young. Ernst & Young is neither liable for
    the proper and complete transmission of the information contained in this
    communication nor for any delay in its receipt. Ernst & Young does not
    guarantee that the integrity of this communication has been maintained nor
    that the communication is free of viruses, interceptions or interference.

    If you are not the intended recipient of this communication please return
    the communication to the sender and delete and destroy all copies.

    In carrying out its engagements, Ernst & Young applies general terms and
    conditions, which contain a clause that limits its liability. A copy of
    these terms and conditions is available on request free of charge.
    ===================================================================

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Jack van Zanen
    INET: nlzanen1_at_EY.NL

    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).
  • Rachel Carmichael at May 30, 2002 at 2:43 pm
    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 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).
  • Sherman, Edward at May 30, 2002 at 6:48 pm
    * * * * 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: shermanej_at_eccic.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).
  • Danisment Gazi Unal (ubTools) at May 30, 2002 at 8:07 pm
    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: 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).
    --
    Danisment Gazi Unal
    http://www.ubTools.com

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Danisment Gazi Unal (ubTools)
    INET: dunal_at_ubTools.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).

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedMay 30, '02 at 11:58a
activeMay 30, '02 at 8:07p
posts7
users7
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase