9.7.1.2.2 Power Management Attributes
In conjunction with Exadata X11M system hardware, Oracle Exadata System Software release 25.1.0 introduces advanced power management capabilities that enable users to reduce power consumption on Exadata database servers.
Power Consumption Target
-
The
cpuTargetWattsMaxValue
attribute defines the server's expected maximum power consumption (in Watts).For example, on each 2-socket Oracle Exadata X11M database server with 192 CPU cores,
cpuTargetWattsMaxValue=800
. And, on a single-socket Oracle Exadata X11M-Z database server with 32 CPU cores,cpuTargetWattsMaxValue=240
.You can view the prescribed value for each server by listing the attribute value. For example:
DBMCLI> LIST DBSERVER attributes cpuTargetWattsMaxValue
-
The
cpuTargetWatts
attribute controls the power consumption target for the server.By default, the power consumption target is disabled and the
cpuTargetWatts
attribute contains no value.You can specify the power consumption target by setting the attribute value. For example:
DBMCLI> ALTER DBSERVER cpuTargetWatts=720
When setting the
cpuTargetWatts
attribute, permitted values are between 50% and 100% of the servercpuTargetWattsMaxValue
value in increments of 20 Watts for each server CPU socket.For example, on a 2-socket X11M database server with 192 CPU cores, where
cpuTargetWattsMaxValue=800
, you can set thecpuTargetWatts
attribute to400
,440
,480
, and so on up to800
. And, on a single-socket X11M-Z database server with 32 CPU cores, where thecpuTargetWattsMaxValue=240
, you can set thecpuTargetWatts
attribute to120
,140
,160
, and so on up to240
.You can also disable the power consumption target by resetting the
cpuTargetWatts
attribute toNULL
or to an empty string (""
).At any time, you can view the current power consumption target by listing the attribute value. For example:
DBMCLI> LIST DBSERVER attributes cpuTargetWatts
Low Power Mode
-
The
lowPowerModeSchedule
attribute specifies a low power mode schedule on the server. You can setlowPowerModeSchedule
as follows:lowPowerModeSchedule[+|-]=((startTimestamp="start-timestamp",durationMinutes=duration-in-minutes,frequency={daily|weekly}) [,(startTimestamp="start-timestamp",durationMinutes=duration-in-minutes,frequency={daily|weekly})]...)
In the
lowPowerModeSchedule
definition:-
startTimestamp
: Specifies the start date and time for the low power mode period. The value must be specified as an ISO 8601 formatted timestamp. For example,"2025-01-03T18:00:00-07:00"
. -
durationMinutes
: Specifies the duration (in minutes) of the low power mode period. The maximum permitted value is1440
. -
frequency
: Specifies the frequency of the low power mode period. The permitted values aredaily
orweekly
.
You can use the
+=
operator to add entries to an existinglowPowerModeSchedule
definition, or use the-=
operator to remove specific entries from an existinglowPowerModeSchedule
definition. The=
operator overwrites the previous attribute value.To remove all entries in the low power mode schedule, specify
lowPowerModeSchedule=NULL
. -
-
The
lowPowerModeUntil
attribute regulates the low power mode. The following values are permitted:lowPowerModeUntil="end-timestamp"
: Manually switches on the low power mode until the specified time. The value must be specified as an ISO 8601 formatted timestamp. For example,"2025-01-10T23:30:00-07:00"
.-
lowPowerModeUntil=""
orlowPowerModeUntil=NULL
: Immediately switches off the low power mode by setting. You can use this setting to switch off a scheduled low power mode period or a manually started period. -
lowPowerModeUntil=NEVER
: Immediately switches off the low power mode and disables the low power mode schedule.To re-enable the low power mode schedule, set the
lowPowerModeUntil
attribute to any value other thanNEVER
.
During any low power mode period, the system continually monitors itself to protect system performance. When any active workload is detected for five minutes, low power mode is automatically switched off. An active workload is characterized by any of the following:
-
CPU utilization exceeds 30%.
-
I/O utilization exceeds 30%.
-
Throughput on the client network or RDMA Network Fabric exceeds 200 MB/sec.
When low power mode is automatically switched off because of an active workload, it remains off until the next scheduled period or until you manually switch it on.
Parent topic: ALTER DBSERVER