Oracle 10g feature usage
                                                 Last update (2008-04-21 15:38:31)
                                                                                                                   Date added (2008-04-21 15:36:03)

Sumary
You can also find in Oracle 10g the feature usage
SELECT U1.NAME, U1.DETECTED_USAGES
FROM   DBA_FEATURE_USAGE_STATISTICS U1
WHERE  U1.VERSION = (SELECT MAX(U2.VERSION)
                     FROM   DBA_FEATURE_USAGE_STATISTICS U2
                     WHERE  U2.NAME = U1.NAME)
ORDER BY U1.DETECTED_USAGES DESC;

NAME                                                             DETECTED_USAGES
---------------------------------------------------------------- ---------------
Partitioning (system)                                                        115
Protection Mode - Maximum Performance                                        115
Recovery Area                                                                115
Recovery Manager (RMAN)                                                      115
RMAN - Tape Backup                                                           115
Server Parameter File                                                        115
Streams (system)                                                             115
Streams (user)                                                               115
Automatic Segment Space Management (system)                                  115
Automatic SQL Execution Memory                                               115
Automatic Undo Management                                                    115
Character Set                                                                115
Locally Managed Tablespaces (system)                                         115
Locally Managed Tablespaces (user)                                           115
Automatic Segment Space Management (user)                                    114
Segment Advisor                                                               92
Audit Options                                                                 84
Parallel SQL DDL Execution                                                    53
Parallel SQL Query Execution                                                  39
Dynamic SGA                                                                   21
SQL Tuning Advisor                                                             6
Client Identifier                                                              4
Automatic Database Diagnostic Monitor                                          3
SQL Access Advisor                                                             1
Undo Advisor                                                                   1
Automatic Workload Repository                                                  1
Flashback Database                                                             1
MTTR Advisor                                                                   0
Multiple Block Sizes                                                           0
OLAP - Analytic Workspaces                                                     0
OLAP - Cubes                                                                   0
Oracle Managed Files                                                           0
Parallel SQL DML Execution                                                     0
Partitioning (user)                                                            0
PL/SQL Native Compilation                                                      0
Protection Mode - Maximum Availability                                         0
Protection Mode - Maximum Protection                                           0
Protection Mode - Unprotected                                                  0
Real Application Clusters (RAC)                                                0
RMAN - Disk Backup                                                             0
Resource Manager                                                               0
Shared Server                                                                  0
Spatial                                                                        0
SQL Tuning Set                                                                 0
Standby Archival - LGWR                                                        0
Standby Archival - ARCH                                                        0
Standby Transmission                                                           0
Transparent Gateway                                                            0
Virtual Private Database (VPD)                                                 0
Advanced Replication                                                           0
Advanced Security                                                              0
Automatic Storage Manager                                                      0
Change-Aware Incremental Backup                                                0
CSSCAN                                                                         0
Character Semantics                                                            0
Data Guard                                                                     0
Data Guard Broker                                                              0
Data Mining                                                                    0
File Mapping                                                                   0
Internode Parallel Execution                                                   0
Label Security                                                                 0
Messaging Gateway                                                              0

62 rows selected.
Reviews
Categories
Oracle DBA-> (147)
  Alertlog (3)
  Archivelog (5)
  Auditing (1)
  Backup - Recovery (19)
  Database files (6)
  Database options (2)
  DB links (2)
  Dependencies (1)
  Dictionary (2)
  Exp-Imp Datapump (6)
  Jobs (2)
  Mview (2)
  Networking (3)
  Objects (7)
  Parameters (2)
  Redologs (6)
  Roles - Grants (2)
  Rollback - Undo (8)
  Segments (3)
  Sequences (2)
  Sessions (14)
  SGA (14)
  Tables (10)
  Tablespaces (10)
  Temp (4)
  Toad (5)
  Transactions (1)
  Upgrade (2)
  Users (3)
Oracle APPS DBA-> (66)
Exadata (1)
Performance Tuning-> (59)
Oracle Real Cases (24)
Oracle Errors (23)
Oracle SQL tricks (32)
Oracle RAC (3)
Oracle Security (8)
Filters
Search