Oracle Standard Edition, Enterprise Edition difference

One, Oracle 9i Standard Edition, Enterprise Edition

oracle 9i Standard Edition /td>	oracle 9i Enterprise
? Jserver Enterprise Edition ? Intermedia ? Enterprise Manager ? Workflow Standard Edition ? Standard Management Pack ? Object Option ? Networking Kit? Object for OLE ? Distributed option ? bit option ? ODBC Driver ? Sql*plus ? OCI	? Jserver Enterprise Edition ? Intermedia ? Object Option ? Networking Kit ? Object for OLE ? Advance Replication Option ? Distributed Option ? Parallel Query Option ? Sql*plus ? VIR ? Workflow Enterprise Edition ? Advanced Backup & Recovery ? Connection Pool ? bit Option ? ODBC Driver ? OCI ? Enterprise Manager ? Enterprise Backup Utility

Ii. Oracle 10g Standard Edition, Enterprise Edition

The oracle10g is divided into 4 versions, namely:
1. Oracle database Standard Edition One, the most basic commercial version, including basic data base functionality.
2. Oracle Database Standard Edition, which includes the features and RAC of the above version, only starts with RAC in the standard version of 10g.
3. Oracle Database Enterprise Edition, Corporate Edition, although the most powerful version, but not all of the features we commonly use in this version, a lot of things still have to pay extra, it will be said later.
4. Oracle Database Personal Edition, the Personal Edition, contains all the features of the Enterprise Edition except that it does not support RAC, but it is important to note that the personal version is only available on the Windows platform.

Here's a look at features that are not supported in Standardedition one and Standard Edition (just select some of the more common or common features), and note that these features are still included in the personal version, except for RAC.

1. Oracle Data Guard, not supported. (for customers who want high availability, you cannot select the Standard Edition)
2. Some online operations, such as online index maintenance,onlinetable redefinition, do not support
3. Some operations for backup and recovery are limited, such as not supporting Block-level recovery (block-level Media recovery), parallel backup and recovery (parallelbackup and recovery), multiple backups (duplexed Backup sets) and so on
4. Flashback function, Flashback table,flashback Database in the Standard Edition, flashbacktransaction query is not supported by
5. VPD (Virtual Private Database) does not support
6. FGA (fine-grained auditing) does not support
7. Partitioning, the partition also does not support
8. Data compression, such as table compression, do not support
9 for partition compression. bitmapped index and bitmapped join index, not supported, (if the Data Warehouse system cannot select the Standard Edition)
10. Export Transportable tablespace, (note that this is only import not supported), but import transportable tablespace, including cross-platform import is supported, that is, if you choose the standard version, It's hard to simply transfer the database to other platforms,
11. Some parallel operations are not supported, including Parallel query,parallel dml,parallel index build,paralleldata Pump Export and import.
12. Streams is not supported, and a high availability feasibility scenario is missing
13. The multimaster mode of the advanced replication is not supported, and one less high-availability scenario, but the replication scheme of the manifested view is still supported by
14. Connection Manager is not supported.

The Oracle 10g Standard Edition supports RAC, but Oracle is limited, and if you want to use RAC in Oracle 10g Standard Edition, you can use only Oracle Clusterware (no other third-party cluster software is supported). You must also use ASM for storage management of data files (no other third-party volume management and file systems are supported).
If you are installing another database as an Rman repository or an OEM Grid Control repository then you do not need to pay any additional fees.
In addition, if you purchase the lowest level of the Oracle 10gStandard one version, then the following features are not supported.
1. Rac
2. Partitioning
3. Data Mining
4. Advanced Security
5. Label Security
6. Olap
7. Spatial
8. Oracle Management Packs

