Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!pd7cy2so!shaw.ca!pd2nf1so.cg.shawcable.net!residential.shaw.ca!news-out.superfeed.net!propagator2-maxim!feed-maxim.newsfeeds.com!newsfeed.pacific.net.au!spool01.syd.optusnet.com.au!spool.optusnet.com.au!not-for-mail Message-Id: <3f86cea8$0$30614$afc38c87@news.optusnet.com.au> From: "Howard J. Rogers" Subject: Re: Frequency of log switches Newsgroups: comp.databases.oracle.server Date: Sat, 11 Oct 2003 01:19:57 +1000 References: <5208be2f.0310072327.14f5c0d9@posting.google.com> <3f83d530$0$29410$afc38c87@news.optusnet.com.au> Organization: Dizwell Informatics User-Agent: KNode/0.7.2 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7Bit Lines: 26 NNTP-Posting-Host: 203.164.6.211 X-Trace: 1065799337 30614 203.164.6.211 Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:245031 Jonathan Lewis wrote: > the detail that CREATE TABLE AS SELECT is > automatically nologging if the database is noarchivelog > mode - the same may be true of indexes by now, but > I don't recall testing it - so a switch from noarchivelog > to archivelog could easily result in extra redo being > generated. True. And things like direct SQL Loads, which never log in noarchivelog mode, but will log in archivelog mode unless you specifically request nologging for the table before the load begins. But the OP swore that no-one else was on the database doing transactional stuff like that, so that's why I didn't particular dwell on the odd exception. Regards HJR -- -------------------------------------------- See my brand new website, soon to be full of new articles: www.dizwell.com. Nothing much there yet, but give it time!! --------------------------------------------