This edition supports for Windows platform, single user development and deployment only. In this edition, there are two categories. As mentioned above, they are,. This edition has all the facilities required for building a business critical application. SE1 delivers unprecedented ease of use, power, and performance for workgroup, department level, and Web applications from single server environments for small business to highly distributed branch environments.
This edition contains all the ORACLE database features and it can be further enhanced by purchasing more options and packs. The benefits of this edition are,. Function-based in indexes : - Function based indexing is only available in the Enterprise Edition and is not available in the Standard Edition until 9. Prior to 9. Flashback Data Archive - Starting with In addition, Oracle offers many extra-cost database features that you can buy independently from the edition.
These include:. Oracle10g has auditing to tell if you have been querying the Oracle10g Automated Session History views, an extra-cost option according to sources at Oracle. This matrix shows Enterprise Edition features that are not available in Standard Edition. This includes features for 10g, 11g and 12c. The detect? See the Oracle Script Collection for a copy of the features.
It is imperative that the Oracle professional understand the features and options within the bewildering array of Oracle software offerings. By choosing the correct options, Oracle pros can save their company thousands of dollars and ensure that they have the right software for their application. Some Oracle features are allowed without explicitly purchasing any extra-cost options.
For example, querying any AWR tables is allowed in EE but it triggers an internal Oracle system audit that may require you to purchase the extra-cost performance and diagnostic packs. For more details on the features of Oracle standard edition vs. Feel free to ask questions on our Oracle forum. Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise.
All legitimate Oracle experts publish their Oracle qualifications. Oracle technology is changing and we strive to update our BC Oracle support information. If you find an error or have a suggestion for improving our content, we would appreciate your feedback. Just e-mail: and include the URL for the page. All rights reserved by Burleson. List of features by release The allowed features within each release change, so please refer to these Oracle documents: - Oracle 12c matrix of features by edition - Oracle 11g product family - Oracle 10g product family and features by database edition Oracle Editions Oracle currently has three main "editions" of the Oracle database, each with different features and prices: Enterprise Edition EE - The flagship Oracle offering with a vast array of tools and features for the large corporation.
Standard edition also has RMAN. Oracle Enterprise Edition When choosing the appropriate Oracle edition for your shop you must recognize those database features that you really need. Transparent Application Failover TAF - Used to re-direct in-flight transactions to a failover database in the case of a server crash. This is available in Oracle SEO as of release Fast-start fault recovery - This is a method for quickly recover and synchronize the Oracle database in cases of hardware failure.
So, review the available documentation, weigh the actual need for the feature, and then decide if the feature is needed or if there is another available solution. Just like when shopping for a new car, a feature like heated seats may seem really important at the time so you spend extra for it. Then a short time later, you end up moving to Houston, and no one in Houston ever needed heated seats.
So, you wind up paying for a feature that at one time seemed really important, but ultimately was never used. As one could guess, Oracle would much rather you purchase EE, which is why they have lots of selling points to inspire you to go in that direction. Your email address will not be published. Submit Comment. At Risk for an Oracle Audit?
We Can Help. Licensing Costs While not the only factor in making a decision, the costs involved play a significant part in the final decision. Some quick math: EE: Two-socket server with 22 cores per socket and a 0. Only licensable on servers with up to two sockets SE was four sockets, SE1 was two sockets Restricted to 16 threads per database The database engine automatically enforces this Previous editions did not have this restriction Does not allow for the licensing of any options or management packs Options — extra cost features such as Partitioning, Compression, etc.
Management packs — extra cost features used for database management such as Diagnostics Pack These restrictions may seem extensive and very limiting, but in practice they are not so bad. RAC Bundle Warning, this is a bit of a tangent.
The two-socket restriction applies to the cluster and not the server Two single socket servers must be used The thread limitation applies to the cluster and not individual hosts When using the previous editions of SE, and versions Functionality In addition to the restrictions noted above, there are some minor functional differences between the editions. The first thing of note is that SE2 and EE share a code base, and the database functions as one would expect.
A significant number of the differences described in the manual stem from the fact that you cannot license extra cost options and packs for SE2. Odds are that the extra cost feature s are not going to be licensed anyway. In practice, these restrictions are usually not that difficult to work around.
In SE2, the parallel engine in not available. As such, there are several activities that cannot use a degree of parallelism greater than 1.
0コメント