Re: vmstat output to db
- From: Jared Still <jkstill@xxxxxxxxxx>
- To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 28 Jul 2004 23:12:16 -0700
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@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:
