Re: Frequency of log switches

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!!
--------------------------------------------