Dear sirs,
I have an as8400 with 4G ram running Oracle 7.3.3.6 with SGA 1GB
and I'm experiencing excesive page faulting. My sysconfigtab file has
the
following modifications:
proc:
maxusers=2048 ( provided by sys_check. Most of our connections are
through sqlNet)
vm:
vm-maxvas=1073741824 (1GB)
ubc-maxpercent=60
vm-ubcseqstartpercent=20
vm-mapentries=16384
vm-pagemax=65536
vfs:
bufcache=1
name-cache-hash-size=512
advfs:
advfsCacheMaxPercent=1
AdvfsMaxDevQLen=32
Note: There are very few (and small) page outs (1 in 100), many page ins
(100-300 pages)
and page faults that go up to 3000 pages. On vmstat output, the 'zero'
value is very close to
the 'fault', if that helps. System time upon high page faulting rises
abow 50.
Could anyone give a hint on how I could smooth this problem?
And another question. Since I'm running Oracle with an SGA of 1GB,
should I leave
the advfsCacheMaxPercent to 1 and let Oracle to it's cacheing?
(I use KZPSA to connect to HSZ50 wich controlles stripped RZ1CB-CS
disks)
Thanks in advace,
Alexander Sakellaris
Received on Mon Aug 31 1998 - 14:14:29 NZST