In this chapter, the automatic system
resource management features of Oracle Database 10g
have been reviewed.
Here are some of the important points:
DBA can set
the total amount of SGA memory available to an
instance using the sga_target initialization
database will automatically distribute this memory among
various sub-components for
effective memory utilization.
sga_target is set to a non-zero
value to enable ASMM.
Memory Manager (MMAN)
is a background
coordinates the sizing of the memory components and acts as
a memory broker to track all memory components and pending
The Memory Advisor
accessible through OEM has three advisors that
recommendations: Shared Pool in SGA, Buffer Cache in SGA,
7, SQL tuning methods and improvised flashback features of
Oracle Database 10g will be