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@xxxxxxxxx> 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

Other related posts: