Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Why does a SELECT query needs REDO?

Re: Why does a SELECT query needs REDO?

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Sat, 11 Feb 2006 06:59:41 GMT
Message-Id: <pan.2006.02.11.06.59.40.655987@sbcglobal.net>


On Thu, 09 Feb 2006 14:10:54 -0800, bdbafh wrote:

> see page 314 of Tom Kyte's new book "Expert Oracle Database
> Architecture"
> ISBN 1-59059-530-0
>
> -bdbafh

Page 314 of the book you mentioned is start of the block cleanout section. Delayed block cleanout might be the cause of the generated redo but so can be sorting. Writes to the temporary segments do generate redo. They don't generate undo, but redo is another matter indeed.

-- 
http://www.mgogala.com
Received on Sat Feb 11 2006 - 00:59:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US