Re: Redo Problem ... Find from Statspack

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