optimal configuration for SGA and unix kernel

From: <skgopa_at_my-dejanews.com>
Date: Wed, 22 Jul 1998 15:33:23 GMT
Message-ID: <6p50o4$oqo$1@nnrp1.dejanews.com>

Hi,

My configuration for Oracle8 running on Enterprise server. OS is solaris 2.6 with 2 GB of memory .

Current configuration :

Unix Kernel shared memory configuration :

set  shmsys:shminfo_shmmax=356515840
set  shmsys:shminfo_shmmin=1
set  shmsys:shminfo_shmmni=60
set  shmsys:shminfo_shmseg=50
set semsys:seminfo_semmns=200

set semsys:seminfo_semmni=70
set semsys:seminfo_semmsl=20

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

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Jul 22 1998 - 10:33:23 CDT