| SGA [message #488533] |
Sat, 08 January 2011 23:23  |
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
|
Senior Member |
|
|
NAME VALUE DISPLAY_VALUE
------------------------------ ----------------------------------- --------------
lock_sga FALSE FALSE
memory_max_target 22548578304 21G
memory_target 22548578304 21G
pga_aggregate_target 1073741824 1G
sga_max_size 20401094656 19G
sga_target 20401094656 19G
i have memory_% parameters set .Is there any effect on setting
pga_aggregate_target
sga_max_size
sga_target in this case ?
|
|
|
|
|
|
| Re: SGA [message #488559 is a reply to message #488535] |
Sun, 09 January 2011 06:26  |
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
|
Senior Member |
|
|
Quote:
The preceding steps instruct you to set SGA_TARGET and PGA_AGGREGATE_TARGET to zero so that the sizes of the SGA and instance PGA are tuned up and down as required, without restrictions. You can omit the statements that set these parameter values to zero and leave either or both of the values as positive numbers. In this case, the values act as minimum values for the sizes of the SGA or instance PGA.
Thanks Mike.It says my current setting ,Oracle would use as min value .
I have another quest.Will Oracle lock entire memory_max_target value specified ?
Eg :memory_max_target has value 20GB, and memory_target has value 15GB . Oracle still hold 20GB ? Thanks
[Updated on: Sun, 09 January 2011 08:01] by Moderator Report message to a moderator |
|
|
|
|
|
| Re: SGA [message #488988 is a reply to message #488533] |
Wed, 12 January 2011 12:51 |
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
|
Senior Member |
|
|
Thanks.
Another quest.
i have set ONLY memory_target to 4GB and when i started the instance i could see
memory_target =4GB
memory_max_size=4GB (this is ok)
sga_target=0 (this is ok)
sga_max_size=4GB ?????
sga_max_size was automaticaly set to 4GB.
Is it ok ? it will hold whole memory for SGA alone ? PGA alloc will face any issues ?
i couldnt find this info in oracle doc. Pls can anyone advice ?
|
|
|
|
|
|
| Re: SGA [message #489034 is a reply to message #489030] |
Thu, 13 January 2011 00:05 |
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
|
Senior Member |
|
|
i set only memory_target to 4GB. rest all came default.
sga_max_size 4294967296 4G
memory_target 4294967296 4G
memory_max_target 4294967296 4G
sga_target 0 0
[Updated on: Thu, 13 January 2011 00:07] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: SGA [message #489088 is a reply to message #489081] |
Thu, 13 January 2011 04:10 |
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
|
Senior Member |
|
|
i set MEMORY_TARGET to 4GB so that oracle can automaticaly manage SGA and PGA.
SGA_MAX_SIZE having same value ,wont hold 4GB ONLY for SGA ? where PGA get space from ?
|
|
|
|
|
|
| Re: SGA [message #489097 is a reply to message #489090] |
Thu, 13 January 2011 04:33 |
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
|
Senior Member |
|
|
|
ok , so SGA_MAX_SIZE having some high value doesnt mean oracle will HOLD that much memory (reserved) for SGA alone. Thanks
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
i want to know if SGA_MAX_SIZE=MEMORY_TARGET=MEMORY_MAX_TARGET is a problem ? or hw it works (considering pga)