The following table outlines the database features and options associated with
each edition of
Oracle Database
11g.
FEATURE/OPTION
|
SE1
|
SE
|
EE
|
NOTES
|
HIGH AVAILABILITY
|
||||
Oracle Data Guard
– Redo Apply
|
N
|
N
|
Y
|
|
Oracle Data Guard
– SQL Apply
|
N
|
N
|
Y
|
|
Oracle Data Guard—Snapshot
Standby
|
N
|
N
|
Y
|
|
Oracle Active Data Guard
|
N
|
N
|
Y
|
Enterprise Option
(Active Data Guard)
|
Oracle Data Guard –
Network Compression
|
N
|
N
|
Y
|
Enterprise Option
(Advanced Compression Option)
|
Basic Standby Database (Manually managed)
|
Y
|
Y
|
Y
|
|
Rolling Upgrades – Patch Set, Database and
O/S
|
N
|
N
|
Y
|
|
Fast-Start Fault Recovery
|
N
|
N
|
Y
|
|
Online index rebuild
|
N
|
N
|
Y
|
|
Online index-organized table reorganization
|
N
|
N
|
Y
|
via ALTER TABLE MOVE ONLINE
|
Online table redefinition
|
N
|
N
|
Y
|
via DBMS_REDEFINITI ON
|
Online system changes
– CPU, disk, memory
|
Y
|
Y
|
Y
|
|
Flashback Query
|
Y
|
Y
|
Y
|
|
Flashback Table
|
N
|
N
|
Y
|
|
Flashback Database
|
N
|
N
|
Y
|
|
Flashback Transaction
|
N
|
N
|
Y
|
|
Flashback Transaction Query
|
N
|
N
|
Y
|
|
Flashback Data
Archive (“Oracle Total
Recall”)
|
N
|
N
|
Y
|
Enterprise Option
|
Block Level Media Recovery
|
N
|
N
|
Y
|
|
Online Backup and Recovery
|
Y
|
Y
|
Y
|
|
Incremental Backup and
Recovery
|
Y
|
Y
|
Y
|
EE only: fast
incremental backups available via
change tracking
|
Unused Block
Compression in Backups
|
N
|
N
|
Y
|
|
Parallel Backup and Recovery
|
N
|
N
|
Y
|
|
Default RMAN Compression (BZIP2)
|
Y
|
Y
|
Y
|
|
Fast
RMAN Compression
(ZLIB)
|
N
|
N
|
Y
|
Enterprise Option
(Advanced Compression Option)
|
Point-in-time Tablespace Recovery
|
N
|
N
|
Y
|
|
Trial Recovery
|
N
|
N
|
Y
|
|
Oracle Fail Safe
|
Y
|
Y
|
Y
|
Windows only
|
Data
Recovery Advisor
|
Y
|
Y
|
Y
|
|
Transaction Application Failover
|
Y
|
Y
|
Y
|
|
PERFORMANCE &
SCALABILITY
|
||||
Oracle Real Application Clusters
|
N
|
Y
|
Y
|
Enterprise
Option, and
included with SE
|
Oracle Clusterware
|
Y
|
Y
|
Y
|
|
Automatic Workload Management
|
N
|
Y
|
Y
|
Requires RAC
|
Support for Oracle Exadata Storage
Server
|
N
|
N
|
Y
|
|
In-Memory
Database Cache
|
N
|
N
|
Y
|
Enterprise Option
|
SECURITY
|
||||
Oracle Advanced Security
|
N
|
N
|
Y
|
Enterprise Option
|
Oracle Label Security
|
N
|
N
|
Y
|
Enterprise Option
|
Data Masking Pack
|
N
|
N
|
Y
|
Enterprise Option
|
Encryption Toolkit
|
Y
|
Y
|
Y
|
|
Fine
Grained Auditing
|
N
|
N
|
Y
|
|
Secure Application Role
|
N
|
N
|
Y
|
|
DEVELOPMENT PLATFORM
|
||||
Java Support
|
Y
|
Y
|
Y
|
|
Database Web Services
|
Y
|
Y
|
Y
|
|
SQLJ
|
Y
|
Y
|
Y
|
|
JDBC
Drivers
|
Y
|
Y
|
Y
|
|
XML Support in Database
|
Y
|
Y
|
Y
|
Includes
Binary XML, XML Object- Relational, XML Index,
XML
Repository
|
XQuery
|
Y
|
Y
|
Y
|
|
Objects and Extensibility
|
Y
|
Y
|
Y
|
|
Regular Expressions
|
Y
|
Y
|
Y
|
|
PL/SQL Stored Procedures
and Triggers
|
Y
|
Y
|
Y
|
|
PL/SQL Server Pages
|
Y
|
Y
|
Y
|
|
Java Server Pages
|
Y
|
Y
|
Y
|
|
Java Native Compilation
|
Y
|
Y
|
Y
|
|
PL/SQL Native Compilation
|
Y
|
Y
|
Y
|
|
PL/SQL Function Result Cache
|
N
|
N
|
Y
|
|
Client Side Query Cache
|
N
|
N
|
Y
|
|
Oracle Developer Tools for Visual
Studio Net
|
Y
|
Y
|
Y
|
Windows Only
|
Microsoft Distributed Transaction
Coordinator Support
|
Y
|
Y
|
Y
|
Windows Only
|
Active Directory Integration
|
Y
|
Y
|
Y
|
Windows Only
|
Native .NET Data
Provider – ODP.NET
|
Y
|
Y
|
Y
|
Windows Only
|
.NET
Stored Procedures
|
Y
|
Y
|
Y
|
Windows Only
|
Globalization Support
|
Y
|
Y
|
Y
|
|
Application Express
|
Y
|
Y
|
Y
|
|
SQL*Plus
|
Y
|
Y
|
Y
|
|
SQL
Developer
|
Y
|
Y
|
Y
|
|
MANAGEABILITY
|
||||
Oracle Change Management Pack
|
N
|
N
|
Y
|
Enterprise Option
|
Oracle Configuration Management Pack
|
N
|
N
|
Y
|
Enterprise Option
|
Oracle Diagnostic Pack
|
N
|
N
|
Y
|
Enterprise Option
|
Oracle Tuning Pack
|
N
|
N
|
Y
|
Enterprise Option
|
Oracle Provisioning and
Patch Automation Pack
|
N
|
N
|
Y
|
Enterprise Option
|
Fast, Lightweight
Server Install
|
Y
|
Y
|
Y
|
|
Easy
Client Install
|
Y
|
Y
|
Y
|
|
Oracle Enterprise Manager – Database Control
|
Y
|
Y
|
Y
|
|
Automatic Memory management
|
Y
|
Y
|
Y
|
|
Automatic Storage management
|
Y
|
Y
|
Y
|
|
Automatic Undo management
|
Y
|
Y
|
Y
|
|
Automatic Statistics
management
|
Y
|
Y
|
Y
|
|
Server Managed
Backup and Recover (RMAN)
|
Y
|
Y
|
Y
|
|
Automatic Backup/Recovery to Flash
Recovery Area
|
Y
|
Y
|
Y
|
|
Duplexed Backup Sets
|
N
|
N
|
Y
|
|
Server-Generated Alerts
|
Y
|
Y
|
Y
|
|
End-to-End Application Testing
|
Y
|
Y
|
Y
|
|
Database Resource Manager
|
N
|
N
|
Y
|
|
SQL
Plan Management
|
N
|
N
|
Y
|
|
Resumable Space Allocation
|
Y
|
Y
|
Y
|
|
VLDB, DATA WAREHOUSING,
BUSINESS INTELLIGENCE
|
||||
Oracle Partitioning
|
N
|
N
|
Y
|
Enterprise option
|
Oracle OLAP
|
N
|
N
|
Y
|
Enterprise option
|
Oracle Data Mining
|
N
|
N
|
Y
|
Enterprise option
|
Direct Load Data Compression
|
N
|
N
|
Y
|
|
OLTP
Compression
|
N
|
N
|
Y
|
Enterprise
Option (Advanced Compression
Option)
|
SQL
Analytics Functions
|
Y
|
Y
|
Y
|
|
Bitmapped index and Bitmapped
Join Index
|
N
|
N
|
Y
|
|
Function-Based Index
|
Y
|
Y
|
Y
|
|
Parallel Query/DML
|
N
|
N
|
Y
|
|
Parallel Statistics
Gathering
|
N
|
N
|
Y
|
|
Parallel Index Build/Scans
|
N
|
N
|
Y
|
|
Parallel Data Pump Export/Import
|
N
|
N
|
Y
|
SE Non-Parallel Data
Pump
only
|
Data Pump Compression
|
N
|
N
|
Y
|
Enterprise
Option (Advanced Compression Option)
|
Export Transportable Tablespace, including Cross-Platform
|
N
|
N
|
Y
|
|
Import Transportable Tablespace
|
Y
|
Y
|
Y
|
|
Star
Query Transformation
|
Y
|
Y
|
Y
|
SE B-Tree Indexes
Only
|
Sample Scan
|
Y
|
Y
|
Y
|
|
Summary Management – Materialized
View Creation and Refresh
|
Y
|
Y
|
Y
|
|
Summary Management – Materialized View
Query Rewrite
|
N
|
N
|
Y
|
|
Direct Path Load API
|
Y
|
Y
|
Y
|
|
External Tables
|
Y
|
Y
|
Y
|
|
SQL
Model
|
Y
|
Y
|
Y
|
|
Synchronous Change Data Capture
|
Y
|
Y
|
Y
|
|
Asynchronous Change Data Capture
|
N
|
N
|
Y
|
|
Query Rewrite Cache
|
N
|
N
|
Y
|
|
INTEGRATON
|
||||
Oracle Streams
|
Y
|
Y
|
Y
|
SE1/SE no Asynchronous Capture from Log File (Online Redo
or Archive)
|
Oracle Streams Advanced
Queuing
|
Y
|
Y
|
Y
|
|
Messaging
Gateway
|
N
|
N
|
Y
|
|
Basic Replication
|
Y
|
Y
|
Y
|
Read only and
updateable materialized
views. Also single master for updateable MVs and
multi-tier MVs.
|
Advanced replication
|
N
|
N
|
Y
|
Multi-Master
Replication
|
Distributed Queries/Transactions
|
Y
|
Y
|
Y
|
|
Job
Scheduler
|
Y
|
Y
|
Y
|
|
External Procedures
|
Y
|
Y
|
Y
|
|
Generic Connectivity
|
Y
|
Y
|
Y
|
|
Transparent Gateways
|
Y
|
Y
|
Y
|
Licensed
separately for SE/EE
|
NETWORKING
|
||||
Connection Pooling
|
Y
|
Y
|
Y
|
|
Oracle Connection manager
|
N
|
N
|
Y
|
|
Infiniband
Support
|
N
|
N
|
Y
|
|
CONTENT
|
||||
Oracle Spatial
|
N
|
N
|
Y
|
Enterprise Option
|
Semantic Technologies (RDF/OWL)
|
N
|
N
|
Y
|
Requires Spatial,
Advanced Compression and Partitioning Options
|
Oracle Locator
|
Y
|
Y
|
Y
|
|
Oracle Workspace manager
|
Y
|
Y
|
Y
|
|
Medial Images (DICOM)
|
Y
|
Y
|
Y
|
|
Multimedia
|
Y
|
Y
|
Y
|
|
Oracle Text
|
Y
|
Y
|
Y
|
|
SecureFiles
|
Y
|
Y
|
Y
|
Compression, deduplication are part of
an Enterprise Option (Advanced Compression
Option). Encryption is part
of an Enterprise
Option (Advanced Security Option)
|
ADDITIONAL DATABASE FEATURES
|
||||
Database Event Triggers
|
Y
|
Y
|
Y
|
|
Drop
Column
|
Y
|
Y
|
Y
|
|
Rename Column, Constraint
|
Y
|
Y
|
Y
|
|
Virtual Column
|
Y
|
Y
|
Y
|
Use of virtual
columns as primary keys or foreign
keys require EE and Oracle Partitioning
Option
|
Invisible
Indexes
|
Y
|
Y
|
Y
|
|
Index-Organized Tables
|
Y
|
Y
|
Y
|
|
Instead-of Triggers
|
Y
|
Y
|
Y
|
|
LOB
(Large Object) Support
|
Y
|
Y
|
Y
|
|
LogMiner
|
Y
|
Y
|
Y
|
|
Multiple Block Size Support
|
Y
|
Y
|
Y
|
|
Temporary Table
|
Y
|
Y
|
Y
|
No comments:
Post a Comment