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@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 -----------------------------------------------------------------