Re: Insert without redo log

"Yong Huang" <yhuang_at_indigopool.com> wrote in message news:96hbit$dp6$1_at_news.sinet.slb.com...
> I just did a test. create global temporary table testgtt (a number) on
> commit preserve rows in one session. Run:
>
> begin
> for i in 1..100000 loop
> insert into testgtt values (i);
> end loop;
> end;
> /
>
> Monitor v$rollstat in another session. Indeed the rollback is being used.
> This is a one person database.
>

It isn't even 1 person. The page I was thinking of reads: "DMLs do not generate redo" and the line under that says "DMLs generate rollback". My eyes read too many "nots" into that page!

Regards
HJR
> Yong Huang
> yhuang_at_indigopool.com
>
> Howard J. Rogers <howardjr_at_www.com> wrote in message
> news:3a8bcf89_at_news.iprimus.com.au...
> >
> > "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message
> > news:982225998.12720.0.nnrp-08.9e984b29_at_news.demon.co.uk...
> > >
> > > Inserts into temporary table generate rollback,
> > > and the rollback is covered by redo, so an insert
> > > into a temporary table does results in redo -
> > > albeit less than that required for a normal table.
> >
> > Mmmm... hadn't thought about that. The manuals state (in their
 inimitable
> > bullet point fashion!) "No redo generated for DML" for temporary
 tables....
> > I could have sworn they also said no rollback, but I must just be
 imagining
> > it. I think I should have just stuck with the short answer: "No". Has
 a
> > certain conciseness about it!!
>
>
>
Received on Thu Feb 15 2001 - 17:05:58 CST