From yong321@yahoo.com Fri, 17 Aug 2001 13:21:33 -0700 From: yong huang Date: Fri, 17 Aug 2001 13:21:33 -0700 Subject: Re: Delete followed by Select Count(1) - SLOW Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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@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@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@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).