Re: Oracle parameter

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 25 Apr 1999 21:19:56 +0100
Message-ID: <925071813.7144.0.nnrp-11.9e984b29@news.demon.co.uk>

Last time I looked into it (7.1.6-ish) redo generation took place as normal but the call to write to the file was bypassed. So CPU still used as normal, but no waits for I/O.

This did speed things up a bit, but not dramatically; checkpoints still occur, by the way, and they can have a bigger I/O impact than that redo writes.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Ross Mohan wrote in message <7fvoes$1d8_at_sjx-ixn6.ix.netcom.com>...
>turns off "most" logging. ( Fine points escape me, but likely someone
>else will have these on the tip of their tongue)
Received on Sun Apr 25 1999 - 15:19:56 CDT