Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Redo log activity
On Mar 21, 6:17 am, "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
Also check to be sure someone didn't accidentally leave tablespaces in hot backup mode. That will cause additional redo to be generated because Oracle can't be sure that copying datafiles hot by an OS utility won't split blocks. RMAN doesn't have that problem, of course, but there is nothing preventing someone with privilege from placing tablespaces in backup mode regardless. So check for status of ACTIVE in v$backup.
jg
-- @home.com is bogus. Peabody is named after Rocky & His Friends co-producer Bill Scott's pet pooch.Received on Thu Mar 22 2007 - 16:15:02 CDT
![]() |
![]() |