By Franck Pachot
Since X4 we can do Capacity on Demand on Exadata: disable some CPU cores to lower cost of Oracle Database licenses. Depending on the models, and the configuration, there are different minimums and here is a recap table about those.
Here is the summary of Capacity on Demand minimum, maximum and increment. Those numbers come from the configuration file of OEDA, the Oracle Exadata Deployment Assistant (es.properties) and you can see that it already has an option for Exadata X7-2
|Exadata model||sockets||cores per socket||cores per server||thread per core||Capacity on Demand minimum||Cod maximum||CoD increment|
(not for 1/8th)
(8 for 1/8th)
(8 for 1/8th)
(8 for 1/8th)
Special minimums for 1/8th of Rack
The smallest configuration (1/8th of Rack) is a bit special. First, because it is physically identical to the 1/4th one with just some processors and disks disabled. But also, for this entry-level, the minimum required is lower – 8 cores per node – in X6.
Here is the Oracle Exadata Deployment Assistant for X6-2 1/8th of Rack:
When having selected 1/8th of Rack we are allowed to enable a minimum of 8 cores per nodes, as mentioned in the table above:
Elastic Rack configuration allows to configure any combination of database nodes and storage cells:
With Elastic Rack configuration, the next screen is not only displaying the configuration, but you can customize it.
Here I define the same configuration as an 8th of RAC:
However, because it is not an 1/8th Rack configuration, the minimum is 14 cores per node and not 8:
So be careful. Elastic configuration gives more flexibility, but CoD minimums are is different than the equivalent configuration.
As I’m talking about elastic configuration here is how the cores are enabled. The configuration assistant calls /opt/oracle.SupportTools/resourcecontrol which displays or updates the BIOS configuration. You may wonder why you can do that here and not in your own servers? Because here Oracle can trace what happened. You will find the log in /var/log/oracleexa/systemconfig.log and here is an example where the Elastic Rack has been deployed with 16 cores per database node Capacity on Demand:
Fri Aug 04 16:12:18 CEST 2017 Executing command: /opt/oracle.SupportTools/resourcecontrol -show [INFO] Validated hardware and OS. Proceed. [SHOW] Number of physical cores active per socket: 22 [SHOW] Total number of cores active: 44 Mon Aug 07 11:24:31 CEST 2017 Executing command: /opt/oracle.SupportTools/resourcecontrol -core 16 -force [INFO] Validated hardware and OS. Proceed. [INFO] Enabling 8 cores on each socket. [INFO] Import all bios settings [INFO] All bios settings have been imported with success [ACTION] Reboot server for settings to take effect [SHOW] Number of physical cores active per socket: 8 [SHOW] Total number of cores active: 16 Mon Aug 07 11:31:24 CEST 2017 Executing command: /opt/oracle.SupportTools/resourcecontrol -show [INFO] Validated hardware and OS. Proceed. [SHOW] Number of physical cores active per socket: 8 [SHOW] Total number of cores active: 16
This does not stay on your server. There is a rule that you can do Capacity on Demand only if you have configured Platinum support, or use Oracle Configuration Manager, or Enterprise Manager. All those may store history of the CPU count, which means that it is auditable.