Monday, December 1, 2014

How to know Electric Power Consumption for Exadata ?

There are 3 ways to know about electric power consumption:

1. ILOM Web.

Login to ilom of your server and click to "Power Management" at left side down.

  Power Management > Consumption - current value                           
  Power Management > Statistics  - 15-, 30-, and 60-second intervals       
  Power Management > History - historical value for the last hour or 14 days.














2. ILOM Cli

show /SP/powermgmt actual_power
show /SP/powermgmt permitted_power

-> show /SP/powermgmt actual_power

  /SP/powermgmt
    Properties:
        actual_power = 424


-> show /SP/powermgmt permitted_power

  /SP/powermgmt
    Properties:
        permitted_power = 740


3. ipmitool

[root@ed02dbadm02 pwrstat]# ipmitool sensor|grep Watts
VPS_CPUS     | 70.000   | Watts    | ok   | na    | na    | na      | na     | na      | na
VPS_MEMORY   | 22.000   | Watts    | ok   | na    | na    | na      | na     | na      | na
VPS_FANS     | 10.000   | Watts    | ok   | na    | na    | na      | na     | na      | na
PS0/P_IN     | 0.000    | Watts    | ok   | na    | na    | na      | na     | na      | na
PS0/P_OUT    | 0.000    | Watts    | ok   | na    | na    | na      | na     | na      | na
PS1/P_IN     | 240.000  | Watts    | ok   | na    | na    | na      | na     | na      | na
PS1/P_OUT    | 230.000  | Watts    | ok   | na    | na    | na      | na     | na      | na
/SYS/VPS     | 240.000  | Watts    | ok   | na    | na    | na      |740.000 | na      | na

[root@ed02dbadm02 pwrstat]# ipmitool sensor get /SYS/VPS


Locating sensor record...
Sensor ID              : /SYS/VPS (0x63)
 Entity ID             : 23.0
 Sensor Type (Analog)  : Power Unit
 Sensor Reading        : 240 (+/- 0) Watts
 Status                : ok
 Lower Non-Recoverable : na
 Lower Critical        : na
 Lower Non-Critical    : na
 Upper Non-Critical    : 740.000
 Upper Critical        : na
 Upper Non-Recoverable : na
 Assertions Enabled    : unc+
 Deassertions Enabled  : unc-


[root@ed02dbadm01 pwrstat]# dcli -g all_group -l root ipmitool sensor get
/SYS/VPS |grep Watts
ed02dbadm01: Sensor Reading        : 240 (+/- 0) Watts
ed02dbadm02: Sensor Reading        : 250 (+/- 0) Watts
ed02celadm01: Sensor Reading        : 320 (+/- 0) Watts
ed02celadm02: Sensor Reading        : 330 (+/- 0) Watts
ed02celadm03: Sensor Reading        : 330 (+/- 0) Watts


No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Does DEALLOCATE UNUSED or SHRINK SPACE will free space occupied by LOB segment?

Lets check how it works. My env is DB 19.20@Linux-x64 1) I created the table with 4 LOB columns of 4 different LOB types: BASICFILE BLOB, BA...