Re: Designer 2000 V1.3.2 DB_Block_Buffers

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

It depends.
If SGA fits in real memory there's no problem. More, this may be very good.
By the way, I think you made little mistake writting SGA = 28M. You rather mean shared_pool_size (shared pool is one of parts of SGA). SGA can be estimated by formula:
SGA size ~= shared_pool_size + DB_BLOCK_SIZE*DB_BLOCK_BUFFERS. So your SGA is about 50M.
If your server is not heavily utilized it's not paged nor swapped. Simply you should check it. For example by the most simply tool such vmstat.
Maybe, you can increase size of buffers ? Large size of buffers increase performance by reducing I/O. Des2k repository likes large SGA very very much ;)

Piotr Received on Tue Feb 17 1998 - 00:00:00 CST