Re: Redo Problem ... Find from Statspack

From: Steve Robin <ocmaman_at_gmail.com>
Date: Wed, 17 Oct 2007 07:19:07 -0700
Message-ID: <1192630747.915502.309070@e34g2000pro.googlegroups.com>

On 17 Oct, 15:08, Steve Robin <ocma..._at_gmail.com> wrote:
> Hi,
>
> Two days before performance was down.... I find that log file sync and
> redo allocation latch was high.... now is there any way to find which
> queries or session were generating so many redo.
>
> Thanks
>
> Oracle : 9.2
> Server : Solaris

there was big difference above parameters.

redo write time

859,260                      227,541
summed dirty queue length          981,660

1,814,822
redo sync time

8000                         25000

Received on Wed Oct 17 2007 - 09:19:07 CDT