RE: vmstat output to db

From: David <thump_at_cosmiccooler.org>
Date: Wed, 28 Jul 2004 19:38:08 -0700
Message-ID: <000701c47515$16f3b590$6401a8c0@winston>

That's a good point.
Thanks for that! I'll take the advice.
Also, thanks Jared for your feedback...I have been following the advice. Cheers
David

-----Original Message-----

Subject: Re: vmstat output to db
There is a problem running thhis script in production. As every SQL is unique , you will get a lot of literal SQL in your production database, using all your shared pool.

Consider let vmstat write to a logfile, and use sqlldr to load it database every day, or, maybe every hour.

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 - 21:35:00 CDT