RAC aware SLOB2 analyze script (Flash DBA)
I’ve been using the very useful scripts from FlashDBA to run SLOB2 on our new system, but unfortunately the analyze one is not RAC aware, so I’ve modified it, in very minor ways, such that it can use an AWR Global report (
awrgrpt.sql) as input and still extract the same values that the original does.
I call the script slob2-rac-analyze.sh
Here is an example run – ignore the numbers as they are not representative of anything in particular.
a555.net(jeff.a1):/app/support/SLOB: ./slob2-rac-analyze.sh rac_awr_12jul2013/awr.20.032/awr.20.032.txt > slob.csv Info : Analyzing file rac_awr_12jul2013/awr.20.032/awr.20.032.txt Info : Filename = awr.20.032.txt Info : Update Pct = 20 Info : Workers = 032 Info : Read IOPS = 85.8 Info : Write IOPS = 33.0 Info : Redo IOPS = 15.6 Info : Total IOPS = 134.4 Info : Read Num Waits = 712 Info : Read Wait Time = 0.58 Info : Read Latency us = 814.606 Info : Write Num Waits = 926 Info : Write Wait Time = 0.28 Info : Write Latency us = 302.375 Info : Redo Num Waits = 2043 Info : Redo Wait Time = 0.37 Info : Redo Latency us = 181.106 Info : Num CPUs = 384 Info : Num CPU Cores = 192 Info : Num CPU Sockets = 24 Info : Linux Version = Red Hat Enterprise Linux Server release 6.3 (Santiago) Info : Kernel Version = 2.6.32-279.2.1.el6.x86_64 Info : Processor Type = Intel(R) Xeon(R) CPU E7- 2830 @ 2.13GHz Info : SLOB Run Time = 300 Info : SLOB Work Loop = 0 Info : SLOB Scale = 10000 Info : SLOB Work Unit = 256 Info : SLOB Redo Stress = LIGHT Info : SLOB Shared Data Mod = 0 Info : No more files found Info : ============================= Info : AWR Files Found = 1 Info : AWR Files Processed = 1 Info : Errors Experienced = 0 Info : =============================
Jonathan Lewis has a nice article covering the different AWR Reports.
I’ve only tested it on the system at work and it seems to work OK – your mileage may vary and I’d be happy to hear comments to the contrary, in relation to the changes I’ve made for use on RAC, but obviously the script is still 99% unchanged, so please contact FlashDBA if there are any generic issues you want to raise.
I’m not a unix shell script guy, but it seems to work…see what you think.