III. FAQ for Oracle Products
1. What is the version number of Oracle database software currently on sale?
A: Currently on sale is Oracle 9i/oracle 10g/oracle 11g (New ...)
2. Is Oracle 10g better than Oracle 9i?
A: After the launch of a new version of the software, there will always be a period of testing, during which a considerable number of patches. But new versions of the software tend to have more new features and a more user-friendly interface. 9i and 10g as the current sale of two versions, strengths. In comparison, Oracle 9i is more robust and Oracle 10g offers more new features. We recommend that users choose according to their business needs, the most appropriate is the best. (Because this FAQ is the year before, it is now recommended to select the version of Oracle 10GR2)
3. How many versions of Oracle database software are available?
A:oracle database software is divided into personal version, Standard Edition 1, Standard Edition, Enterprise Edition.
4. Can you tell me the characteristics and differences between Personal Edition, Standard Edition 1, Standard Edition and Enterprise Edition?
A: Standard Edition 1 (Edition one) for 1-2CPU servers, the price has a considerable advantage, but only a single machine environment, suitable for small and medium-sized users entry-level applications;
Standard Edition for 1-4CPU servers, including 4CPU single server or 2 dual CPU servers and other configurations, can be dual-machine hot standby or RAC, affordable, suitable for the database performance and security requirements for large and medium-sized user workgroup and departmental applications ；
Enterprise Edition (Oracle Enterprise Edition) for single, dual-machine, multi-CPU multi-node cluster and other environments, full-featured, but the cost is relatively high, suitable for database performance and reliability of the large, ultra-large users of enterprise-class, high-end enterprise-class applications.
Refer to the Oracle Database whitepaper for comparison on the function modules.
5. Is the enterprise version must be better than the standard version?
A: The Enterprise Edition is fully functional, providing higher reliability and performance, but it also means more software costs and hardware overhead. It is recommended that the user determine the version according to the actual needs, the most suitable is the best.
6. How is Oracle ordered?
A: There are two ways to order according to the number of users and by CPU, which is ordered by the CPU is called unlimited user version.
7. What is the official definition of Oracle user?
A: Every user who accesses an Oracle database, whether natural or device, counts as a user (Named user).
Official English definition: Named User Plus:is defined as an individual authorizedby your to use the programs which is installed on a single s Erver or multipleservers, regardless of whether the individual is actively using the programs atany given time. A non human operated device would be counted.
8. What is the number of Oracle users?
A:oracle the minimum number of users for each version of the official requirements is:
Personal version: 1user*pc number
Standard Edition 1= server CPU count
Standard Edition = number of CPUs on the server *10user
Enterprise Edition = Server CPU number *25user;
Users should order according to their actual number of users, and not less than the minimum number of users required by the corresponding version.
9. Under what circumstances should the CPU be ordered?
A: If you have a large number of users accessing Oracle, or if you cannot estimate the number of users, you should order it according to the CPU (Processor).
What is the official definition of processor?
A: equals the total number of CPUs for the server on which the Oracle database software is installed.
Official English definition: Processor:shall be defined as all processors where theoracle programs is installed and/or running. Programs licensed on a processorbasis is accessed by your internal users (including agents and contractors) and by your Third party users.
11. Please give an example?
A: For example, if the user's application is based on Internet,oracle as the site background database, according to Oracle's official definition of the number of users, each Internet access to the site (database) is counted as 1 users, so many users, and can not be estimated, So it should be ordered according to the number of CPUs.
12. Is the cost per CPU high?
A: In general, the cost of 1CPU is approximately equal to the cost of 50user, so if the number of users >cpu number of *50, then the CPU ordered by the more economical
13. Is the Internet or b/s architecture application required to be ordered by CPU?
A: Not necessarily, if the number of users accessing the Oracle database can be estimated, and the number of users is not many (less than the number of server CPUs *50), can also be ordered by the number of users.
What is the public quote (List price) for Oracle database software?
A: Please refer to the List Price table.
How is the price of Oracle database software calculated?
A: Calculation formula: q= (p*n* (1-d) * (1+22%) +415) * (1+17%)
which
Q: Tax-included price after discount
P: Non-taxable unit price (per user or per CPU)
N: Number of users or CPU (Processor);
D: Discount (%off), starting discount is 30%off.
22%: One-year standard service fee, including product support 7%, upgrade protection 15%;
C: Media fee, currently RMB 600/set.
17%: VAT
16. What is the discount?
A:oracle officially stipulates that the starting discount for Oracle database software to end users is 25%off, and the request for a special discount must provide end-user information, please refer to the Oracle Software Order confirmation letter.
17. Is it possible to provide a trial version? How long is the trial period?
A: After the purchase intention is reached, a trial version can be provided for free trial and evaluation, with a trial period of one months. If not ordered after the trial period, the user must uninstall and remove the installed Oracle trial software from the system.