10G New Features: Statistics Collection

I am reading through "OCP Oracle Database 10G: New Features for Administrators Exam Guide" by Sam R. Alapati. A must read for 9i DBAs looking to upgrade skills to Oracle 10G.

In 10G, there is a new background process called MMON [Manageability Monitor Process]. MMON keeps track of the High Water Mark Statistics and the Database Usage statistics, recording it in AWR [Automatic Workload Repository].

Database Usage Statistics:

SQL> desc dba_feature_usage_statistics
Name                                      Null?    Type
----------------------------------------- -------- ----------------------------
DBID                                      NOT NULL NUMBER
NAME                                      NOT NULL VARCHAR2(64)
VERSION                                   NOT NULL VARCHAR2(17)
DETECTED_USAGES                           NOT NULL NUMBER
TOTAL_SAMPLES                             NOT NULL NUMBER CURRENTLY_USED                                     VARCHAR2(5)
FIRST_USAGE_DATE                                   DATE
LAST_USAGE_DATE                                    DATE
AUX_COUNT                                          NUMBER
FEATURE_INFO                                       CLOB
LAST_SAMPLE_DATE                                   DATE
LAST_SAMPLE_PERIOD                                 NUMBER
SAMPLE_INTERVAL                                    NUMBER
DESCRIPTION                                        VARCHAR2(128)

HWM Statistics:

SQL>
SQL> desc dba_high_water_mark_statistics
Name                                      Null?    Type
----------------------------------------- -------- ----------------------------
DBID                                      NOT NULL NUMBER
NAME                                      NOT NULL VARCHAR2(64)
VERSION                                   NOT NULL VARCHAR2(17)
HIGHWATER                                          NUMBER
LAST_VALUE                                         NUMBER
DESCRIPTION                                        VARCHAR2(128)

SQL>
SQL> select name, highwater, description
2  from dba_high_water_mark_statistics
3  order by 3;

NAME                                                             HIGHWATER                                                          
---------------------------------------------------------------- ----------
DESCRIPTION
--------------------------------------------------------------------------------
CPU_COUNT                                                                 2
Maximum Number of CPUs
SESSIONS                                                                 18
Maximum Number of Concurrent Sessions seen in the database
DATAFILES                                                                12
Maximum Number of Datafiles

PART_INDEXES                                                              0
Maximum Number of Partitions belonging to an User Index
PART_TABLES                                                               6
Maximum Number of Partitions belonging to an User Table
SQL_NCHAR_COLUMNS                                                        11
Maximum Number of SQL NCHAR Columns

SERVICES                                                                  4
Maximum Number of Services
TABLESPACES                                                              13
Maximum Number of Tablespaces
QUERY_LENGTH                                                            139
Maximum Query Length

DB_SIZE                                                          1704001536
Maximum Size of the Database (Bytes)
USER_INDEXES                                                           2001
Number of User Indexes
USER_TABLES                                                             998
Number of User Tables

SEGMENT_SIZE                                                      183500800
Size of Largest Segment (Bytes)

13 rows selected.

SQL>

Pretty Cool.... Didn't have that in 9i.