Datenbank Features

Statistik zur Nutzung von Oracle Datenbank Features

Sie möchten ermitteln, welche Datenbank-Features genutzt werden? 
Das folgende Skript zeigt Ihnen Datum und Uhrzeit der ersten und letzten Nutzung
sowie die Häufigkeit der Nutzung:

 ALTER SESSION SET NLS_DATE_FORMAT = 'dd.mm.yyyy hh24:mi';
 
    SELECT a.name,
           a.detected_usages,
           a.first_usage_date,
           a.last_usage_date
    FROM   dba_feature_usage_statistics a
    WHERE  a.version = (SELECT MAX(b.version)
                         FROM   dba_feature_usage_statistics b
                         WHERE  b.name = a.name)
    ORDER BY a.name;

Die Ausgabe kann wie folgt aussehen:

NAME                                                DETECTED_USAGES FIRST_US LAST_USA
-------------------------------------------------- --------------- -------- --------
ADDM                                                             0
Advanced Replication                                             0
Advanced Security                                                0
Application Express                                              0
Audit Options                                                    4 15.06.09 12.07.09
Automatic Maintenance - Optimizer Statistics Gathe               4 15.06.09 12.07.09
ring

Automatic Maintenance - Space Advisor                            4 15.06.09 12.07.09
Automatic Maintenance - SQL Tuning Advisor                       4 15.06.09 12.07.09
Automatic Memory Tuning                                          4 15.06.09 12.07.09
Automatic Segment Advisor                                        3 25.06.09 12.07.09
Automatic Segment Space Management (system)                      4 15.06.09 12.07.09
Automatic Segment Space Management (user)                        1 12.07.09 12.07.09
Automatic SGA Tuning                                             0
Automatic SQL Execution Memory                                   0
Automatic SQL Tuning Advisor                                     3 25.06.09 12.07.09
Automatic Storage Management                                     0
Automatic Undo Management                                        4 15.06.09 12.07.09
Automatic Workload Repository                                    0
AWR Baseline                                                     0
AWR Baseline Template                                            0
Backup Encryption                                                0
Backup Rollforward                                               0
Backup ZLIB Compression                                          0
Baseline Adaptive Thresholds                                     0
Baseline Static Computations                                     0
Bigfile Tablespace                                               0
Block Media Recovery                                             0
Change Data Capture                                              0
Change-Aware Incremental Backup                                  0
Character Semantics                                              0
Character Set                                                    4 15.06.09 12.07.09
Client Identifier                                                0
Clusterwide Global Transactions                                  0
CSSCAN                                                           0
Data Guard                                                       0
Data Mining                                                      0
Data Recovery Advisor                                            1 12.07.09 12.07.09
Database Replay: Workload Capture                                0
Database Replay: Workload Replay                                 0
Deferred Open Read Only                                          0
DICOM                                                            1 15.06.09 15.06.09
Dynamic SGA                                                      0
EM Database Control                                              0
EM Grid Control                                                  0
Encrypted Tablespaces                                            0
Extensibility                                                    4 15.06.09 12.07.09
File Mapping                                                     0
Flashback Data Archive                                           1 12.07.09 12.07.09
Flashback Database                                               0
HeapCompression                                                  0
Internode Parallel Execution                                     0
Job Scheduler                                                    0
Label Security                                                   0
LOB                                                              4 15.06.09 12.07.09
Locally Managed Tablespaces (system)                             4 15.06.09 12.07.09
Locally Managed Tablespaces (user)                               4 15.06.09 12.07.09
Logfile Multiplexing                                             0
Materialized Views (User)                                        4 15.06.09 12.07.09
Messaging Gateway                                                0
MTTR Advisor                                                     0
Multimedia                                                       0
Multiple Block Sizes                                             0
Object                                                           4 15.06.09 12.07.09
OLAP - Analytic Workspaces                                       0
OLAP - Cubes                                                     0
Oracle Managed Files                                             0
Oracle Secure Backup                                             0
Oracle Text                                                      4 15.06.09 12.07.09
Oracle Utility Datapump (Export)                                 0
Oracle Utility Datapump (Import)                                 0
Oracle Utility Metadata API                                      0
Oracle Utility SQL Loader (Direct Path Load)                     0
Parallel SQL DDL Execution                                       0
Parallel SQL DML Execution                                       0
Parallel SQL Query Execution                                     0
Partitioning (system)                                            4 15.06.09 12.07.09
Partitioning (user)                                              4 15.06.09 12.07.09
Physical Standby with Real-Time Query                            0
PL/SQL Native Compilation                                        0
Read Only Tablespace                                             0
Real Application Clusters (RAC)                                  0
Recovery Area                                                    4 15.06.09 12.07.09
Recovery Manager (RMAN)                                          1 12.07.09 12.07.09
Resource Manager                                                 3 25.06.09 12.07.09
Restore Point                                                    1 12.07.09 12.07.09
Result Cache                                                     1 02.07.09 02.07.09
RMAN - Disk Backup                                               1 12.07.09 12.07.09
RMAN - Tape Backup                                               0
Rules Manager                                                    0
SecureFiles                                                      0
Segment Advisor                                                  2 25.06.09 12.07.09
Segment Shrink                                                   0
Semantics/RDF                                                    0
Server Parameter File                                            4 15.06.09 12.07.09
Services                                                         4 15.06.09 12.07.09
Shared Server                                                    0
Spatial                                                          0
SQL Access Advisor                                               0
SQL Performance Analyzer                                         0
SQL Plan Management                                              0
SQL Profile                                                      0
SQL Repair Advisor                                               0
SQL Tuning Advisor                                               0
SQL Tuning Set (system)                                          0
SQL Tuning Set (user)                                            0
SQL Workload Manager                                             0
Streams (system)                                                 0
Streams (user)                                                   0
Transparent Data Encryption                                      0
Transparent Gateway                                              0
Transportable Tablespace                                         0
Tune MView                                                       0
Undo Advisor                                                     0
Very Large Memory                                                0
Virtual Private Database (VPD)                                   0
Workspace Manager                                                0
XDB                                                              4 15.06.09 12.07.09