Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: vmstat output to db

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US