Hello all,
Sorry for the delayed summary but I spent most the evening running
performance tests on different Oracle SGA sizes. My success created
additional labor!
I'd like to thank the following people for their assistance:
Nikola Milutinovic
Viktor Holmberg
Bochnik, William J
John J. Francini
Calvin Coghlan
& especially, chewy & annette from slamon.com as their response was most
inclusive.
I hope I didn't forget anyone ...
Due to downtime constraints I was unable to make individual changes and
record their effects. Thus, the following changes were made for Tru64 5.0a
running Oracle 8.1.6 and were successful in allowing a large Oracle SGA
(>2GB).
) The following entries were made in the file /etc/profile & the file
/<oracle home dir>/.login:
ulimit -d unlimited
ulimit -s unlimited
ulimit -m unlimited
ulimit -v unlimited
2) The following are the relevant kernel parameter(s) and the changes that
were made:
Parameter Pre 08/16/2000 New
Values
vm:
vm-maxvas N/A in Tru64 5.0
vm-mapentries N/A in Tru64 5.0
ubc-minpercent 5 1
ubc-maxpercent 10 2
ubc-borrowpercent 7 1
vm-ubcseqstartpercent 8 1
vm-ubcseqpercent 50 2
ipc:
shm-max 4278190080 5347737600
shm-mni 2048 128
shm-seg 2048 32
ssm-threshold 8388608 0
proc:
max-per-proc-data-size 4398046511104 unchanged
per-proc-data-size 4398046511104 unchanged
max-per-proc-address-space 4398046511104 unchanged
per-proc-address-space 4398046511104 unchanged
max-per-proc-stack-size 33554432 67108864
Thanks again!
David
----- Original Message -----
From: Romanowski, Dave <dromanowski_at_purchasepro.com>
To: <tru64-unix-managers_at_ornl.gov>
Sent: Wednesday, August 16, 2000 12:27 AM
Subject: Increasing the size of the SGA
> Hello all.
> I am having a memory allocation problem on Tru64 (4.0f & 5.0a).
> I am running Tru64 4.0f system with 6gig of memory & a Tru64 5.0a system
> with 5gigs of memory. I wish to allocate all (well nearly all) of the
> memory to Oracle. Unfortunately, I have been unable to get Oracle to use
> over 2gigs of memory. I believe this is limited by the kernel parameter
> shm-max (shm-max specifies the max size of a single shared memory region)
> which can be no larger than 2147483647 (2 gigs). I have set this value to
> 2147483647 (2 gigs) and watched the memory usage grow accordingly!
However,
> management believes I should be able to allocate all the memory to Oracle.
> Does anyone know how to overcome this limitation????
>
> regards,
> David
>
Received on Thu Aug 17 2000 - 19:02:43 NZST