To check which features are used you shall check:
select name,version,detected_usages,currently_used,
to_char(first_usage_date, 'DD-MON-RRRR') as "FIRST USAGE",
to_char(last_usage_date, 'DD-MON-RRRR') as "LAST USAGE"
from dba_feature_usage_statistics
order by currently_used desc, name
SQL> select name,version,detected_usages,currently_used,
2 to_char(first_usage_date, 'DD-MON-RRRR') as "FIRST USAGE",
3 to_char(last_usage_date, 'DD-MON-RRRR') as "LAST USAGE"
4 from dba_feature_usage_statistics
5 order by currently_used desc, name;
NAME VERSION DETECTED_USAGES CURRE FIRST USAGE LAST USAGE
---------------------------------------------------------------- ----------------- --------------- ----- -------------------- ---------------
Automatic Maintenance - Optimizer Statistics Gathering 11.2.0.3.0 6 TRUE 09-MAY-2013 28-JUN-2013
Automatic Maintenance - SQL Tuning Advisor 11.2.0.3.0 6 TRUE 09-MAY-2013 28-JUN-2013
Automatic Maintenance - Space Advisor 11.2.0.3.0 6 TRUE 09-MAY-2013 28-JUN-2013
Automatic SGA Tuning 11.2.0.3.0 6 TRUE 09-MAY-2013 28-JUN-2013
Automatic SQL Execution Memory 11.2.0.3.0 6 TRUE 09-MAY-2013 28-JUN-2013
Automatic Segment Space Management (system) 11.2.0.3.0 6 TRUE 09-MAY-2013 28-JUN-2013
Automatic Undo Management 11.2.0.3.0 6 TRUE 09-MAY-2013 28-JUN-2013
Character Set 11.2.0.3.0 6 TRUE 09-MAY-2013 28-JUN-2013
Deferred Segment Creation 11.2.0.3.0 6 TRUE 09-MAY-2013 28-JUN-2013
Locally Managed Tablespaces (system) 11.2.0.3.0 6 TRUE 09-MAY-2013 28-JUN-2013
Locally Managed Tablespaces (user) 11.2.0.3.0 6 TRUE 09-MAY-2013 28-JUN-2013
Object 11.2.0.3.0 2 TRUE 20-JUN-2013 28-JUN-2013
Oracle Java Virtual Machine (system) 11.2.0.3.0 6 TRUE 09-MAY-2013 28-JUN-2013
Partitioning (system) 11.2.0.3.0 6 TRUE 09-MAY-2013 28-JUN-2013
Recovery Area 11.2.0.3.0 6 TRUE 09-MAY-2013 28-JUN-2013
SecureFiles (system) 11.2.0.3.0 6 TRUE 09-MAY-2013 28-JUN-2013
SecureFiles (user) 11.2.0.3.0 6 TRUE 09-MAY-2013 28-JUN-2013
Server Parameter File 11.2.0.3.0 6 TRUE 09-MAY-2013 28-JUN-2013
Virtual Private Database (VPD) 11.2.0.3.0 6 TRUE 09-MAY-2013 28-JUN-2013
ADDM 11.2.0.3.0 0 FALSE
ASO native encryption and checksumming 11.2.0.3.0 0 FALSE
AWR Baseline 11.2.0.3.0 0 FALSE
AWR Baseline Template 11.2.0.3.0 0 FALSE
AWR Report 11.2.0.3.0 0 FALSE
Active Data Guard - Real-Time Query on Physical Standby 11.2.0.3.0 0 FALSE
Advanced Replication 11.2.0.3.0 0 FALSE
Application Express 11.2.0.3.0 0 FALSE
Audit Options 11.2.0.3.0 0 FALSE
Automatic Memory Tuning 11.2.0.3.0 0 FALSE
Automatic SQL Tuning Advisor 11.2.0.3.0 4 FALSE 20-MAY-2013 20-JUN-2013
Automatic Segment Space Management (user) 11.2.0.3.0 0 FALSE
Automatic Storage Management 11.2.0.3.0 0 FALSE
Automatic Workload Repository 11.2.0.3.0 0 FALSE
To check which options are installed you shall check:
SELECT comp_name, version, status FROM dba_registry;
SQL> SELECT comp_name, version, status FROM dba_registry;
COMP_NAME VERSION STATUS
---------------------------------------- ------------------------------ --------------
OWB 11.2.0.3.0 VALID
Oracle Application Express 3.2.1.00.12 VALID
Oracle Enterprise Manager 11.2.0.3.0 VALID
OLAP Catalog 11.2.0.3.0 VALID
Spatial 11.2.0.3.0 VALID
Oracle Multimedia 11.2.0.3.0 VALID
Oracle XML Database 11.2.0.3.0 VALID
Oracle Text 11.2.0.3.0 VALID
Oracle Expression Filter 11.2.0.3.0 VALID
Oracle Rules Manager 11.2.0.3.0 VALID
Oracle Workspace Manager 11.2.0.3.0 VALID
Oracle Database Catalog Views 11.2.0.3.0 VALID
Oracle Database Packages and Types 11.2.0.3.0 VALID
JServer JAVA Virtual Machine 11.2.0.3.0 VALID
Oracle XDK 11.2.0.3.0 VALID
Oracle Database Java Packages 11.2.0.3.0 VALID
OLAP Analytic Workspace 11.2.0.3.0 VALID
Oracle OLAP API 11.2.0.3.0 VALID
No comments:
Post a Comment