RE: vmstat output to db

From: John Kanagaraj <john.kanagaraj_at_hds.com>
Date: Wed, 28 Jul 2004 16:28:58 -0700
Message-ID: <35CFD500D7BDCE43B9030BBA5979DC18015A38D0@ussccem13.corp.hds.com>

>Also, the vmstat header lines repeat, so the 'sed' command will
>only remove the first instance of them.

Note that the first 'data' line is _always_ a summary of data since the server restart. This should be ignored - else you will get incorrect data.

In any case, use of 'vmstat' begs this question: Why not use 'sar'? When properly configured, sar files store _much_ more information that vmstat and that too persistently in '/var/adm/sa' directory. Thus, you could have a script that parses the output of 'sar -<whatever_options> -f <previous_day's_file>' and load it up.

John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)

Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com

The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers **

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed Jul 28 2004 - 18:26:20 CDT