Re: Memory Allocation
From: Vikram Goel <vgoel_at_pts.mot.com>
Date: 1996/04/02
Message-ID: <4jrdmp$jmt_at_lserv1.paging.mot.com>#1/1
Date: 1996/04/02
Message-ID: <4jrdmp$jmt_at_lserv1.paging.mot.com>#1/1
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 In article <4joa93$vl5_at_news6.erols.com>, Tim Quick <tquick_at_erols.com> writes:Received on Tue Apr 02 1996 - 00:00:00 CEST
>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?