Exadata hard disk usage at hand

On board each Exadata Storage Server there's an Exadata specific version of OS Watcher. It's a gold mine of information, with a very thin level of detail.

I had to study the effect of write back flash cache: the following awk script extracts %util of the most used hard disk from iostat archives of OS Watcher.

Enjoy!

BEGIN {
          timeStamp="0";
}
/^sd[a-z] / {
          extractedField=$12;
          if ( a[timeStamp] < extractedField ) {
              a[timeStamp] = extractedField;
          }
}

/^zzz/ {
          sampleDate=sprintf("%s/%s/%s", $7, $3, $4);
}

/^Time/ {
          timeStamp=sprintf("%s %s", sampleDate, substr($2,1,5));
}
END {
          for ( ia in a ) {
                  printf ("\"%s\",\"%s\"\n", ia, a[ia]);
          }
}

Here is a sample graph you can generate with the data obtained in such way.

% Uitl of most used disk

NOTE: Exadata documentation is not public. I'd love to explain where OS Watcher is on cells and many other details... but, if you are interested in this topic, you have Exadata and you can access plenty of documentation!

NOTE2: The simple script discussed here extracts information about the most used physical disk, which is not representative of the overall cell operation. It just derives from a very specific interest of mine. Fell free to adapt it to your needs.



Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

Enrico Brambilla is an Oracle Core Technology Expert, member of Oracle Consulting. He has worked with over a hundered big and small customers across the years, gathering thoughts to share about Database, e-BS, Exadata, GoldenGate and more - not "just" technology.

Search

Categories
Archives
« March 2015
SunMonTueWedThuFriSat
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
    
       
Today