[Oracle] making sense of sar

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 15 Aug 2017 11:16:23 -0700
Message-ID: <CAORjz=Nd2H73MfVQpfW+RYKUbFgNxt301d8OpH5EmiDT4Ym=qg_at_mail.gmail.com>

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

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

Received on Tue Aug 15 2017 - 20:16:23 CEST

Original text of this message