Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: table nologging in 8i
In article <8m6qe8$v10$1_at_nnrp1.deja.com>, tedchyn_at_yahoo.com writes
>steve, thanks for the reply. It is true that deleting is no logged when
>table is in nologging mode ? what view are you using to monitor redo
>and undo consumption v$sysstat or v$transaction.
>thanks again ted
>
The table can't be put in nologging mode, that's the point.
The nologging option applies to the statement you are running.
It is confusing.
It doesn't matter which dictionary views you are using, you
won't see any redo reduction just because you ran a nologging
*statement* previously.
Steve Received on Tue Aug 01 2000 - 00:00:00 CDT