Re: Designer 2000 V1.3.2 DB_Block_Buffers

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1998/02/17
Message-ID: <34e9f972.4515838@www.sigov.si>#1/1

On Tue, 17 Feb 1998 20:23:31 +1100, "Roger Jackson" <rjackson_at_wire.net.au> wrote:

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

I'd say those were pretty strange articles and magazines you 've been reading. Setting the DB_BLOCK_BUFFERS above 2000 could certanly not degrade the performance just because of this magic number. It could, hovewer, depending mostly on your available memory and DB_BLOCK_SIZE of your database. Check if any swapping/paging is ocuring on jour OS.

But concluding from the numbers you wrote it's very obvious your shared pool is far too small (less then 8M), particulary for runing Des2K. Increase your SHARED_POOL_SIZE parameter if you have more RAM available, or else reduce your DB_BLOCK_BUFFERS (in this case you better consider adding more RAM to your box).

>Regards
>
>Roger Jackson

Regards,

---

Jurij Modic                             Republic of Slovenia
jurij.modic_at_mf.sigov.mail.si		Ministry of Finance
============================================================

The above opinions are mine and do not represent any official standpoints of my employer Received on Tue Feb 17 1998 - 00:00:00 CST