read uncommited

From: Frank Swarbrick <>
Date: Wed, 25 Nov 2009 13:01:46 -0700
Message-ID: <>

In DB2 you can do something like the following:

WITH UR; If you have, say, a batch application that is inserting a lot of rows in to a table, with no commits until the end of the job, doing the above query while the batch update job is still running will allow you to see the inserted but not yet committed rows.

Not something that you would want to do with a user application, but it's something that as a developer I have found occasionally useful (seeing what my batch job is "doing" before it's actually done).

Is there any such feature available for Oracle?



Frank Swarbrick
Applications Architect - Mainframe Applications Development
FirstBank Data Corporation - Lakewood, CO  USA
P: 303-235-1403
Received on Wed Nov 25 2009 - 14:01:46 CST

Original text of this message