At installation time, Oracle Corporation does not require license keys and
Oracle shops must be aware of those features that some in Standard Edition (SE),
Enterprise Edition (EE), and all of the extra cost packs.
(This, from Tony Jambu) The DBA_FEATURE_USAGE_STATISTICS view
will display information about database feature usage statistics. 10g will keep
track of any of its features that are being used. As an example, if you SELECT
from any of the Oracle Diagnostic Pack and Tuning Pack views like
V$ACTIVE_SESSION_HISTORY, the database will record your usage of it in this DBA
view.
Some of the information tracked are
o Name of the feature
o Number of times the system has detected usage for the feature
o First sample time the system detected usage of the feature
o Last sample time the system detected usage of the feature
These are just some of the features it tracks
Name - Description
Audit Options - Audit options in use.
Automatic Database Diagnostic Monitor - A task for the Automatic Database
Diagnostic Monitor has been executed.
Automatic Segment Space Management (system) - Extents of locally managed
tablespaces are managed automatically by Oracle.
Automatic Segment Space Management (user) - Extents of locally managed user
tablespaces are managed automatically by Oracle.
Automatic SQL Execution Memory - Sizing of work areas for all dedicated sessions
(PGA) is automatic.
Automatic Storage Manager - Automatic Storage Management has been enabled
Automatic Undo Management - Oracle automatically manages undo data using an UNDO
tablespace.
Automatic Workload Repository - A manual Automatic Workload Repository (AWR)
snapshot was taken in the last sample period.
Change-Aware Incremental Backup - Track blocks that have changed in the
database.
Locally Managed Tablespaces (system) - There exists tablespaces that are locally
managed in the database.
Locally Managed Tablespaces (user) - There exists user tablespaces that are
locally managed in the database.
SQL Access Advisor - A task for SQL Access Advisor has been executed.
SQL Tuning Advisor - SQL Tuning Advisor has been used."
|
|
