Home » Other » General » AMM in ORACLE 11g (ORACLE 11g)
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.
Previous Topic: Username and Password problems for 10g SQL Plus?
Next Topic: Static and Dynamic Analysis
Goto Forum:
  


Current Time: Thu Mar 28 09:07:11 CDT 2024