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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie question: What is "SQL*Net roundtrips to/from client" in the utlestat report

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Thu, 17 Jul 2003 20:17:27 +0200
Message-ID: <avpdhvcv517qe3eoaqc9vsdaeaafa3uknt@4ax.com>

On 17 Jul 2003 09:14:32 -0700, yanivv_at_savantis.com (Yaniv) wrote:

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

When the database sends data to the client, it sends a message. Reception of the data is confirmed by the client. The two messages together constitute a roundtrip

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Jul 17 2003 - 13:17:27 CDT