Re: bstat and estat

On Wed, 13 Nov 2002 16:00:24 -0500, "Jerry D" <jdubuke_at_notme.gpdservices.com> wrote:

>I looked on tahiti and it did not talk about 8.0.6, so I am still looking
>for information regarding sql*net and any tuning parameters I can use to
>make my system more efficient!

There are 2 main gotcha's when using sql*net. 1 - your SDU (session data unit) isn't a multiple of the Max Transmission Unit of the network card (usually 1500 for ethernet). The default SDU is 2048
The SDU applies to both sqlnet 2 and net8, so just read the Net8 administrators manual, on how to set it in listener.ora on the server and tnsnames.ora on the client
2 You aren't using array fetches, so you get a round trip for every individual record.

If you are severely suffering from sql*net problems, most likely 2) applies.
This points to an application not using Oracle features, which is regrettably a way too common problem.

Apart from the 2 issues outlined above, you can't 'tune' anything.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Nov 13 2002 - 15:26:24 CST