delayed_logging_block_cleanout was introduced
in newer (7.3+) versions of Oracle to smooth things
out with OPS. But delayed block cleanout has been
around much longer - the documents tended to
hint that it no longer happened with the introduction
of the fast commit and delayed_logging_block_cleanout,
but reports were (like Mark Twain's death) exaggerated.
Jonathan Lewis
Seminars on getting the best out of Oracle
Last few places available for Sept 10th/11th
See http://www.jlcomp.demon.co.uk/seminar.html
-----Original Message-----
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: 17 August 2001 21:49
|I remember in slightly older versions of Oracle,
|delayed_logging_block_cleanouts is by default true, so redo won't be
written
|immediately at block cleanout. Correct me if I'm wrong.
|
|Yong Huang
|[EMAIL PROTECTED]
|
|Jonathan Lewis wrote:
|
|bear in mind that a scan after deleting 100,000
|rows would probably be doing a lot of
|delayed block cleanout - resulting in plenty
|of redo log, and possibly a lot of dbwr activity.
|
|Jonathan Lewis
|
|__________________________________________________
|Do You Yahoo!?
|Make international calls for as low as $.04/minute with Yahoo!
Messenger
|http://phonecard.yahoo.com/
|--
|Please see the official ORACLE-L FAQ: http://www.orafaq.com
|--
|Author: yong huang
| INET: [EMAIL PROTECTED]
|
|Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
|San Diego, California -- Public Internet access / Mailing
Lists
|--------------------------------------------------------------------
|To REMOVE yourself from this mailing list, send an E-Mail message
|to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|the message BODY, include a line containing: UNSUB ORACLE-L
|(or the name of mailing list you want to be removed from). You may
|also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jonathan Lewis
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
