Re: [?] no logging mode

"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.

Regards
HJR

-- 
------------------------------------
Oracle insights at www.dizwell.com
------------------------------------