Re: Myths & legends: temporay segments and redo

I may have missed something, but I didn't see an example of temporary segments used by sorting generating any redo. Your example showed:

creation of gtt
redo size before insert into gtt
insert
redo size after insert into gtt

a session hold space in temp

Regards

Jonathan Lewis
http://www.oracle.com/technology/community/oracle_ace/ace1.html#lewis

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

• Original Message ----- From: "Mladen Gogala" <gogala_at_sbcglobal.net> To: <jonathan_at_jlcomp.demon.co.uk> Cc: "oracle-l" <oracle-l_at_freelists.org> Sent: Saturday, February 11, 2006 10:16 PM Subject: Re: Myths & legends: temporay segments and redo

On 02/11/2006 04:38:51 PM, Jonathan Lewis wrote:
>
> As a cross-check, you need to compare the redo
> from using a GTT with the redo from using a
> normal table.
>
> The answer to your puzzle is that changes to the
> GTT do not generate redo, but they do generate
> undo, and the undo generates redo.

How about the "normal" temporary segments, the ones allocated by sorts?

-- 
Mladen Gogala
http://www.mgogala.com

--
http://www.freelists.org/webpage/oracle-l



--
http://www.freelists.org/webpage/oracle-l