Re: vmstat output to db

From: Jared Still <jkstill_at_cybcon.com>
Date: Wed, 28 Jul 2004 23:12:16 -0700
Message-Id: <1091081536.30520.286.camel@poirot>

On Wed, 2004-07-28 at 17:37, zhu chao wrote:
> 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.
>

Another solution would be to do this in perl, with bind variables.

It would be a bit less resource intensive as well.

Jared

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 Thu Jul 29 2004 - 01:01:03 CDT