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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle Streams Log Purging Question

Re: Oracle Streams Log Purging Question

From: Alex Gorbachev <gorbyx_at_gmail.com>
Date: Fri, 16 Mar 2007 17:13:33 -0500
Message-ID: <c2213f680703161513v12cbfedel40bfef2ab89247ea@mail.gmail.com>


It's the capture process that marks logs purgeable if I'm not mistaken. IIRC, you just need to bounce capture process and it will mark purgeable logs.
I.e. DBMS_CAPTURE_ADM.STOP/START.

On 3/16/07, David Hicken <mr.hicken_at_gmail.com> wrote:
> Received this from a colleague. We are running on Oracle 10.2.0.2 on HP
> Itanium HP-UX.
>
> We have a downstreams capture process that is filling our mount point with logs. We have the checkpoint_retention_time set to .01 so they will be kept about an hour. I know from my
> reading there is a process that runs and looks at the retention and marks the logs as
> purgeable. It appears to me that it runs once a day. Once a day is not often enough for
> us. I cannot find anything on this process except a reference that says something runs and
> marks the logs. Does anyone know anything about the process and how we can make it run more
> often? I have read we can set the checkpoint_retention_time to infinite so the logs won't
> get purged, but how can we set them to be marked purgeable as soon as they are processed or
> set the process up to run more often that marks them purgeable?
>
> Candy
>
> --
>
> 3/16/2007 -- David Hicken
> (mr dot hicken at gmail dot com)
> We can never give up longing and wishing as long as we are still alive.
> -- George Eliot (Mary Ann Evans)
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Best regards,
Alex Gorbachev

http://www.oracloid.com
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Mar 16 2007 - 17:13:33 CDT

Original text of this message

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