Licensing question (core vs CPU vs socket). Oracle licensing being a tedious subject in. The other thing is that only physical cores count.

Application and database gives tremendous opportunities for IT organizations to have better scalability and security, as well as valuable cost benefits. On January 23, 2017, Oracle updated the “Licensing Oracle Software in the Cloud Computing Environment” document to add clarity on licensing Oracle products in the public cloud, especially Amazon Web Services (AWS) and Microsoft Azure. If you are a customer on AWS or Azure running Oracle products, or if you are planning to move your Oracle workload to the cloud, the announcement has a huge impact on the license costs. Most on-premises databases run on Intel Xeon, Intel Itanium, AMD Opteron or Sun SPARC CPUs.

Marketing Research Naresh K Malhotra Ebookers more. All of these processors enjoy a “processor core factor table” benefit of 0.5 when calculating Oracle licenses. Oracle’s latest announcement targets and negatively affects the licenses for Oracle databases and other Oracle products on AWS and Azure – your on-premises license availability is reduced in half when you move to Azure or AWS. The new policy says: “When counting Oracle Processor license requirements in Authorized Cloud Environments, the Oracle Processor Core Factor Table is not applicable.” Oracle’s hope may be that this change and make the Oracle cloud offering more attractive to customers. On AWS, by default hyperthreading is enabled, though no hyperthreading is enabled on Azure. The “Licensing Oracle Software in the Cloud Computing Environment” document spells out hyperthreading on Amazon and considers two vCPU on AWS equivalent to one processor license when hyperthreading is enabled (on AWS a vCPU is an Intel thread, so 2 vCPU make a core).

For non-hyperthread AWS and Azure, one vCPU is equivalent to one processor license. The following table will help to visualize the license difference between various cloud providers (IaaS offering, bring your own Oracle license model) on how an “Intel Xeon 8 Cores” is licensed by Oracle. If you are planning to run Standard Edition on AWS or Azure, please note: “Under this cloud computing policy, Oracle Database Standard Edition may only be licensed on Authorized Cloud Environment instances up to 16 Amazon vCPUs or eight Azure CPU Cores. Oracle Standard Edition One and Standard Edition 2 may only be licensed on Authorized Cloud Environment instances up to eight Amazon vCPUs or four Azure CPU Cores.”.

Our Windows Servers have 4 CPU’s. Our licenses are based on no of cpu’s. Our cpu utilization typically is 10%. Is it possible to change cpu_count parameter e.g. 1 to Oracle will only use 1 cpu.

I changed this parameter and did find that parameter remains in fact to 1. Now question is whether Oracle will agree to this technique. I know For Oracle free ware, is Oracle Database Express Edition, Oracle license is limited to 1 CPU and 4GB. How does Oracle forces that, i.e., is it something in buitlt in Oracle that Oracle software will not use more than 1 CPU. Hpuxrac 16:46. It is not only the cpu count but also the core count and the relevant oracle multi core cpu licensing factor that counts. For example a quad core intel or amd cpu counts as 2 ( 4 times.5 ) while a dual core cores as 1 cpu for licensing purpose varies based on hardware platform etc.

To get below a count of 4 on windows I think you have to have a machine that has less than 4 cpu's ( pull some of them out in other words or use a different box ). Certain platforms and os combinations ( solaris for example ) allow you to partition the machine but it has to be a hard partition and not sure windows has any such 'oracle validated' type of configs.

Look at the oracle licensing and multi core documents. Zigz.@yahoo.com 18:15. >>Puget Sound Oracle Users Groupwww.psoug.org-Hide quoted text - >>>- Show quoted text - >>Thanks, when I ran this report, I got: >CPU Core CPU Socket >Timestamp CPU Count Count Count >----------------- ---------- ---------- ---------- >11/03/07 00:01 4 N/A 4 >04/20/08 22:01 2 N/A 4 >>------------------------------------------------------------- >>Do n't what to make of this output. If you have one of the standard editions, the number of sockets becomes important. SE1 can't be licensed for you.

I believe CPU_COUNT is used for some internal tuning purposes. Note the caution about it in the docs. Note also Oracle can do a license audit, and some Oracle salespeople will threaten you with it if you even ask about this stuff. I for one do not take such threats well. Jg -- @ is bogus.

'The doors in the third car did not open to let people out at the station.' - heard over public address system as Amtrak train pulls out of station. It didn't stop.