Re: Client performance.

From: Marcus Hampel <marcus.hampel_at_myview.de>
Date: 2000/06/20
Message-ID: <394F54FF.B888F2DC@myview.de>#1/1

Hello,

Sybrand Bakker wrote:
> At a block size of 2k, 4000 db_block_buffers is a minimum, at 4k 2000
> etc.

But i can't see how would this help on overload of the client! The Server doesn't eat the performance and the application itself use less performance (this shows testing with the SQL-Server from Microsoft).

> Also setting sqlnet.expire_time at 1 is something you definitely
> shouldn't
> do. This means the server polls the clients sessions for dead
> connections
> *every minute* which simply means a high overhead.

But on a database without any workload it shouldn't be matter.

>
> Regards,
>
> Sybrand Bakker, Oracle DBA

Thanks for trying to help ...

Marcus Received on Tue Jun 20 2000 - 00:00:00 CDT