Re: Can a SELECT statement build up a rollback segment?

Rollback segment transaction slots are opened by any transaction, so if your select uses the "for update" clause it will create rollback entries for the row locks you reserve, but I can not think of any other reason.

Regards
David Russell

johnvue_at_gte.net wrote in message <6pvnl1$r6c$1_at_news-1.news.gte.net>...
>
>Can a SELECT statement build up a rollback segment?
>
>Obviously, INSERT, UPDATE, and DELETE do but is there any way that
>SELECT query would build up rollback space. Of course, SELECT query
>may _use_ a rollback for read consistency... but that's not the same
>thing as building up rollback space.
Received on Sat Aug 01 1998 - 19:10:46 CDT