Re: optimal configuration for SGA and unix kernel

From: Julio <julio.negueruela_at_si.unirioja.es>
Date: Thu, 23 Jul 1998 10:33:09 +0200
Message-ID: <35B6F545.1B5EB311@si.unirioja.es>

skgopa_at_my-dejanews.com escribió:
> =

> Hi,
> =

> My configuration for Oracle8 running on Enterprise server. OS is sol=
aris
> 2.6 with 2 GB of memory .

> SGA is
> =

> Total System Global Area 321972440 bytes
> Fixed Size 44924 bytes
> Variable Size 111688028 bytes
> Database Buffers 209715200 bytes
> Redo Buffers 524288 bytes
> =

> Parameters :
> =

> db_block_size 8192 bytes
> db_block_buffers 25600 bytes
> processes 50
> shared_pool_size 104857600 bytes
> sort_area_size 65536 bytes
> =

> My question is :
> =

> What is the optimal configuration for the above parameters ? Number of =
users
> are 16.
> =

> Sunil

Hi Sunil,

I'd increase the log_buffer to log_buffer=2621440. Let the logwriter to=

have a rest if your database supports a big number of transactions.

I'd increase too the sort_area_size to 262154, or even bigger. As bigger this parameter less sorts in disk will be performed. You have memory enough to allocate memory for user sorts.

Hope this help.
-- =

Julio Negueruela
DBA Servicio Informático

Universidad de La Rioja      -      Spain
Telf: 941-299179     Fax: 941- 299180

mailto:julio.negueruela_at_si.unirioja.es Received on Thu Jul 23 1998 - 03:33:09 CDT