Oracle Database Discussions

Hi Everybody,

I have a Database running Oracle 9i, release 9.2.0.6.0 64bit. It is running on an IBM PSeries with AIX 5L, 8gb RAM, but only 4 scsi disks of 136gb each. My current DB configuration is set as a General Database. Numbers are as follows in bytes:

buffer_cache=2684354560
free memory=536870912
library cache=354736912
sql area=323717552
free memory=310946880
miscellaneous=75226840
db_block_hash_buckets=22162544
free memory=16777216
FileOpenBlock=7812264
PL/SQL MPCODE=6413728
XDB Schema Cac=5794944
sim memory hea=5162712
event statistics per sess=5033840
KQR L PO=4770048
log_buffer=4457472
dictionary cache=3229952
Checkpoint queue=2624000
PL/SQL DIANA=2604688
KGLS heap=2016608
KQR M PO=1751744
sessions=1203280
1M buffer=1056768
KSXR receive buffers=1034000
VIRTUAL CIRCUITS=911480
KSXR pending messages que=853952
fixed_sga=749240
parameters=707896
MTTR advisory =292144
PL/SQL PPCODE=199560
type object de=174736
errors=115104
subheap=102312
trigger defini=63000
PX subheap=38784
trigger inform=21008
table definiti=19208
KGK heap=16984
KQR S SO=13624
pl/sql source=9384
trigger source=4368
joxs heap init=4240
PLS non-lib hp=3000
fixed allocation callback=600

Total SGA = 4116.715mb
SGA Max Size = 4452.976mb

The SGA Summary is as follows in bytes:
Database Buffers=2684354560
Fixed Size=749240
Redo Buffers=4468736
Variable Size=1979711488

I'm having big headaches with locks. I understand my Database is a OLTP but never configured it like that. I missed the opportunity at the time of creation. What would be a goos start un numbers for a SGA settings?

Please help...