From: John Jolet (john.jolet@FXFN.COM)
Date: Thu Feb 26 2004 - 10:48:32 EST
bear in mind that setting the sga to be pinned doesn't really do anything
unless you set the flag in the os that allows processes to pin sga. i forget
which one that is. otherwise, oracle will grab the sga, then if necessary,
the os will swap chunks of it :)
On Thursday 26 February 2004 09:23 am, you wrote:
> You may ask your DBA's what they have the Oracle SGA set at. I'm not a DBA
> expert but my understanding is that the SGA setting is how much memory
> Oracle claims when it starts up. For example, due to the high SGA setting
> we have on our Oracle Databases our available memory almost always is 0 or
> close to it.
>
> Jason de la Fuente
>
> >>> gilberto.hitoshi@BULL.COM.BR 02/25/04 05:18PM >>>
>
> I have machine with 12 cpus and 16 Gbytes of memory. The machine is using
> vantive apllication and oracle 8i. Aix 4.3.3.81 .
> I'm having problem with memory. Any moment , the memory is 0 . In this
> moment , i trying killed all processes , but the machine not release the
> memory, and i need reboot the server. I changed the vmtune to
> /usr/samples/kernel/vmtune -f 1440 -F 1456
> /usr/samples/kernel /vmtune -p 5 -P 30 -t 30, but the problem still
> continue.
> Anyone has any idea about this problem?
>
> Hitoshi
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 22:17:38 EDT