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: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 17 Oct 2007 08:55:55 -0700
Message-ID: <1192636545.760453@bubbleator.drizzle.com>


Steve Robin 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

Define "log file sync and redo allocation latch was high."

Compared to a baseline or just a big number and you are assuming that it indicates an issue?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Wed Oct 17 2007 - 10:55:55 CDT

Original text of this message

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