Re: [?] no logging mode

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Thu, 29 Jan 2004 13:01:03 GMT
Message-ID: <ju7Sb.33544$Wa.7135@news-server.bigpond.net.au>

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:4019025a$0$15135$afc38c87_at_news.optusnet.com.au...
> "gp" <gieppetto_at_tiscali.it> wrote in message
> news:bvap0o$8eo$1_at_balena.cs.interbusiness.it...
> > how is possible that i have this
> >
> > redo entries 8061565
> > redo log space requests 381
> > redo log space wait time 82
> >
> > when all my tablespaces works in nologging mode?
> >
>
> Because 'nologging' doesn't do what you think it ought to do. Normal
> inserts, updates and deletes *always* log, no matter how many times you
say
> 'nologging', and no matter how blue in the face you get saying it.
>
> Nologging only works -that is, genuinely suppresses the production of
redo,
> for a very specific class of SQL statement, nearly all of it DDL-related.
> Create index, for example. Create table X as select * from Y. SQL Loader
> bulk loads from external text files.That sort of thing.
>
> Regular DML? Forget it. It must always log, and will always log.
>

Hi Howard,

Unless you set _disable_logging = true.

A good idea, perhaps not ;)

Cheers

Richard Received on Thu Jan 29 2004 - 07:01:03 CST