Re: read uncommited
Date: Wed, 25 Nov 2009 21:23:23 +0100
"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?
| 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