"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message
news:axzi9.36375$g9.104068_at_newsfeeds.bigpond.com...
>
> "Richard Foote" <richard.foote_at_bigpond.com> wrote in message
> news:YVyi9.36361$g9.103638_at_newsfeeds.bigpond.com...
> > Hi Howard,
> >
> > Cool !! (I knew we'll get there ;)
> >
> > The other issue of note which is applicable in the example I gave is
that
> > they have a standby database, which requires 'regularish' (is that a
word
> ?)
> > log switches (8i).
>
> Ha! We now even have the answer to that one: Data Guard (depending on how
> you configure it) requires no log switches before the redo is sent to the
> standby!!
>
> So there!!
>
> (I confess I'd forgotten this "minor" detail from the original post....
not
> surprising, I guess).
So anyone for log switches and checkpoints once a year then?
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Fri Sep 20 2002 - 14:04:30 CDT
