Folks
we have Oracle 8.1.5 on Solaris 2.7 on e450 box.
we are running two instances running on this box
and total database size is about 1gb..
we are having around 350 active connections for each databasememory on our server is 2GB.And now as you guys can seeour total SGA on each database is aroung 130MB only
to increase this i did modified shmmax parameters but still
my SGA as a whole is still 130MB..could u guys pls give me someidea on how to tune this properly for more SGA...and alsowe dont have any Java applications running and is there any way we can eliminate Java shared pool of 20Mb--or is it mandatory..
could u guys pls thro some ideas on this pls and help me in tuning
this db..

set shmsys:shminfo_shmmax=8053063600
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=20
set semsys:seminfo_semmns=1220
set semsys:seminfo_semmni=100
set semsys:seminfo_semmsl=820
set semsys:seminfo_semopm=100
set semsys:seminfo_semvmx=32767

NAME VALUE
-------------------- ----------
Fixed Size 64912
Variable Size 91381760
Database Buffers 41943040
Redo Buffers 180224

db_file_multiblock_read_count = 32
db_block_buffers = 10240
shared_pool_size = 83886080
log_buffer = 163840
db_block_size = 4096

thanks
sat