Re: Memory Allocation

From: Sameer Utrankar <utrankas_at_coned.com>
Date: 1996/04/10
Message-ID: <4kgsir$j81_at_ins3.coned.com>#1/1


posborn_at_menlosoftware.com (Paul Osborn) wrote:

>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:

Why do you say that ? I tried sum(value) and sum(bytes) from v$sga and v$sgastat and it's matches exactly. No difference at all. Utrankas_at_coned.com (Sameer Utrankar)
212-460-1117 (W) Received on Wed Apr 10 1996 - 00:00:00 CEST

Original text of this message