Re: Unix script to monitor iostat on AIX 4.3.3

From: Sybrand Bakker <gooiditweg_at_sybrandb.nospam.demon.nl>
Date: Thu, 04 Sep 2003 23:46:03 +0200
Message-ID: <sjcflvsml0mjjfe8q86h72q9fp0rvn7fgk@4ax.com>

On Thu, 04 Sep 2003 12:15:02 -0400, chao_ping <member327_at_dbforums.com> wrote:

>
>Be careful using this script , I saw this script from STATSPACK HIGH
>PERFORMANCE TUNING (by bulson) and I saw a lot of DIFFERENT SQL in my
>shared pool and it used all my shared pool.
>
>I do not think it is a good idear.
>
>
>
>If you really want to log them into database, I suggest you awk them
>with proper format and use sqlldr to load them into database daily.
>
>
>
>Regards.
>
>Zhu Chao

Excellent remark. 'Tools' like the one of the OP are real resource hogs.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Sep 04 2003 - 16:46:03 CDT