The ODI is an extract, load and transform tool ELT that covers all kinds of data integration requirements by offering superior developer productivity and better user experience especially in business intelligence systems.
This ensures high quality of service by offering a high availability of data, protection and disaster recovery like surviving data corruptions among others, for the users especially for large enterprises. If you use Standard Edition or Standard Edition One on a 2 processor system you simply need 2 processor licenses.
Effective 1-Sept, when licensing Standard Edition DB programs, a processor is counted equivalent to a socket; however, in the case of multi-chip modules, each chip in the multi-chip module is counted as one occupied socket.
This is just an example. License requirements were updated in Dec Instead you must licence by the physical processor in the underlying hardware. Oracle's licensing policies last updated in May Pay per user, however user is defined as any end-node that receives data from or creates data for that Oracle DB including human users. The classic case would be a grocery store system that is taking data from refrigerator thermometers and point of sale systems; in one case a user is a thermometer and in another case the user is the check out clerk, or in the case of newer self-check out terminals it would be the customer; thus in this example one would explore processor based licensing.
You are required to adhere to the following Oracle user minimums :. Note: As can be deduced from the above, in the case of Standard Edition One and Standard Edition there doesn't appear to be anything that specifies whether the minimum of 5 is per customer, per server or per processor and if per processor, whether the core factor is considered despite the fact it isn't for Standard processor licensing.
Named User NU licensing limits the number of individuals authorized to use Oracle on any server. NU licensing is not available for new contracts anymore. Concurrent Device CD licenses were defined as the 'Maximum amount of input devices connecting to the designated system at any given point in time'.
There is a Network version of this license which has slightly different terms. This is a very old licensing metric and anyone using it on multi-core processors, or moving to such a license, should conduct a cost assessment. Includes a restricted use license for Oracle Partitioning. Oracle Data Masking and Subsetting Pack. Oracle Diagnostics Pack. Oracle Tuning Pack. Oracle Real Application Testing. Not available on Oracle Database Appliance. SQL Tuning Sets. Oracle Fleet Patching and Provisioning.
Oracle Connection Manager. Available via a custom install of the Oracle Database client, usually installed on a separate machine or compute instance. Client Side Query Cache. Database Smart Flash Cache. Not available on Exadata. Oracle Database In-Memory. Note: The licensing policy shown here applies to this feature starting with Oracle Database release 19c, version Database In-Memory Base Level.
The following restrictions apply:. Automatic Workload Management. Oracle Advanced Security. Oracle Database Vault. Oracle Label Security. Centrally Managed Users. Real Application Security. EE : This feature is available starting with Oracle Database release 19c, version You must be licensed for the Oracle Advanced Security option and apply Oracle patch Oracle Spatial and Graph.
Oracle Spatial and Graph no longer requires an extra cost license. See Oracle Database Insider blog post for more information. Partitioned spatial indexes. Oracle Partitioning.
Oracle Machine Learning formerly Advanced Analytics. Oracle Machine Learning no longer requires an extra cost license. Oracle Advanced Compression.
Prefix Compression also called Key Compression. Basic Table Compression. Bitmapped index, bitmapped join index, and bitmap plan conversions. Parallel capture and apply via XStream.
Transportable tablespaces, including cross-platform and full transportable export and import. Summary management—Materialized View Query Rewrite.
Table lists Oracle Database options, the Oracle Database offerings for which each option is available, and the features that are included with each option. You must be licensed for an option in order to use any of its features.
Fast Incremental Backup on Physical Standby. Oracle Active Data Guard must be licensed on any standby databases with any of the above features in use, as well as the primary database. If there are additional standby databases in the Oracle Data Guard configuration that are not using any of the Oracle Active Data Guard features, those standby databases do not require an Oracle Active Data Guard license.
Oracle Active Data Guard must still be licensed on standby databases, if any other of the above features are in use. An Oracle Active Data Guard license is only required if any of the pluggable databases in the standby is opened for read. Exadata Flash Cache Compression This feature can be enabled only on Exadata storage servers, and all database processors that access the Exadata storage servers must be licensed for Oracle Advanced Compression.
Oracle Advanced Security includes a restricted use license for certain Oracle Enterprise Manager features. Oracle Database Vault includes a restricted use license for certain Oracle Enterprise Manager features.
An Oracle Label Security license is not required when Oracle Label Security is merely installed or enabled in any container. Oracle Label Security includes a restricted use license for certain Oracle Enterprise Manager features. Oracle Multitenant. For EE and PE , the ability to have up to pluggable databases per multitenant container database.
Oracle Real Application Testing includes the following features:. The Oracle Real Application Testing license is required on both capture and replay systems for Database Replay and is charged by the total number of CPUs on those systems. Database Migration Planner, introduced in Oracle Enterprise Manager Cloud Control 13c, provides a data-driven and systematic approach to consolidation by eliminating guess work and human errors. On the database target home page, select the Administration menu, then select Database Migration Planner.
All features, functions, links, buttons, and drill-downs on this page are licensed as part of the Database Migration Planner. Database Migration Workbench, introduced in Oracle Enterprise Manager Cloud Control 13c Release 4, is a single workbench that integrates all needs for migration sizing and performance comparison.
All features, functions, links, buttons, and drill-downs on this page are licensed as part of the Database Migration Workbench. Table lists Oracle management packs, the Oracle Database offerings for which each pack is available, and the features that are included with each pack. You must be licensed for a management pack in order to use any of its features. Database-as-a-Service comprising self-service database provisioning on physical or virtual infrastructure. Support shared server, shared cluster, and shared database Schema-as-a-Service deployment models.
Virtual assembly provisioning. For example, if there is an assembly topology of three VMs two WebLogic Server-managed servers and one database , you will need both packs to cover the respective tiers. Metering and chargeback based on fixed cost, utilization metrics and configuration parameters of the database.
Starting on the Enterprise Summary home page, click the Enterprise menu. Cloud , then Infrastructure Home. Cloud , then Infrastructure Request Dashboard. Cloud , then Infrastructure Policies.
Cloud , then Middleware and Database Home. Cloud , then Middleware and Database Request Dashboard. Cloud , then Self Service Portal. Cloud , then Service Instances. Provisioning and Patching , then Database Provisioning. Starting on the Enterprise Summary home page, click the Setup menu.
Provisioning and Patching , then Storage Registration. On the Multitenant container database's home page, from the Oracle Database menu, select Provisioning , then Provision Pluggable Database. These verbs operate on a database pool. The following objects within the repository schema are licensed under Oracle Cloud Management Pack for Oracle Database:.
Also, any report created using the "create-like" feature of BI publisher referring the preceding reports, falls under this license. If you want to use the Oracle Database Gateways listed above not solely for the purposes of Oracle Data Masking and Subsetting Pack, then you must purchase full-use licenses for the Oracle Database Gateways. Oracle Data Masking and Subsetting functionality cannot be executed directly against the non-Oracle database. Also see my notes on Oracle standby database enterprise and standard edition.
Overview of Oracle Store License rules. As of August , Oracle has two pricing models, "named user plus" and "processor". Historically, Oracle has also sold "unlimited use" licenses for large corporations, but they are not mentioned on the Oracle Store web site. Many Oracle shops are now using Oracle replication tools Oracle Streams, standby database, data guard, multi-master replication to create a standby Oracle server as protection against hardware failure.
However, many Oracle shops forget that all? This Oracle license pricing document as of March 16, , notes that mall standby and failover database must be fully licensed if they might be used as production:. These systems are configured for disaster recovery purposes. If the primary database fails, the standby database is activated to act as the new primary database. In this environment, both the primary and the standby databases must be fully licensed.
Oracle standby servers need to be fully licensed if they are? Some sources say that cold standby servers used less than 10 days per year do not need to be licensed, but you should verify this with your Oracle representative or the Oracle Store, as Oracle license policies change frequently.
Suggestions for getting the best deal on Oracle licenses. Even though Oracle licensing agreements allow Oracle corporation to perform license audits, most Oracle shops are honor-bound to pay for the databases according to their license agreement.
Don't pay for more Oracle licenses than you need. There's an interesting February article over on the IT Manager's Journal about Oracle licensing and support, suggesting that many shops are paying for more licenses than they use. There is also this article titled " Oracle is Putting the Support Screws to Customers " with similar recommendations.
Plan your Oracle architecture to minimize Oracle license charges. With proper planning you can save a great deal in license fees while keeping high database performance.
Some suggestions for processor-based licensing include:. Let's examine the Oracle licensing literature on processor-based Oracle licensing for multi-core processors.. A dual core chip is a processor that contains more than one processing unit. Both AMD's Athlon 64 X2 and Intel's Pentium D use "dual-core" designs that put two processors on a single piece of silicon, divvying up the work between the pair. Following months of anticipation and some high-profile criticism, Oracle has changed the licensing model for its databases and middleware on multicore servers, bringing it a step closer in line with competitors.
The price change only effects the "multi core" processors, and the article discusses the formulas used: Multicore processors pack more than one processing unit, or core, on a piece of silicon. The technique boosts performance of a machine, while keeping the heat generation down, although two cores do not double the performance.
We also see that this July 15, article shows examples of the computations required to determine license fees:. And it gets even more complicated! A sharp Register reader forwards this advisory from Oracle's finer print:. Oracle Store also shows details on counting multi-core processors.
0コメント