Automated Space Management in Oracle10g
Space thresholds for tablespaces can also
be set through Oracle Enterprise Manager on the Edit Metric
Thresholds page. This page is launched from the database home
page by selecting Edit Metric Thresholds from Related Links.
Besides setting the threshold values, OEM can be used to enable
or disable the values when creating or editing a tablespace.
Each database instance has an internal
memory structure that keeps track of the space usage in every
file in the database. This table has one row for each database
file, and each row contains the filesize, the allocated space,
and a Change SCN number.
Although
RAC is not being reviewed extensively in this book, space
management will be briefly introduced. An excellent source for
RAC information,
besides the Oracle documentation,
is Rampant’s Oracle
10g Grid & Real Application Clusters.
With Real Application clusters, each database instance has its
own MMON process. But each MMON process reads the aggregated
data from the gv
