Home » RDBMS Server » Server Administration » Automatic Memory Management (Oracle Database 11.2.0.3, Windows XP)
Automatic Memory Management [message #581444] Sun, 07 April 2013 12:18 Go to next message
Roger22
Messages: 98
Registered: April 2009
Location: Brasov, ROMANIA
Member
Hi,
I have read this article: http://oracle-online-help.blogspot.ro/2008/03/memory-parameters-in-11g-memorytarget.html
And i see:
Quote:

If MEMORY_TARGET is set to non zero value:
SGA_TARGET, SGA_MAX_SIZE and PGA_AGGREGATE_TARGET are set to 0, 60% of memory mentioned in MEMORY_TARGET is allocated to SGA and rest 40% is kept for PGA.


So, I have set:
alter system set sga_target=0 scope=spfile;
alter system set pga_aggregate_target=0 scope=spfile;
alter system set sga_max_size=0 scope=spfile;
alter system set memory_max_target=512M scope=spfile;
alter system set memory_target=300M scope=spfile;

, and then bounced the instance.
After startup, I see:
SQL> startup
ORACLE instance started.
 
Total System Global Area  272027648 bytes
Fixed Size                  1384012 bytes
Variable Size             100663732 bytes
Database Buffers          163577856 bytes
Redo Buffers                6402048 bytes
Database mounted.
Database opened.
SQL>



But Total System Global Area should't be in that case 60% of memory mentioned in MEMORY_TARGET? Memory mentioned in MEMORY_TARGET was 300M, and 60% of 300M is 180M, which is not 272027648 bytes.
I just want to use automatic memory management, so I've set the other parameters above to 0.

My instance is on my local machine, so just for my own personal use.
Please clarify.

Thanks!

[Updated on: Sun, 07 April 2013 12:19]

Report message to a moderator

Re: Automatic Memory Management [message #581445 is a reply to message #581444] Sun, 07 April 2013 12:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do not trust all what you see on the web, above all when the version is not mentioned with 4 decimals.

Regards
Michel
Re: Automatic Memory Management [message #581446 is a reply to message #581444] Sun, 07 April 2013 12:27 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
so write the author; not us.
not everything posted to the Internet is true.
Blog reported using V11.1 & you report using V11.2; which may not behave the same.
Re: Automatic Memory Management [message #581448 is a reply to message #581446] Sun, 07 April 2013 12:40 Go to previous messageGo to next message
Roger22
Messages: 98
Registered: April 2009
Location: Brasov, ROMANIA
Member
myeah.. "write the author". And if I wrote to you, what's the problem?!
I've increased the mamory_target to 600 and now Total SGA memory is 360M, so 60%, as expected.
Re: Automatic Memory Management [message #581449 is a reply to message #581448] Sun, 07 April 2013 12:42 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>what's the problem?!
I don't have any problem.

>I've increased the mamory_target to 600 and now Total SGA memory is 360M, so 60%, as expected.
I'll sleep better tonight knowing that your expectations have been met.
Re: Automatic Memory Management [message #581450 is a reply to message #581449] Sun, 07 April 2013 12:44 Go to previous messageGo to next message
Roger22
Messages: 98
Registered: April 2009
Location: Brasov, ROMANIA
Member
Ok, that was.. what i was seeing initially was likely the absolute minimum SGA that Oracle requires.
Good night.
Re: Automatic Memory Management [message #581451 is a reply to message #581450] Sun, 07 April 2013 12:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The minimum is explained in Database Concepts you should read BEFORE any web site.

Regards
Michel
Re: Automatic Memory Management [message #581452 is a reply to message #581451] Sun, 07 April 2013 12:53 Go to previous messageGo to next message
Roger22
Messages: 98
Registered: April 2009
Location: Brasov, ROMANIA
Member
No, that isn't (or I did not found it)
Re: Automatic Memory Management [message #581453 is a reply to message #581452] Sun, 07 April 2013 13:11 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The minimum for each are is one granule.

Regards
Michel
Previous Topic: Insufficient privileges while connecting 'sys as sysdba'
Next Topic: Error 119 and ERROR 130
Goto Forum:
  


Current Time: Thu Mar 28 07:44:02 CDT 2024