Re: URGENT! Writes to Disk while Doing a SELECT statement?

Peter,

The version is 7.3.4 so the default clean-out mechanism means that a select statement should not cause cleaned blocks to be written. (delayed_logging_block_cleanouts = TRUE).

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

Peter Sharman wrote in message <36B87B07.5A348719_at_us.oracle.com>...
>Satar
>
>You may be seeing the effects of delayed block cleanout, where your SELECT
>statement is the first statement to hit blocks that have been updated but
not
>written out yet.
>
Received on Wed Feb 03 1999 - 11:55:32 CST