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 -> Confused about Queries and Rollback Segments!

Confused about Queries and Rollback Segments!

From: Jonathan E Miller <jmiller_at_fnol.net>
Date: Tue, 30 Nov 1999 19:01:18 -0500
Message-ID: <s4boif9pcv66@corp.supernews.com>


When does a simple query acquire a rollback segment? Does it always need one or only when there are other transactions ocurring that may be updating the same rows that the query is returning? We have frequentlly run into the snapshot too old problem seemingly when the only thing running is a large query.

Thanks
Jonathan Received on Tue Nov 30 1999 - 18:01:18 CST

Original text of this message

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