Re: Tuning in Oracle

Sanjeev,

The high number of messages are just messages from sqlplus or another program to say that the process needs more data or to say that all has gone right.

You should look at the more data to client value if that is quite high and you are running SQL*NET V2 you might want to adjust your SDU size.

SQL*NET V2 has a SDU-size of 2K it can be adjusted to 4-8-16 or 32 K In SQLNET V1 this was no issue but in V2 it is standard 2K

If you want to know how to adjust the SDU-size let me know.

Kind Regards,

John van der Steen

Sanjeev Jain wrote:

> Hi eveyone,
>
> I was trying to tune some slow running processes. I ran utlbstat and
> utlestat and am looking at wait stats. I have couple of questions here.
>
> 1) Why is there a big number of "SQL*Net messages from client" even when
> the process is running on the same server?
> 2) If stats look like
>
> Event Name Count Total
> Time Avg Time
> ----------------------------------------------------------------------------
>
> SQL*Net message from client 2689 1727815 642.55
>
> SQL*Net message to client 2691
> 33 0.01
>
> OR
>
> SQL*Net message from client 288868 423307 1.47
> SQL*Net message to client 288868
> 134 0
>
> Does it mean in the first case SQL*Net is slow and I need to do
> something? Is it slow in second case also?
>
> These stats were taken on different servers and for different processes.
>
> Any advice/ explanation is welcome.
>
> Thanks.
> Sanjeev
Received on Sun Aug 08 1999 - 17:08:37 CDT