I'm checking possibilty of downgrade Oracle 11g from Enterpise Edition to Standard One edition. I've cross-checked edition comparison with
select name from dba_feature_usage_statistics where currently_used='TRUE'
Query result from dba_feature_usage_statistics:
Job Scheduler Oracle Java Virtual Machine (user) Oracle Java Virtual Machine (system) Automatic Memory Tuning Oracle Utility Metadata API Segment Advisor Automatic SQL Tuning Advisor Object Materialized Views (User) Audit Options Automatic Maintenance - Optimizer Statistics Gathering Automatic Maintenance - Space Advisor Automatic Maintenance - SQL Tuning Advisor Automatic Segment Space Management (system) Automatic Segment Space Management (user) Automatic Undo Management Client Identifier Character Set Locally Managed Tablespaces (system) Locally Managed Tablespaces (user) Parallel SQL Query Execution Partitioning (system) Recovery Area Recovery Manager (RMAN) RMAN - Disk Backup Backup BASIC Compression Logfile Multiplexing Server Parameter File Shared Server Streams (user) LOB SecureFiles (system)
I think Parallel SQL Query Execution and Partitioning (system) are only in Enterprise Edition, but I'm not sure about rest, especially:
Automatic Memory Tuning Segment Advisor Automatic SQL Tuning Advisor Automatic Maintenance - SQL Tuning Advisor Recovery Area
Do you guys know which edition of Oracle is needed to use these features?