database의 feature의 사용유무 체크뷰

dba_feature_usage_statistics

SYS@db1> 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)

SYS@db1> col name format a50
SYS@db1> col currently_used format a20
SYS@db1> set lines 120
SYS@db1> set pages 100

SYS@db1> select NAME, CURRENTLY_USED from dba_feature_usage_statistics;

NAME         CURRENTLY_USED
-------------------------------------------------- --------------------
Advanced Replication       FALSE
Externally authenticated users      FALSE
Audit Options        FALSE
Automatic Database Diagnostic Monitor     FALSE
Automatic Segment Space Management (system)    TRUE
Automatic Segment Space Management (user)    FALSE
Automatic SQL Execution Memory      TRUE
Automatic Storage Manager      FALSE
Automatic Undo Management      TRUE
Automatic Workload Repository      FALSE
Change-Aware Incremental Backup      FALSE
Client Identifier       FALSE
CSSCAN         FALSE
Character Semantics       FALSE
Character Set        TRUE
Data Guard        FALSE
Data Guard Broker       FALSE
Data Mining        FALSE
Dynamic SGA        FALSE
File Mapping        FALSE
Flashback Database       FALSE
Internode Parallel Execution      FALSE
Label Security        FALSE
Locally Managed Tablespaces (system)     TRUE
Locally Managed Tablespaces (user)     TRUE
Messaging Gateway       FALSE
MTTR Advisor        FALSE
Multiple Block Sizes       FALSE
OLAP - Analytic Workspaces      FALSE
OLAP - Cubes        FALSE
Oracle Managed Files       FALSE
Parallel SQL DDL Execution      TRUE
Parallel SQL DML Execution      FALSE
Parallel SQL Query Execution      FALSE
Partitioning (system)       TRUE
Partitioning (user)       FALSE
PL/SQL Native Compilation      FALSE
Protection Mode - Maximum Availability     FALSE
Protection Mode - Maximum Performance     TRUE
Protection Mode - Maximum Protection     FALSE
Protection Mode - Unprotected      FALSE
Real Application Clusters (RAC)      FALSE
Recovery Area        TRUE
Recovery Manager (RMAN)       FALSE
RMAN - Disk Backup       FALSE
RMAN - Tape Backup       FALSE
Resource Manager       FALSE
Segment Advisor        FALSE
Server Parameter File       TRUE
Shared Server        FALSE
Spatial         FALSE
SQL Access Advisor       FALSE
SQL Tuning Advisor       FALSE
SQL Tuning Set        FALSE
Standby Archival - LGWR       FALSE
Standby Archival - ARCH       FALSE
Standby Transmission       FALSE
Database Replay: Workload Capture     FALSE
Streams (system)       TRUE
Streams (user)        TRUE
Transparent Gateway       FALSE
Undo Advisor        FALSE
Virtual Private Database (VPD)      TRUE
XDB         TRUE
LOB         FALSE
Object         FALSE
Extensibility        TRUE
Change Data Capture       FALSE
Materialized Views (User)      FALSE

69 rows selected.