Oracle version differences and version selection!

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)

 

. 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-Oracle Product Lifecycle Management System (Product Lifecycle Management)

 

. 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 (only some common or common features are selected). Note that, in addition to RAC, these features are still included in the Personal Edition.

 

1. Oracle Data guard, not supported. (Users who want high availability cannot select the standard version)

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

3. backup and recovery operations are limited. For example, block-level media recovery are not supported, and parallel backup and recovery are not supported ), multiple backups (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. VPD (Virtual Private Database) does not support

6. FGA (fine-grained auditing) does not support

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. (Standard Edition cannot be selected for a data warehouse system)

10. export transportable tablespace (Note: 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 (other third-party cluster software is not supported ), at the same time, ASM must be used for data file storage and management (not supported by any other third-party volume management and file system ).

 

 

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 (one) is applicable to servers with 1 to 2 CPUs. The price is advantageous, but only for single-host environments. It is applicable to 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 backup 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 single-host, dual-host, multi-CPU, multi-node clusters, and other environments. It has complete functions, but the cost is 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 predicted, the subscription should be made based on the CPU (processor.

 

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 acts as the website background database, according to Oracle's official definition of the number of users, each website (database) accessed through the Internet) is counted as one user, so the number of users is large and unpredictable, 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 small (less 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: see the 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 without tax (per user or per CPU)

N: Number of users or CPU (processor;

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.