Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: uncommitted reads
"Antoine BRUNEL" <antoinebrunel/yahoo.fr> wrote in message news:<3ecaa231$0$12698$79c14f64_at_nan-newsreader-02.noos.net>...
> Hi from Paris
>
> you're not able to see uncommited data...
>
Why, you sure can see uncommited data. From the session which made changes. Any other session can see changes only after commit. Dirty reads in MS SQL and DB2 allow you to see uncommited changes made by other sessions. That's the difference.
> however, have a look a this:
>
> http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c21cnsis.htm#2627
>
>
>
> "Howard J. Rogers" <howardjr2000_at_yahoo.com.au> a écrit dans le message de
> news:6ioya.38546$1s1.544893_at_newsfeeds.bigpond.com...
> > You mean, see data that someone else has changed, but not yet committed?
> >
> > Nope.
> >
> > Oracle does not have the concept of a 'dirty read' in the way that certain
> > other products do.
> >
> > Regards
> > HJR
> >
> > "Lanying & Manfred Chen-Fischer" <manfis_at_t-online.de> wrote in message
> > news:bad30g$7cs$04$1_at_news.t-online.com...
> > > Hi
> > >
> > > 1. is there any chance to have an ancommitted read in Oracle?
> > >
> > > ManFis
> > >
> > >
> >
> >
Received on Thu May 22 2003 - 11:17:36 CDT