Re: Redo Problem ... Find from Statspack

From: <daoudamjad_at_emailmiser.com>
Date: Thu, 18 Oct 2007 05:09:47 -0700
Message-ID: <1192709387.149336.151260@e9g2000prf.googlegroups.com>

On Oct 17, 5:55 pm, DA Morgan <damor..._at_psoug.org> wrote:
> 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
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

Rainbow Tables for CAIN:

• only for system account
• up to 8 characters passwords;
• 100 torrent files;
• Total: 625 MB* 100;
• success rate 100%
• Maximum crack time: 5 seconds for each file; check CAIN for details;
• generated by winrtgen

parameters are given below:

oracle_oracle#1-8_0_2400x40000000_system#000.rt
oracle_oracle#1-8_0_2400x40000000_system#001.rt
oracle_oracle#1-8_0_2400x40000000_system#002.rt
...........................

oracle_oracle#1-8_0_2400x40000000_system#099.rt

email for details, demo, and downloading url's!

(Only system account) oracle hashes challenges are welcome! please make the payment FIRST!

happy crackin' Received on Thu Oct 18 2007 - 07:09:47 CDT