What are the differences between Oracle versions?

This article mainly introduces the differences between Oracle versions. From Oracle database-related products, from Oracle2.0 (no 1.0) to Oracle7.3.4, it is a relatively simple version of Oracle, starting with Oracle8, the identifier of a database product, such as Oracle8i and 9i, is displayed.

Internet stands for "I", indicating that this product fully supports Internet applications. Simply put, it integrates JAVA technology and JAVA support.

From Oracle10 to 10g, this g stands for Grid, indicating that it supports "Grid operations". Simply put, it is better to support clusters and multi-point applications. So far, the latest version is Oracle11g, and Oracle also has a product called Oracle11i, Which is full name of Oracle Applications 11i. Here I is short for Intelligence, which indicates that e-commerce intelligent software is not a database product, it is a complete set of e-commerce kits, a comprehensive set of business application software, mainly including the following functional modules:

. Financial management-Oracle Financial Management System Financials)

. Human resource Management-Oracle Human Resources Management System)

. Business Intelligence-Oracle E-Commerce Intelligence E-Business Intelligence) is a set of applications for report preparation and analysis.

. Logistics Management-Oracle Logistics management system Logistics)

. Maintenance Management-Oracle Enterprise Asset Management), Oracle Integrated Maintenance, Repair and Overhaul Management system Maintenance, Repair, and Overhaul)

. Manufacturing Management-Oracle Manufacturing Management System Manufacturing)

. Marketing Management-Oracle Marketing Management System Marketing)

. Order Fulfillment management-Oracle Order Fulfillment management system Order Fulfillment)

. Product Lifecycle Management-Product Lifecycle Management of Oracle products)

. Procurement Management-Oracle Procurement management system Procurement)

. Project Management-Oracle project management system Projects)

. Sales Management-Oracle Sales management system Sales)

. Supply Chain Planning-Oracle Supply Chain Planning system Supply Chain Planning)

Oracle 10 Gb is divided into four Oracle versions:

1. Oracle Database Standard Edition One, the most basic commercial version, including basic Database functions.

2. Oracle Database Standard Edition, Standard Edition, including the features and RAC of the above Oracle version. RAC is included only in the 10 Gb Standard Edition.

3. although Oracle Database Enterprise Edition and Enterprise Edition are the most powerful versions, not all of the features we commonly use are in this version, and many things still require additional charges, it will be mentioned later.

4. Oracle Database Personal Edition, Personal Edition, includes all features of the Enterprise Edition except RAC, but note that only the Personal Edition is available on Windows platforms.

Next let's take a look at the features that are not supported in Standard Edition One and Standard Edition, but some of them are common or commonly used.) Note, in addition to RAC, these features are still included in the Personal Edition.

1. Oracle Data Guard, not supported. Customers who want high availability cannot select the Standard Edition)

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

3. backup and recovery operations are limited, such as Block-level media recovery), Parallel backup and recovery of Parallel backup and recovery), multiple backup Duplexed backup sets) and so on.

4. Flashback function. Flashback Table, Flashback Database, and Flashback Transaction Query are not supported in the Standard Edition.

5. VPDVirtual Private Database) not supported

6. FGAFine-grained auditing) not supported

7. Partitioning, partitions are not supported either.

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, the standard version cannot be selected)

10. export transportable tablespace. Note that Import is not supported here), but import transportable tablespace, including cross-platform Import, is supported. That is to say, if you select Standard Edition, it is 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 feasible high availability solution is missing.

13. The multi-master mode of Advanced Replication is not supported. There is only one more high-availability solution. Of course, the Replication solution of the materialized view is still supported.

14. Connection Manager is not supported.

The standard version supports RAC in 10 Gb, But Oracle has restrictions. To use RAC in the standard version, you can only use Oracle Clusterware and do not support any other third-party cluster software ), at the same time, you must use ASM to store and manage data files. other third-party volume management and file systems are not supported ).

If you want to install another database as RMAN repository or OEM Grid Control repository, you do not need to pay additional fees.

In addition, if you purchased the Oracle version of Standard One at the lowest level, the following functions are not supported.

1. RAC

2. Partitioning

3. Data Mining

4. Advanced Security

5. Label Security

6. OLAP

7. Spatial

8. Oracle Management Packs

Finally, there are some FAQs about Oracle products:

1. What version is currently on sale for Oracle database software?

A: Oracle 9i and Oracle 10g are currently on sale.

2. Is 10g better than 9i?

