RE: vmstat output to db

  • From: "David" <thump@xxxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 28 Jul 2004 19:38:08 -0700

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

Other related posts: