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