Database Features Usage

Tem uma view no banco que mostra se uma determinada feature está sendo utilizada. Seu nome : DBA_FEATURE_USAGE_STATISTICS (10g). Mostra se a feature foi utilizada, alem de mostrar a primeira e ultima utilização. Portanto cuidado na utilização de features que não foram licensiadas

SQL> l
  1  SELECT NAME,DETECTED_USAGES “USAGE”,CURRENTLY_USED,FIRST_USAGE_DATE,LAST_USAGE_DATE
  2* FROM DBA_FEATURE_USAGE_STATISTICS WHERE DETECTED_USAGES >0 order by 1
SQL> /

NAME                                            USAGE      CURRE FIRST_USA LAST_USAG
———————————————– ———- —– ——— ———
Automatic SQL Execution Memory                  1          TRUE  26-DEC-08 26-DEC-08
Automatic Segment Space Management (system)     1          TRUE  26-DEC-08 26-DEC-08
Automatic Segment Space Management (user)       1          TRUE  26-DEC-08 26-DEC-08
Automatic Undo Management                       1          TRUE  26-DEC-08 26-DEC-08
Character Set                                   1          TRUE  26-DEC-08 26-DEC-08
Locally Managed Tablespaces (system)            1          TRUE  26-DEC-08 26-DEC-08
Locally Managed Tablespaces (user)              1          TRUE  26-DEC-08 26-DEC-08
Partitioning (system)                           1          TRUE  26-DEC-08 26-DEC-08
Protection Mode – Maximum Performance           1          TRUE  26-DEC-08 26-DEC-08
Recovery Area                                   1          TRUE  26-DEC-08 26-DEC-08
Server Parameter File                           1          TRUE  26-DEC-08 26-DEC-08
Streams (system)                                1          TRUE  26-DEC-08 26-DEC-08
Streams (user)                                  1          TRUE  26-DEC-08 26-DEC-08
Virtual Private Database (VPD)                  1          TRUE  26-DEC-08 26-DEC-08
XDB                                             1          TRUE  26-DEC-08 26-DEC-08