Data warehousing features only in
Enterprise Edition include compression of repeating stored data values, crossplatform
transportable tablespaces, Information Lifecycle Management (ILM),
materialized views query rewrite, and the Partitioning, OLAP, and Data Mining
Options. High-availability features unique to the Enterprise Edition include Data
Guard and Flashback database, Flashback table, and Flashback transaction
query. Added to Oracle Database 11g are an Advanced Compression Option for
all workloads, including transaction processing, Large Object (LOB) storage,
and backups; a database testing option called the Real Application Testing
Option that includes Database Replay and SQL Performance Analyzer; and a
Total Recall Option used to enable a Flashback Data Archive that retains data
for historic queries (where a SQL construct specifies an ???AS OF??? date in the
past).
Oracle Standard Edition
Oracle??™s database intended for small and medium-sized implementations. This
database can be deployed onto server configurations containing up to 4 CPUs on
a single system or on a cluster using Real Application Clusters (RAC).
Pages:
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50