| AMM in ORACLE 11g [message #451101] |
Mon, 12 April 2010 08:13 |
pstroz
Messages: 1
Registered: April 2010
|
Junior Member |
|
|
Hello, my questions concern ORACLE 11g,
First topic
Tell me if i'm right:
if i set server parameters:
memory_max_target to 1.5 GB
memory_target to 1GB
pga_aggregate_target to 100MB
sga_target to 500MB
Q1.That's mean DB will use at least 500MB for all SGA components and at least 100MB for Server Processes?
Q2.And if it's true Oracle will tune SGA szie above sga_target and for PGA above 100MB if necessary?
Second topic:
If I set :
memory_max_target to 1.5 GB
memory_target to 1GB
pga_aggregate_target to 0
sga_target to 0
Q3.That's mean DB wil tune SGA component's size and PGA buffer it self up to 1GB for both elements?
Thanks for replay.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
