| Memory Allocation in 11 G [message #586728] |
Mon, 10 June 2013 06:15  |
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 #586741 is a reply to message #586729] |
Mon, 10 June 2013 06:44  |
cookiemonster
Messages: 13958
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 #586753 is a reply to message #586751] |
Mon, 10 June 2013 07:20 |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
