Re: Redo log activity

From: Matthias Hoys <anti_at_spam.com>
Date: Wed, 21 Mar 2007 20:59:29 +0100
Message-ID: <46018ea0$0$13861$ba620e4c@news.skynet.be>

"Andy Kent" <andykent.bristol1095_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 Received on Wed Mar 21 2007 - 14:59:29 CDT