RE: Automatic Shared Memory question
- From: Susan White <swhite@xxxxxxxxxxxxx>
- To: "'Harvinder.Singh@xxxxxxxxxxxxx'" <Harvinder.Singh@xxxxxxxxxxxxx>, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 21 Aug 2006 11:44:23 -0500
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
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
--
//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
______________________________________________________________________
--
//www.freelists.org/webpage/oracle-l
Other related posts:
