Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Redo logs marked as 'ACTIVE'

Re: Redo logs marked as 'ACTIVE'

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 7 Apr 2004 15:12:31 +0100
Message-ID: <40740c50$0$6557$ed9e5944@reading.news.pipex.net>


logs are marked as active if they contain data which is *needed* for crash recovery, in otherwords the system hasn't checkpointed yet.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK
http://www.niall.litchfield.dial.pipex.com/
"D. Alvarado" <laredotornado_at_zipmail.com> wrote in message
news:9fe1f2ad.0404070528.f014a30_at_posting.google.com...

> I am running Oracle 8.1.7. I understand that if a database is
> undergoing crash recovery redo logs would be marked as 'ACTIVE' in the
> appropriate V$ views, but I read somewhere that they would also be
> marked as 'ACTIVE' when the database is experiencing intense,
> long-running transactions. Why would this be?
>
> Thanks, - Dave
Received on Wed Apr 07 2004 - 09:12:31 CDT

Original text of this message

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