And of course, there HAD to be some Perl in there as well! 😉
Pete
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Jared Still
Sent: Wednesday, August 16, 2017 04:16 AM
To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
Subject: [Oracle] making sense of sar
Some of you may find this useful.
I still find value in sar, though the world is enamored with streaming,
real-time cloud enabled and buzzword compliant performance metrics.
Chart Your Course With sar
http://bit.ly/sar-tools
The main script (asp.sh) can be used to collect sar data in CSV format for
several *nix sub-systems.
If you want, there are also some shell and Perl scripts that can be used to
aggregate data for easier consumption.
And if you're really ambitious, you can also install the Perl module
Writer::Excel::XLSX and easily create Excel spreadsheets and charts from the
command line.
Enjoy :)
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Principal Consultant at Pythian
Pythian Blog http://www.pythian.com/blog/author/still/
Github: https://github.com/jkstill