CellMetric Tool

Hey guys, it’s been a while since my last post as I’ve been quite busy on the last months at a personal project which could be used to collect some current metrics from a Exadata Storage Server. I got a beta version now, so it’s stills under development but I hope you enjoy this tool. It’s a Java App which was built and tested under ESS image version 12.1.2.1.1.150316.2 and Java version 1.7.0_72 . Java 7.0 is deployed under ESS image version 12.1.2.1.1

Well what this app call CellMetric does is quite simple, it executes CellCLI throw SSH – so Node Equivalency to cellmonitor uses needs to be set correctly -, list the current metrics from the cell that you provided using saving this output to a XML file and then print the results on the screen. That easy. The only attention is that the Database I/O Load Metric information is top ordered listing only the hugest 15 databases. The way how you execute it is java CellMetric -top -cell <cellHostName> . Below you can see an image from the execution time:

CellMetric Image

So just download this CellMetric_v1.2.zip place both file on your Exadata Database Machine and then enjoy it. Cya!!

12 thoughts on “CellMetric Tool

  1. Hi Carlos
    Thanks a lot !!
    I get following messge on a fresh X5-2 release cell-12.1.2.2.0_LINUX.X64_150917-1.x86_64
    Same message if running it under root account

    [celladmin@e21sdm02celadm01 tmp]$ java CellMetric -top -cell e21sdm02celadm01
    Executing CellCLI, please wait for about 15 seconds…
    cellmonitor@e21sdm02celadm01’s password:
    —————————————————————————————–
    | Cell Name: e21sdm02celadm01 | Time: 2015-12-08 17:27:33+0100 |
    ——————————————————————————————————————————————
    | CPU Used (%): 1.61 | Memory Total (%): 30 | Virtual Memory CS (MB): 120,151.06 | Temperature (C): 21 |
    | CPU Used CS (%): 0.56 | Memory CS (%): 14.72 | Virtual Memory MS (MB): 539.82 | Disk Contr. (C): 28 |
    | CPU Used MS (%): 0.02 | Memory MS (%): 0.56 | IORM Mode: Balanced | Swap Used (%): 0 |
    ——————————————————————————————————————————————
    | IB Port Received (%): 0.02 HCA-1:1 | IB Port Received (MB/s): 0.52 HCA-1:1 | Smart Flash Logging Errors (Disk): 0 |
    | 0.01 HCA-1:2 | 0.27 HCA-1:2 | Smart Flash Logging Errors (Flash): 0 |
    | IB Port Transfe. (%): 0.01 HCA-1:1 | IB Port Transfe. (MB/s): 0.23 HCA-1:1 | Smart Flash Logging (%): 100 |
    | 0.02 HCA-1:2 | 0.7 HCA-1:2 | Smart Flash Logging Last Hour (%): 100 |
    ——————————————————————————————————————————————
    | Cell Disk I/O Load | Used | LG Used | SM Used | SM Read | LG Read | SM Write | LG Write | Errors | Flash Cache |
    | Metric | (%) | (%) | (%) | (MB/s) | (MB/s) | (MB/s) | (MB/s) | | Metric |
    | Exception in thread “main” java.lang.NullPointerException
    at CellMetric.printScreenOutput(CellMetric.java:352)
    at CellMetric.fLoadXML(CellMetric.java:276)
    at CellMetric.fTop(CellMetric.java:143)
    at CellMetric.fTopOption(CellMetric.java:122)
    at CellMetric.main(CellMetric.java:32)

    Any idea ?
    Christophe

    • Hi Christophe, are you running an Extreme Flash configuration? How many Storage Nodes? This error message from Java means that there was null information when it should bring info, anyway, can you post your java version, I used it on a X5-2 with imageversion 12.1.2.1.1

      Thanks.

  2. NO just a eighth rack with HC disks 4TB and 3 cells on latest Exadata 12.1.2 (Nov 2015)
    [celladmin@dm02celadm01 tmp]$ java -version
    java version “1.7.0_85”
    Java(TM) SE Runtime Environment (build 1.7.0_85-b15)
    Java HotSpot(TM) 64-Bit Server VM (build 24.85-b06, mixed mode)

    • Christophe, I’ve noticed that you are executing from the Cell Node, is that correct? If it is, than go ahead and execute throw the Database Node, as I did. The app was built in order to be executed from the DB Node. Please let me know if it is working.

  3. Hello Carlos

    Yes that’s right but even running through Database Node i have same message.
    I was wondering, can it be related to unconfigured metrics at cell level since it’s a brand new platform ?
    Or soem kind of missing ssh equivalency ?

    [oracle@dm02dbadm01 chc]$ java CellMetric -top -cell dm02celadm02
    Executing CellCLI, please wait for about 15 seconds…
    The authenticity of host ‘e21sdm02celadm02 (168.124.48.104)’ can’t be established.
    RSA key fingerprint is 75:38:4f:4d:95:ac:19:f6:c4:0a:ca:8c:90:59:cf:c3.
    Are you sure you want to continue connecting (yes/no)? yes
    —————————————————————————————–
    | Cell Name: dm02celadm02 | Time: 2015-12-09 09:47:06+0100 |
    ——————————————————————————————————————————————
    | CPU Used (%): 1.57 | Memory Total (%): 30 | Virtual Memory CS (MB): 120,151.05 | Temperature (C): 23 |
    | CPU Used CS (%): 0.54 | Memory CS (%): 14.72 | Virtual Memory MS (MB): 508.96 | Disk Contr. (C): 29 |
    | CPU Used MS (%): 0.01 | Memory MS (%): 0.53 | IORM Mode: Balanced | Swap Used (%): 0 |
    ——————————————————————————————————————————————
    | IB Port Received (%): 0.01 HCA-1:1 | IB Port Received (MB/s): 0.48 HCA-1:1 | Smart Flash Logging Errors (Disk): 0 |
    | 0.01 HCA-1:2 | 0.25 HCA-1:2 | Smart Flash Logging Errors (Flash): 0 |
    | IB Port Transfe. (%): 0 HCA-1:1 | IB Port Transfe. (MB/s): 0.15 HCA-1:1 | Smart Flash Logging (%): 100 |
    | 0.01 HCA-1:2 | 0.44 HCA-1:2 | Smart Flash Logging Last Hour (%): 100 |
    ——————————————————————————————————————————————
    | Cell Disk I/O Load | Used | LG Used | SM Used | SM Read | LG Read | SM Write | LG Write | Errors | Flash Cache |
    | Metric | (%) | (%) | (%) | (MB/s) | (MB/s) | (MB/s) | (MB/s) | | Metric |
    | Exception in thread “main” java.lang.NullPointerException
    at CellMetric.printScreenOutput(CellMetric.java:352)
    at CellMetric.fLoadXML(CellMetric.java:276)
    at CellMetric.fTop(CellMetric.java:143)
    at CellMetric.fTopOption(CellMetric.java:122)
    at CellMetric.main(CellMetric.java:32)
    [oracle@dm02dbadm01 chc]$ java -version
    java version “1.7.0_85”
    Java(TM) SE Runtime Environment (build 1.7.0_85-b15)
    Java HotSpot(TM) 64-Bit Server VM (build 24.85-b06, mixed mode)

  4. Hi Carlos
    I just send it to you, it looks rather fine; I also carried out the test on 2 other cells with same result unfortunately …
    Regards

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s