Re: RAID10 config...

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Wed, 22 Oct 2003 12:13:50 +0200
Message-ID: <bn5l8v$ftn$1@news.fujitsu-siemens.com>

"Harald Maier" <maierh_at_myself.com> schrieb im Newsbeitrag news:m3ekx51zfc.fsf_at_ate.maierh...
> Brian Peasland <dba_at_remove_spam.peasland.com> writes:
>
> > My control files are the biggest bottleneck, not even close. Online
> > redo logs, archive log destination, and the datafiles belong the the
> > tablespace being loaded are the ones that get the most activity when
> > I do mass loads of data.
>
> I cannot see why the control file should be a bottleneck but maybe I
> am something missing. The control file is mainly updated at checkpoints.
> If checkpoints not happen to frequently why should they a bottleneck?
All right. I had assumed that every scn change gets recorded in the controlfile and that therefore every commit triggers one write on the controlfile.

Lots of Greetings!
Volker Received on Wed Oct 22 2003 - 05:13:50 CDT