How to choose the FAQ in Oracle?

The following articles mainly introduce some FAQs about Oracle products. In practical applications, we may choose Oracle product FAQs? There will be a lot of things you don't understand, for example, 10 Gb is better than 9i? What types of Oracle Database software are available?

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?

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

4. Can you tell me the features and differences of the Personal Edition, Standard Edition 1, Standard Edition, and Enterprise Edition FAQ of Oracle products?

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 version based on your actual needs. The most suitable version 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 version.

The above content is an introduction to some FAQs about Oracle products. I hope you will gain some benefits.