Re: Redo log activity

From: Keith <kknauss_at_gmail.com>
Date: 22 Mar 2007 09:12:14 -0700
Message-ID: <1174579934.021823.198520@n59g2000hsh.googlegroups.com>

On Mar 21, 3:59 pm, "Matthias Hoys" <a..._at_spam.com> wrote:
> "Andy Kent" <andykent.bristol1..._at_virgin.net> wrote in message
>
> news:1174483065.831203.246410_at_b75g2000hsg.googlegroups.com...
>
> > The system I've recently inherited (10g on Linux) is generating a lot
> > more redo than I would have expected. I must be missing something
> > somewhere as the active sessions don't seem to be doing that much.
> > What's a simple way to find out the main source(s) of the all redo
> > activity?
>
> > Thanks
>
> > Andy
>
> Probably some scheduled jobs, materialized view refreshes maybe ?
>
> With user SYSTEM : select * from dba_jobs/dba_scheduler;
>
> Matthias

If the system is "currently" generating a lot of redo, you could see if there's a session using a lot of undo (used rec/blk counts will fluctuate with commits):

select s.sid, t.addr, t.used_urec
from v$transaction t, v$session s
where s.taddr = t.addr; Received on Thu Mar 22 2007 - 11:12:14 CDT