Host and Database Performance Monitoring - Oracle Exadata Recipes: A Problem-Solution Approach - page 405

| |-oswsub.sh,16915 ./oswsub.sh HighFreq ./Exadata_mpstat.sh
| | '-Exadata_mpstat.,16922 ./Exadata_mpstat.sh HighFreq
| | '-mpstat,25319 5 720
| |-oswsub.sh,16916 ./oswsub.sh HighFreq ./Exadata_netstat.sh
| | '-Exadata_netstat,16924 ./Exadata_netstat.sh HighFreq
| | '-sleep,16069 15
| |-oswsub.sh,16917 ./oswsub.sh HighFreq ./Exadata_iostat.sh
| | '-Exadata_iostat.,16926 ./Exadata_iostat.sh HighFreq
| | '-iostat,24694 -t -x 5 720
| |-oswsub.sh,16918 ./oswsub.sh HighFreq ./Exadata_diskstats.sh
| | '-Exadata_disksta,16928 ./Exadata_diskstats.sh HighFreq
| | '-sleep,16064 5
| |-oswsub.sh,16919 ./oswsub.sh HighFreq ./Exadata_top.sh
| | '-Exadata_top.sh,16930 ./Exadata_top.sh HighFreq
| | '-top,31419 -b -c -d 5 -n 720
| '-oswsub.sh,16927 ./oswsub.sh HighFreq /opt/oracle.oswatcher/osw/ExadataRdsInfo.sh
| '-ExadataRdsInfo.,16941 /opt/oracle.oswatcher/osw/ExadataRdsInfo.sh HighFreq

As part of its normal operation, OSWatcher will automatically compress older output files using bzip2 and retain
seven days of compressed statistics files in the /opt/oracle.oswatcher/osw/archive/* directories.
It is worth mentioning that OSWatcher is not an Exadata-specific utility. Oracle has modified the default
OSWatcher utility that is shipped with Exadata to include Exadata-specific metrics and output. The stand-alone
version of OSWatcher is currently described in My Oracle Support document 301137.1 and includes references
to a graphical tool called the OSWBB, or OSWatcher Black Box Analyzer. This current OSWBB plotting utility will
unfortunately not work on Exadata's customized OSWatcher output files, so graphing your host performance metrics
generally requires manual scripting and graphing. We recommend using Perl and R to perform these tasks, but
specific examples are beyond the scope of this recipe.

14-2. Displaying Real-Time Compute Node and Storage Cell
Performance Statistics
Problem
You wish to perform real-time performance monitoring for multiple performance metrics on your Exadata Compute
Nodes and storage cells without having to independently execute and collect output for individual host commands
such as sar , iostat , and vmstat .

Solution
In this recipe, you will learn how to install and use collectl on your Exadata Compute Nodes and storage cells to
report on various performance utilization metrics.

■ the collectl utility is not installed by default on exadata. oracle prohibits installing unsupported software on
your exadata Compute nodes and storage cells and, as such, the steps contained in this recipe are not strictly supported.
having said this, in our experience, collectl is a tool used by many experienced exadata dmas and oracle employees
and poses no risk to your environment.

Note