RE: [Oracle] making sense of sar

Jared

I use sar too.
Do you know this?: https://sourceforge.net/projects/ksar/

It´s a usefull tool.

There are some usefull notes here https://en.wikipedia.org/wiki/Ksar_(Unix_sar_grapher)

Greeting
Juan

De: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] En nombre de Jared Still Enviado el: martes, 15 de agosto de 2017 20:16 Para: Oracle-L Freelists
Asunto: [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

--
http://www.freelists.org/webpage/oracle-l