A: After the launch of A new version of software, it will take some time to test, during which there will be A lot of patches. However, new versions of software often have more new features and more friendly interfaces. 9i and 10g are currently on sale. In comparison, 9i is more stable and mature, while 10 Gb provides more new features. We recommend that you select the best one based on your business needs. Because this FAQ is from the previous year, we recommend that you select the Oracle 10G R2 version)

3. What types of Oracle Database software are available in Oracle?

A: Oracle database software is divided into Personal Edition, Standard Edition 1, Standard Edition, and Enterprise Edition.

4. Can you tell us the characteristics and differences between the Personal Edition, Standard Edition 1, Standard Edition and Enterprise Edition?

A: Standard Edition 1 Standard Edition One) is applicable to servers with 1 to 2 CPUs. It has A considerable price advantage, but is only available in single-host environments and is suitable for entry-level applications for small and medium users;

Standard Edition) is applicable to 1-4 CPU servers, including 4-CPU Single Server or 2 dual-CPU servers. It can be used for dual-machine hot standby or RAC, and the price is moderate, applicable to applications at the working group level and department level for large and medium-sized users who have further requirements on database performance and security;

Enterprise Edition) is applicable to standalone, dual-host, multi-CPU, multi-node clusters, and other environments with complete functions, but the cost is relatively high, it is suitable for large-scale enterprise-level and high-end enterprise-level applications with high database performance and reliability requirements.

For more information about the functional modules, see Oracle Database whitepaper.

5. Is Enterprise Edition better than Standard Edition?

A: The Enterprise Edition is fully functional and provides higher reliability and performance, but it also means more software and hardware costs. We recommend that you determine the Oracle version based on your actual needs. The most suitable one is the best.

6. What is the Oracle ordering method?

A: There are two ways to order by number of users and by CPU, in which the order by CPU is also called the unlimited user version.

7. What is the official definition of Oracle users?

A: Every User accessing the Oracle database, whether it is A natural person or A device, is counted as A User (Named User ).

Official English definition: Named User Plus: is defined as an individual authorized by you to use the programs which are installed on a single server or multiple servers, regardless of whether the individual is actively using the programs at any given time. A non human operated device will be counted.

8. How does one calculate the number of Oracle users?

A: The minimum number of users of Oracle official versions is:

Individual version: 1 user * PC count

Standard Edition 1 = number of servers x 5

Standard Edition = server CPU x 10 Users

Enterprise Edition = server CPU x 25 users;

Users should order according to their actual number of users, and not less than the minimum number of users required by the corresponding Oracle version.

9. Under what circumstances should I order according to the CPU?

A: If the number of users accessing Oracle is large, or the number of users cannot be estimated, the order should be made according to CPUProcessor.

10. What is the official definition of Processor?

A: equal to the total number of CPUs of servers that install Oracle database software.

Official English definition: Processor: shall be defined as all processors where the Oracle programs are installed and/or running. programs licensed on a Processor basis may be accessed by your internal users (including agents and contractors) and by your third party users.

11. Could you give an example?

A: For example, if your application is based on the Internet and Oracle is the website background database, each user accessing the website database through the Internet is counted as one user according to Oracle's official definition of the number of users, in this way, the number of users is large and cannot be estimated, so you should order according to the number of CPU.

12. Is the fee charged by CPU High?

A: Generally, the cost of 1 CPU is about 50 users. Therefore, if the number of users is greater than the number of CPUs * 50, it is more economical to order by CPU.

13. do Internet or B/S architecture applications have to be subscribed to by CPU?

A: Not necessarily. If the number of users accessing the Oracle database is estimated, and the number of users is not much smaller than the number of server CPUs * 50), you can also order the number of users.

14. What is the public Price List Price for Oracle database software?

A: Please refer to the public quotation List Price) table.

15. How is the price calculated for Oracle database software?

A: formula: Q = (P * N * (1-D) * (1 + 22%) + 415) * (1 + 17%)

Where:

Q: tax-included price after discount

P: unit price not taxed per user or CPU)

N: Number of users or CPUProcessor;

D: discount % off). The initial discount is 30% off.

22%: one-year standard service fee, with 7% Product Support and 15% upgrade guarantee;

C: Media fee. Currently, the fee is RMB 600/set.

17%: VAT

16. What is the discount?

A: Oracle officially stipulates that the initial discount from Oracle database software to end users is 25% off. End users must be provided for special discounts. Please refer to the Oracle software order confirmation letter.

17. Can I provide a trial version? How long is the trial term?

A: After your subscription is made, you can provide A trial version for free trial and evaluation. The trial period is one month. If you do not place an order after the trial period, you must uninstall and delete the installed Oracle trial software from the system.

The above content is an introduction to the differences between Oracle versions. I hope you will get something better.