Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Why does a SELECT query needs REDO?
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.comReceived on Sat Feb 11 2006 - 00:59:41 CST