Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle Streams Log Purging Question
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-lReceived on Fri Mar 16 2007 - 17:13:33 CDT