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

From: Adam Danieluk <adanielu_at_natned.com.pl>
Date: Mon, 03 Aug 1998 12:20:14 +0200
Message-ID: <35C58EDE.85A48AE6@natned.com.pl>

SELECT don't build rollback segment,
because select don't change database.

johnvue_at_gte.net wrote:
>
> 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.

--
Adam Danieluk

---

e-mail: adanielu_at_natned.com.pl

---

Received on Mon Aug 03 1998 - 05:20:14 CDT