If you have for example a performance problem or a crash on your Exadata Machine and you need an overview about the machine then use the very powerful tool „GetExaWatcherResults.sh“ which based on the data of Exawatcher.
GetExaWatcherResults.sh give you a details about:
- CPU utilization and details
- IO Summary
- and more
GetExaWatcherResults.sh will generate very good graphics and that is what I will show now.
How is the way to get these graphs?
Login as "root" cd /opt/oracle.ExaWatcher GetExaWatcherResults.sh --from 02/23/2018_08:00:00 --to 02/23/2018_13:00:00 --resultdir /tmp/exawatcher_230218
cd /tmp/exawatcher_230218 bunzip2 the archive and un tar it tar xvf ExaWatcher_exa31_2018-02-23_08_00_00_5h00m00s.tar
Change to the newly created directory and you find the following files
index.html exa31.net_cpu.html exa31.net.html exa31.net_iodetail.html exa31.net_iosummary.html exa31.net_menu.html exa31.net_mp.html
Start a Browser on the Server or copy the files to your notebook and start analyzing
open the "index.html" files
here the details
It is easy to answer questions like
- What is the CPU usage on Friday between 09:00 an 14:00 o’clock?
- Where do we have a CPU peek during the business hours?
No problem with „GetExaWatcherResults.sh“ and if needed go deeper with other tools for example „awr – report“ on the database itself or an „ash-report“
Try it. It’s very helpful :-)