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$426a74cc_at_news.free.fr>


"Frank Swarbrick" <Frank.Swarbrick_at_efirstbank.com> a écrit dans le message de news: 4B0D2ABA.6F0F.0085.0_at_efirstbank.com...
| In DB2 you can do something like the following:
|
| SELECT *
| FROM MYTABLE
| 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?
|
| 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.

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

Original text of this message