Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Unix script to monitor iostat on AIX 4.3.3

Re: Unix script to monitor iostat on AIX 4.3.3

From: Ted McCabe <theom_at_gte.net>
Date: Sat, 06 Sep 2003 08:34:34 GMT
Message-ID: <u_g6b.4463$ae6.179@nwrddc01.gnilink.net>


'internal' is not the ususal owner of the statspak. You might need to prefix the insert with the schema owner. HTH
Ted
"chao_ping" <member327_at_dbforums.com> wrote in message news:3330639.1062692102_at_dbforums.com...
>
> 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
>
>
> --
> Posted via http://dbforums.com
Received on Sat Sep 06 2003 - 03:34:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US