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: Redo Problem ... Find from Statspack

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

Original text of this message

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