Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Unix script to monitor iostat on AIX 4.3.3
'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