Funktionen von Oracle9i Standard und Enterprise Edition im
Werbung
Funktionen von Oracle9i Standard und Enterprise Edition im Vergleich: Feature/Option Oracle9i Standard Edition Oracle9i Enterprise Edition Bemerkung Hochverfügbarkeit Oracle Data Guard – Redo Apply Oracle Data Guard – SQL Apply Basic readable standby database Fast-start selectable recovery time Online index build Online table reorganization/redefinition Online index coalesce Global index maintenance during DDL Flashback Query Quiesce database Block-level media recovery Incremental backup and recovery Online backup and recovery Parallel backup and recovery Point-in-time tablespace recovery Trial recovery Oracle Fail Safe Transparent application failover N N J N N N N J J N N N J N N N J N J J J J J J J J J J J J J J J J J J Skalierbarkeit Oracle Real Application Cluster Cluster File System Java native compilation PL/SQL native compilation N N J J J J J J kostenpflichtig erfordert RAC Sicherheit Advanced Security Option Oracle Label Security Encryption toolkit Virtual Private Database Fine grained auditing DBA auditing Password management Proxy authentication N N J N N J J J J J J J J J J J kostenpflichtig kostenpflichtig Entwicklungsumgebung Oracle Programmer Java support SQLJ J J J J J J kostenpflichtig J J J J J J J J J J J J J J J J JDBC drivers XML DB Objects and extensibility PL/SQL stored procedures and triggers PL/SQL Server Pages User-defined aggregates COM Automation Feature Microsoft Transaction Server/COM+ integration Seite 1 von 3 nur Windows erfordert Oracle Programmer nur Windows nur Windows Feature/Option Oracle9i Standard Edition Oracle OLE DB Provider Oracle Objects for OLE (0040) VLM Support OLE DB.NET and ODBC.NET support Native .NET Data Provider – ODP.NET 64-bit Itanium support for Windows, Linux, and HP-UX Globalization support Autonomous transactions SQL*Plus iSQL*Plus Oracle9i Enterprise Edition J J J J J J J J J J J J J J J J J J J J Managementfunktionen Oracle Enterprise Manager Oracle Change Management Pack Oracle Diagnostics Pack Oracle Tuning Pack Oracle Management Pack for SAP R/3 Automatic undo management Self-tuning memory management Server managed backup and recovery Recovery Manager Legato Storage Manager Duplexed backup sets Database Resource Manager Oracle Managed Files Locally Managed Tablespaces Resumable space allocation Unused index identification J N N N N J J J J J N N J J J J J J J J J J J J J J J J J J J J VLDB, Data Warehousing, Business Intelligence Oracle Partitioning Oracle OLAP Oracle Data Mining Data Compression Optimizer statistics management Analytic functions Bitmapped index and bitmappes join index Descending index Function-based index Automated parallel query degree Parallel statistics gathering Parallel bitmap star query optimization Parallel DML N N N N J J N J J N N N N J J J J J J J J J J J J J Parallel index build Parallel index scans Parallel load Parallel query Star query optimization Sample scan Summery management N N J N J J N J J J J J J J Seite 2 von 3 Bemerkung nur Windows nur Windows nur Windows nur Windows nur Windows kostenpflichtig kostenpflichtig kostenpflichtig kostenpflichtig kostenpflichtig kostenpflichtig kostenpflichtig erfordert keine Partitioning Option mehr Feature/Option Oracle9i Standard Edition Oracle9i Enterprise Edition Long operations monitor Direct Path Load API Export transportable tablespace Import transportable tablespace External tables MERGE Multi-table insert Pipelined table functions Synchronous Change Data Capture Integration Oracle Streams Advanced Queuing Oracle Workflow Messaging Gateway to IBM MQSeries Distributed Queries Distributed transactions Heterogeneous Services Basic replication J J N J J J J J N J J J J J J J J J N J J N J J J J J J J J J J J J Advanced replication N J Networking Connection pooling Oracle Connection Manager Oracle Names Oracle Net Services J N J J J J J J Content Management Oracle Spatial Dynamic Services Oracle Database Workspace Manager Parallel text index creation Ultra Search interMedia Oracle Text N J J N J J J J J J J J J J Zusätzliche Datenbank Funktionen Database event triggers DBMS_REPAIR package DBMS_METADATA package Drop column Rename column, constraint Index-organized table Instead-of triggers LOB (large Object) support Locally-managed tablespaces LogMiner Multiple block size support Plan stability Reserve key index Temporary table J J J J J J J J J J J J J J J J J J J J J J J J J J J J Seite 3 von 3 Bemerkung Update Materialized Views Multi-Master Replikation kostenpflichtig