Re: Mysterious log switches

Is log_checkpoint_interval set in your init.ora ? If so, comment it out.

-MichAEL

In article <6clplr$5rt_at_camel18.mindspring.com>,   "Uday Bikkasani" <udayb_at_mindspring.com> wrote:
>
> Check the Cron. May be it was a part of a previous dba's backup strategy.
>
> uday
>
> Benjamin Zhang wrote in message <34EC95B7.4A54_at_ei.org>...
> >>
> >> Van Anh Thi Nguyen wrote in message
 <34E89547.67D03CAE_at_PO-Box.McGill.CA>...
> >> >Are you sure there are no jobs running?
> >> >
> >> >John Bagley wrote:
> >> >
> >> >> I've got a 7.3 Oracle instance hosting Oracle Applications (Gov't
> >> >> Financials) and running in archivelog mode. I know for certain that
> >> >> it
> >> >> is not being used at all (no user activity and no concurrent
> >> >> requests).
> >> >> However, it has been doing log switches at somewhat regular intervals
> >> >> (about every 10-12 hours) and archiving the redo logs. The size of my
> >> >>
> >> >> redo logs is 4MB. The folks at support tell me that this shouldn't be
> >> >>
> >> >> happening, but no one can tell me why it's happening. Anyone got any
> >> >> ideas/suggestions?
> >> >
> >> >
> >
> >Interesting. What are the file sizes in the archive log
> >directory?
> >
> >ben
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon Feb 23 1998 - 00:00:00 CST