do you think that i must increase log_buffer parameter ?
(now it is 16 MB)
thanks.
Ciao.
"Howard J. Rogers" <hjr_at_dizwell.com> ha scritto nel messaggio
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.
>
> Regards
> HJR
> --
> ------------------------------------
> Oracle insights at www.dizwell.com
> ------------------------------------
>
>
Received on Thu Jan 29 2004 - 07:46:12 CST
