Professional Web Applications Themes

Newbie question: What is "SQL*Net roundtrips to/from client" in the utlestat report - Oracle Server

[email]yanivvsavantis.com[/email] (Yaniv) wrote in message news:<2a8fcd9.0307170814.36fc2cffposting.google.c om>... > Hi, > > I am new to oracle. > I've started learing about performance and tuning and i've created the > utlb/utle report. > > I could not understand what does the parameter "SQL*Net roundtrips > to/from client" stands for and what are its units. > > I would very much appreciate any answer regatding it. > > Thanks. upload your output to OraPerf ([url]http://www.oraperf.com[/url]) for a good start. Hotsos ([url]http://www.hotsos.com[/url]) is a good place for Performance Tuning Papers. Basically, a sqlnet roundtrip means that a client application exchanged data with the ...

  1. #1

    Default Re: Newbie question: What is "SQL*Net roundtrips to/from client" in the utlestat report

    [email]yanivvsavantis.com[/email] (Yaniv) wrote in message news:<2a8fcd9.0307170814.36fc2cffposting.google.c om>...
    > Hi,
    >
    > I am new to oracle.
    > I've started learing about performance and tuning and i've created the
    > utlb/utle report.
    >
    > I could not understand what does the parameter "SQL*Net roundtrips
    > to/from client" stands for and what are its units.
    >
    > I would very much appreciate any answer regatding it.
    >
    > Thanks.
    upload your output to OraPerf ([url]http://www.oraperf.com[/url]) for a good
    start.
    Hotsos ([url]http://www.hotsos.com[/url]) is a good place for Performance Tuning
    Papers.

    Basically, a sqlnet roundtrip means that a client application
    exchanged data with the oracle server over an oracle client
    connection. once. This may have consisted of multiple packets any
    number of which could have been dropped and resent. Net8 is largely
    ignorant as to what occurs at layers in the OSI stack underneath -
    that is how it is able to run over a variety of protocols. If you run
    a 10046 trace at level 8 (waits) you'll see the individual wait events
    in the trace file.

    If your SDU/TDU is set to the default value (2048 bytes) then you are
    going to have far more sqlnet round trips than if your SDU/TDU is set
    to a non-default value, such as 8192 bytes.

    have fun.

    Pd
    Paul Drake Guest

  2. #2

    Default Re: Newbie question: What is "SQL*Net roundtrips to/from client" in the utlestat report

    I didn't quite yet understand -
    is roundtrips parameter an average count of packaets per
    logon/transaction, etc?
    or is it reponse-time per packet?

    btw reposne-time, is there a parameter in the oracle server level that
    measure end-to-end response time?
    Yaniv Guest

  3. #3

    Default Re: Newbie question: What is "SQL*Net roundtrips to/from client" in the utlestat report

    > > btw reposne-time, is there a parameter in the oracle server level that
    > > measure end-to-end response time?
    If you are using the Oracle Forms Server you can get the actual
    end-to-end response time from the log file.

    You can code it yourself, or use a tool like this one:

    [url]http://www.dba-oracle.com/monitoring_formspack.htm[/url]
    Jitendra Patel Guest

Similar Threads

  1. Question on "Printable report by ColdFusion -> Flash"
    By Dick Chong in forum Coldfusion Flash Integration
    Replies: 0
    Last Post: July 29th, 04:25 AM
  2. Newbie question: How can I create a "tiled" background?
    By michaaal in forum Macromedia Flash
    Replies: 2
    Last Post: April 2nd, 06:05 AM
  3. Replies: 10
    Last Post: November 17th, 11:34 AM
  4. Newbie Question - "trusted SQL Server connection"
    By Greg Smith in forum ASP.NET Security
    Replies: 1
    Last Post: August 20th, 06:43 PM
  5. Replies: 0
    Last Post: January 9th, 06:19 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139