Vishal desai’s Oracle Blog

April 1, 2013

Exadata Cell Server Monitoring

Filed under: Exadata — vishaldesai @ 9:21 pm

If you are new to Exadata then you can learn more about Exadata monitoring by reading Chapter 12 of Expert Oracle Exadata and Oracle Exadata Command Reference. Once you know little bit about monitoring next challenge will be how to display those metrics in proper format. If you have Oracle Enterprise Manager 11g or 12c installed and configured in your infrastructure you can create dashboards to start monitoring Exadata.

I tried to write couple of Perl scripts that will display metrics on unix shell prompt for all storage cells and will refresh at regular interval of time (like Unix top command).

cell_metrics.pl will display CPU%, Memory% and runq for all storage cells. It takes two parameters samples and intervals. You could see some latency in interval as script submits dcli command and gets all data and formats it.

image

cell_ionet_metrics.pl will display Cell Disk IO, Grid Disk IO and few Network Statistics.

image

If there is a :, it represents min on left side and max on right side. Network Throughput are absolute numbers. Network errors columns should always be 0:0.

I haven’t paid much attention to tuning the dcli, awk and sed itself and did not test this on full rack. But basically this two wrapper script will give you idea if you want to monitor other cell metrics from command line.

Download code

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

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

Create a free website or blog at WordPress.com.

%d bloggers like this: