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 log activity

Re: Redo log activity

From: sybrandb <sybrandb_at_gmail.com>
Date: 21 Mar 2007 06:21:31 -0700
Message-ID: <1174483291.097607.28220@o5g2000hsb.googlegroups.com>


On Mar 21, 2:17 pm, "Andy Kent" <andykent.bristol1..._at_virgin.net> wrote:
> 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

Use Logminer to identify which transactions are taking place and by whom they are executed.

--
Sybrand Bakker
Senior Oracle DBA
Received on Wed Mar 21 2007 - 08:21:31 CDT

Original text of this message

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