RE: Automatic Shared Memory question

From: Susan White <swhite_at_lifetouch.com>
Date: Mon, 21 Aug 2006 11:44:23 -0500
Message-ID: <3896E060305BBC40AB9D1CE31DD6731B09C6C79A@exchlt1.LIFETOUCH.NET>

Solaris allocates the sga_max_size amount at instance start-up. sga_target is what the database actually tries to use. The difference between them can be used if you want to increase the sga_target parm without bouncing the DB.

Thanks  

Susan

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Harvinder Singh
Sent: Monday, August 21, 2006 10:43 AM
To: ORACLE-L
Subject: Automatic Shared Memory question

Hi,

I am checking the Automatic Shared Memory feature and set the following 2 parameters in init.ora file and recreate the spfile and restarted the oracle:
sga_max_size=943718400
sga_target=629145600

Now I expect SGA to use about 600MB as per sga target but when I do select * from v$sga or show sga from sqlplus it shows it to use 900M and that is sga_max_size setting:
SQL> show sga

Total System Global Area 943718400 bytes

Fixed Size                  1305760 bytes
Variable Size             514069344 bytes
Database Buffers          427819008 bytes
Redo Buffers                 524288 bytes

Now when I go to OEM and check the memory parameters it shows it using 600MB:

SGA Component	Current Allocation (MB)
Shared Pool	176
Buffer Cache	408
Large Pool	4
Java Pool	8
Other	4

Howcome I am seeing 2 different results and OEM showing correct results.

Environment : Oracle 10.1.0.3 on sun solaris 10

Thanks
--Harvinder

--

http://www.freelists.org/webpage/oracle-l

---

This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email

---

--

http://www.freelists.org/webpage/oracle-l Received on Mon Aug 21 2006 - 11:44:23 CDT