Re: Delete followed by Select Count(1) - SLOW

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 <ORACLE-L_at_fatcity.com> 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
|yong321_at_yahoo.com
|
|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: yong321_at_yahoo.com
|
|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: ListGuru_at_fatcity.com (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: jonathan_at_jlcomp.demon.co.uk

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: ListGuru_at_fatcity.com (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).