RE: vmstat output to db
- From: John Kanagaraj <john.kanagaraj@xxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 28 Jul 2004 16:28:58 -0700
>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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
