Para complementar o post anterior, uma lista das caracteristicas por “Edition”. Nos treinamentos Oracle 10g Workshop I da Oracle Education, uma das perguntas mais frequentes é :
- Esta feature/caracteristica é Enterprise ou Standard ? .
A tabela abaixo responde este questionamento. Vale para Oracle 10g R2
| Feature/Option | SE1 | SE | EE | Notes |
|---|---|---|---|---|
| High Availability | ||||
| Oracle Fail Safe | Y | Y | Y | Windows only |
| Oracle Data Guard—Redo Apply | N | N | Y | |
| Oracle Data Guard—SQL Apply | N | N | Y | |
| Rolling Upgrades—Patch Set, Database, and Operating System | N | N | Y | |
| Online index rebuild | N | N | Y | |
| Online index-organized table organization | N | N | Y | ALTER TABLE … MOVE ONLINE operations |
| Online table redefinition | N | N | Y | Using the DBMS_REDEFINITION package |
| Duplexed backup sets | N | N | Y | |
| Incremental backup and recovery | Y | Y | Y | SE1/SE: no optimized incremental backup |
| Unused block compression in backups | N | N | Y | |
| Block-level media recovery | N | N | Y | |
| Parallel backup and recovery | N | N | Y | |
| Tablespace point-in-time recovery | N | N | Y | |
| Trial recovery | N | N | Y | |
| Fast-start fault recovery | N | N | Y | |
| Flashback Table | N | N | Y | |
| Flashback Database | N | N | Y | |
| Flashback Transaction Query | N | N | Y | |
| Scalability | ||||
| Oracle Real Application Clusters | N | Y | Y | Extra cost with EE, included with SE |
| Automatic Workload Management | N | Y | Y | Requires RAC |
| Performance | ||||
| In-Memory Database Cache | N | N | Y | Extra cost option |
| Security | ||||
| Advanced Security Option | N | N | Y | Extra cost option |
| Oracle Label Security | N | N | Y | Extra cost option |
| Virtual Private Database | N | N | Y | |
| Fine-grained auditing | N | N | Y | |
| Development Platform | ||||
| SQLJ | Y | Y | Y | Requires Oracle Programmer |
| 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 |
| Manageability | ||||
| Oracle Change Management Pack | N | N | Y | Extra cost option |
| Oracle Configuration Management Pack | N | N | Y | Extra cost option |
| Oracle Diagnostic Pack | N | N | Y | Extra cost option |
| Oracle Tuning Pack | N | N | Y | Extra cost option, also requires the Diagnostic Pack |
| Oracle Provisioning and Patch Automation Pack | N | N | Y | Extra cost option |
| Database Resource Manager | N | N | Y | |
| VLDB, Data Warehousing, Business Intelligence | ||||
| Oracle Partitioning | N | N | Y | Extra cost option |
| Oracle OLAP | N | N | Y | Extra cost option |
| Oracle Data Mining | N | N | Y | Extra cost option |
| Oracle Data Quality and Profiling | N | N | Y | Extra cost option |
| Oracle Data Watch and Repair Connector | N | N | Y | Extra cost option |
| Data Compression | N | N | Y | |
| Bitmapped index and bitmapped join index | N | N | 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 | |
| Transportable tablespaces, including cross-platform | N | N | Y | Import of transportable tablespaces supported into SE, SE1, and EE |
| Summary management—Materialized View Query Rewrite | N | N | Y | |
| Asynchronous Change Data Capture | N | N | Y | |
| Integration | ||||
| Basic Replication | Y | Y | Y | SE1/SE: read-only, updateable materialized view |
| Transparent Gateways | Y | Y | Y | Extra cost option |
| Oracle Streams | N | N | Y | SE1/SE: apply only |
| Messaging Gateway | N | N | Y | |
| Advanced Replication | N | N | Y | Multi-master replication |
| Networking | ||||
| Oracle Connection Manager | N | N | Y | |
| Infiniband Support | N | N | Y | |
| Content Management | ||||
| Oracle Spatial | N | N | Y | Extra cost option |
| Oracle Content Database Suite | N | N | Y | Extra cost option |
| Oracle Records DB | N | N | Y | Extra cost option |
