Re: vmstat output to db

From: zhu chao <zhuchao_at_gmail.com>
Date: Thu, 29 Jul 2004 08:37:54 +0800
Message-ID: <962cf44b04072817374b32d5fd@mail.gmail.com>

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

-- 
Regards
Zhu Chao
www.cnoug.org
----------------------------------------------------------------
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 Wed Jul 28 2004 - 19:34:41 CDT