Re: Memory Allocation

vgoel_at_pts.mot.com (Vikram Goel) wrote:

>In article <4joa93$vl5_at_news6.erols.com>, Tim Quick <tquick_at_erols.com> writes:
>>We currently have 4 Oracle databases running Oracle 7.1.4
>>under Solaris 2.4 on a Sun 1000 with 512 MB of memory. How do
>>I know when Oracle is fully utilizing the 512 MB of memory?
 

>Tim,
 

>The best way is to use the os utilities to determine what resources are being
>used by the Oracle sga. Another way, although this shows usage within the sga
>only, is to select value of 'free memory from the view named v$sgastat" . the
>sum of the value will give the maximum sga size, subtracting thevalue of 'free
>memory' will give the used memory in the sga.
 

>Hope this helps,
>--
>Vikram Goel Motorola email: vgoel_at_pts.mot.com
>Sr. Oracle DBA - Consultant
>Aerotek Inc. My email: vgoel_at_emi.net
 

>Motorola Info:
>Mail Stop 39, Room S1014
>1500 Gateway Blvd,
>Boynton Beach, FL 33426

Uh, almost. Actually, selecting the sum(value) from v$sgastat will return an amount greater than the SGA size. Try select sum(bytes) from v$sga - I think. I have the appropriate query listed on:

[warning: self promotion on]

http://www.menlosoftware.com/

[self promotion off]

Regards,
Paul Received on Tue Apr 09 1996 - 00:00:00 CEST