Designer 2000 V1.3.2 DB_Block_Buffers

From: Roger Jackson <rjackson_at_wire.net.au>
Date: 1998/02/17
Message-ID: <6cbl11$90q$1@caley.wire.net.au>#1/1

Hi all,

I'm currently at a site using Designer 2000 with the following parameters

Platform:

Server: Solaris 2.5.1, 256M (physical memory), 2 CPU's
Client: Windows 95
Oracle: RDBMS 7.3.2

Designer V1.3.2

Current Database Settings, set by previous DBA, should any of these be changed???
SGA = 28M
DB_BLOCK_SIZE = 8K
DB_BLOCK_BUFFERS = 2500 I've been reading in articles and magazines that the DB_BLOCK_BUFFERS should be set to between 1500-2000 is there any performance degradation by setting it higher than 2000???

Regards

Roger Jackson Received on Tue Feb 17 1998 - 00:00:00 CST