Re: Frequency of log switches

kurt-erich.finger_at_hte-company.de (Kurt-Erich Finger) wrote in message news:<5208be2f.0310090335.2f7b3587_at_posting.google.com>...

> yesterday evening I stopped archiving for my test database.
> The log switches were back to 'normal' frequency. Which means one log
> switch per
> 12hrs. Since nobody is using this instance that's what I would
> exspect.
> I used log miner as described in the Administarator Guide and found
> 7000 records in $logmnr_contents when archiving was on, but
> 22000 records when archiving was off.
> In both cases I only found entries for user SYS (SYS.SNAP,SYS.JOB
> etc.) and INTERNAL operations.
>
> What could be the reason for this strange behavior?
> (I also searched metalink but couldn't find anything)

Were you testing replication?

jg

--
@home.com is bogus.
He got a "D" in high school chemistry: 
http://www.uniontrib.com/news/uniontrib/thu/news/news_1n9chem.html