Re: Oracle Streams Log Purging Question

David,

I've ended up purging them by taking

DBA_CAPTURE.REQUIRED_CHECKPOINT_SCN and purging all older logs from DBA_REGISTERED_ARCHIVED_LOG. That way the "purge" process is much more faster.

On 3/17/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
>
>
>

-- 
Alexander Fatkulin
--
http://www.freelists.org/webpage/oracle-l