Home » RDBMS Server » Performance Tuning » Memory Allocation in 11 G (oracle 11.2.0.3.0 - Windows server 2008 R2)
Memory Allocation in 11 G [message #586728] Mon, 10 June 2013 06:15 Go to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi All,

I am using 11g version, and trying to understand the Memory Allocation.

1) The new feature Memory target parameters are dynamic? is in it?
But when I set with the ALTER SYSTEM... it was not changed, then I had to restart the DB.

2) With the new 2 parameters (MEMORY_MAX_TARGET, MEMORY_TARGET), the SGA_MAX_SIZE parameter should be 0, right?
But in my case, the SGA_MAX_SIZE value is automatically assigned.

[img]D:\memory[/img]

Kindly clarify my doubts.

Regards
Muthu.
Re: Memory Allocation in 11 G [message #586729 is a reply to message #586728] Mon, 10 June 2013 06:19 Go to previous messageGo to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hello Sorry,

Here is the screen shot
  • Attachment: Memory.JPG
    (Size: 50.92KB, Downloaded 1100 times)
Re: Memory Allocation in 11 G [message #586741 is a reply to message #586729] Mon, 10 June 2013 06:44 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
After 340 posts do we really need to tell you that it's better to copy and paste output from sqlplus directly in the post in code tags, rather than attach it as an image?
Re: Memory Allocation in 11 G [message #586751 is a reply to message #586728] Mon, 10 June 2013 07:07 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ We do not download file, you are too lazy
2/ We don't explain parameters that are clearly explain in the documentation, you are too lazy.

Regards
Michel
Re: Memory Allocation in 11 G [message #586753 is a reply to message #586751] Mon, 10 June 2013 07:20 Go to previous messageGo to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hello All,

Sorry, I am not lazy...

Here is the output.


SQL> show parameter memory

NAME                                 TYPE        VALUE                          
------------------------------------ ----------- ------------------------------ 
hi_shared_memory_address             integer     0                              
memory_max_target                    big integer 190G                           
memory_target                        big integer 160G                           
shared_memory_address                integer     0                              

SQL> show sga

Total System Global Area 1.0262E+11 bytes                                       
Fixed Size                  3233392 bytes                                       
Variable Size            6463424912 bytes                                       
Database Buffers         9.6146E+10 bytes                                       
Redo Buffers                8437760 bytes                                       

SQL> show parameter sga

NAME                                 TYPE        VALUE                          
------------------------------------ ----------- ------------------------------ 
lock_sga                             boolean     FALSE                          
pre_page_sga                         boolean     FALSE                          
sga_max_size                         big integer 96G                            
sga_target                           big integer 0                                     



Regards,

Muthu
Re: Memory Allocation in 11 G [message #586756 is a reply to message #586753] Mon, 10 June 2013 07:36 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, you are, you didn't read the documentation about these parameters. They are very clearly explained.

Regards
Michel
Previous Topic: SQL not using index from application.
Next Topic: How to Refresh a Materialized view Data.
Goto Forum:
  


Current Time: Thu Mar 28 10:14:00 CDT 2024