What is the difference between Oracle Enterprise Edition and Standard Edition?

Differences: 1. The standard version is suitable for servers with 1-4CPU, including 4CPU single server or 2 dual-CPU servers, while the enterprise version is suitable for single machine, dual machine, multi-CPU multi-node cluster, etc. environment; 2. The standard version does not support VPD, FGA, Flashback and other functions, but the enterprise version supports them.

The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.

What is the difference between Oracle Enterprise Edition and Standard Edition?

A brief introduction:

1. The Standard Edition is suitable for servers with 1-4 CPUs, including Configurations such as 4 CPU single server or 2 dual CPU servers can be used as dual-machine hot standby or RAC. The price is moderate and suitable for large and medium-sized users, workgroup-level and department-level applications that have further requirements for database performance and security;

2. The enterprise version is suitable for various environments such as single-machine, dual-machine, multi-CPU multi-node clusters, etc. It has complete functions, but the cost is relatively high. It is suitable for large and ultra-large enterprises that have very high requirements for database performance and reliability. User enterprise-level and high-end enterprise-level applications.

Comparative analysis:

The main features that the Standard Edition lacks compared to the Enterprise Edition are as follows:

1. Does not support Oracle Data Guard. Want high availability Customers cannot choose the standard version)

2. Some Online operations, such as Online index maintenance, Online table redefinition, etc. are not supported

3. Some operations of backup and recovery are limited. For example, it does not support Block-level media recovery (Block-level media recovery), parallel backup and recovery (Parallel backup and recovery), multiple backup (Duplexed backup sets), etc.

4. The Flashback function is in the standard Flashback Table, Flashback Database, and Flashback Transaction Query are not supported in this version

5. VPD (Virtual Private Database) is not supported

6. FGA (Fine-grained auditing) is not supported

7. Partitioning, partitioning is not supported.

8. Data compression, such as table compression and partition compression are not supported.

9. Bitmapped index and bitmapped join index are not supported. , (If it is a data warehouse system, you cannot choose the standard version)

10. Export transportable tablespace, (note that only import is not supported here), but Import transportable tablespace, including cross-platform import, are supported , that is to say, if you choose the standard version, it will be more difficult to simply transfer the database to other platforms

11. Some parallel operations are not supported, including Parallel query, Parallel DML, Parallel index build, Parallel Data Pump export and import.

12. Streams is not supported, and a high availability solution is missing.

13. Advanced Replication’s multimaster method is not supported, and a high availability solution is missing. Of course, the materialized view is The replication scheme is still supported

14. Connection Manager is not supported.

To sum up, in order to realize the development of office automation system, it is recommended to use Oracle Enterprise Edition to add solutions for large-volume data management and backup.

If the current system data volume of the enterprise is not large at this stage, Oracle Standard Edition can also meet the needs, but it will increase some risks compared to using Oracle Enterprise Edition.

Recommended tutorial: "Oracle Tutorial"

The above is the detailed content of What is the difference between Oracle Enterprise Edition and Standard Edition?. For more information, please follow other related articles on the PHP Chinese website!