A single socket with four cores costs the same as a single socket with 22 cores. Be aware however, that purchasing Oracle software is a lot like buying a new car, no one ever pays list price.
Discounts are customary, but are also dependent on a long list of factors that no one will give us the formula for, if one even exists. Some quick math:.
With this method, the processor-based licensing noted above is still calculated, then per processor minimums are applied. The number of users also need to be counted.
Using the same two socket server as noted above, the per processor minimums would be:. The breakeven point for EE is 50 users per processor. Whereas, the breakeven point for SE2, assuming a 2-socket server, is users per server.
For organizations running at, or even near, these user counts using the processor metric may be preferred. In a virtualized environment, using SE2 can be of great benefit. Once the physical server is licensed, one can then place as many VMs on the server as the server is capable of running. While the same goes for EE, the costs of licensing the server itself are considerably higher. Once final cost consideration is Oracle support, the gift that just keeps on giving charging. Support costs are based on the purchase price of the software itself.
Just like with taxes, the more you spend on the purchase, the more you spend annually on support. As with all SE products, there are a handful of restrictions that keep people from easily using SE2.
Note: This article was first written in and things change, so please re-verify this information. Reader comment on Oracle Streams: "I have found contradictory information about Oracle Streams… appears to be available with 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. This license would then be application specific and cannot be used for anything else, should be renewed with application vendor. An end-user may not even be aware that the software package contains Oracle technology and should not be able to access it directly as a developer or system administrator. An example of this licensing model in use may be a Point of Sale system that requires a database to log transactions.
Note that the standard Oracle License and Services Agreement only allows use of Oracle software for internal business operations. Other uses, such as a hosting service or an ASP, will require an agreement that extends the usage rights to cover such scenarios. Oracle have a validation program which provides assurance that their LMS License Management Services team will accept data from certain third party vendor as being suitable for license review purposes.
Situations may arise where options in the Oracle technology or applications stack are being used that were not paid for, or where use may be extending beyond the scope of the contractual terms.
Most of these cases occur due to lack of knowledge of the Oracle licensing scheme and a failure of managers to regularly audit license usage. Typically, when your Oracle rep. It is highly advisable to conduct a yearly audit of servers with a partner that understands Oracle licensing.
This section lists some scripts that can be executed to see some of the components that should be licensed:. Please note that the information provided by this command is not trustworthy on multi-threaded, multi-core or virtual systems. It is the number of processors understood to be available by the database - not the number of processors which must be licensed.
Please note - on Enterprise Edition, Partitioning will almost always be installed. It is used by Oracle database itself - this command in isolation will not provide information on license requirement. Organizations using Enterprise edition have an Enterprise license for all features listed in the table above as Extra license costs, but are required to pay extra fees.
Thank you for all this valuable information. Oracle Database Editions If you want to learn the history and features of Oracle Database, you can read the following article. These versions and details are as follows. Enterprise Edition: It is the most expensive version of Oracle database, which includes all components and options.
This version is generally preferred by organizations that need business critical, high performance and extra security.
0コメント