Re: statspack , LAG - does this look OK

On 10/26/07, Dennis Williams <oracledba.williams_at_gmail.com> wrote:
>
> BN,
>
> What problem are you trying to resolve? Is there a performance problem?
> Hourly snapshots - keep in mind that a lot can occur in an hour. What is
> the client load, how does it change over the hour? What is the server load?
>
> Dennis Williams
>

Greetings Dennis

The problem is already resolved with hourly STATSPACK Reports,

The porblem: Veriy high disk Activity
STATPSPACK Report: Log file sync, parallel writes high wait events

This happend after a vender release, they started writng polling data DB , I s howed them that through statspack reports, and 10046 Levle 12 trace on a few of their sessions,
they fixed the issue with a patch release,

Now my management needs to see these reports for a day on an hour basis, just like I showed

BN

-- 
Regards & Thanks
BN

--
http://www.freelists.org/webpage/oracle-l