Re: read uncommited

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 25 Nov 2009 21:23:23 +0100
Message-ID: <4b0d923f$0$18417$>

"Frank Swarbrick" <> a écrit dans le message de news:
| In DB2 you can do something like the following:
| 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?
| Thanks,
| Frank
| --
| Frank Swarbrick
| Applications Architect - Mainframe Applications Development
| FirstBank Data Corporation - Lakewood, CO USA
| P: 303-235-1403

Read uncommitted is impossible in Oracle. You can set client info using dbms_application_info package to know where your batch is in another session querying v$session.

Michel Received on Wed Nov 25 2009 - 14:23:23 CST

Original text of this message