Re: Visibility of committed changes

Yep, that's basically what I did (except you got tables t1 and t2 mixed together :)

vlad

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:avpcau$4u0$1$8300dec7_at_news.demon.co.uk...
>
> Vlad is correct - there are some points at
> which the manuals are lacking in precision.
> The fact that you think the manuals are right
> is actually a demonstration of how easy it is
> to confuse the terms "statement", "query"
> and "transaction".
>
>
> Session A: (me)
> create table t1 (n1 number);
>
> Session B:
> insert into t2 values(1); -- starts a transaction before "me"
>
> Back to session A
> insert into t2 values(2);
> commit;
>
> Back to session B
> select * from t1;
> N1
> ---
> 1
> 2
>
>
> Session B can see the value from the
> transaction committed by session A, even
> though the transaction in Session A did
> not start before the transaction in session B.
>
>
> --
> Regards
>
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> Coming soon a new one-day tutorial:
> Cost Based Optimisation
> (see http://www.jlcomp.demon.co.uk/tutorial.html )
>
> Next Seminar dates:
> (see http://www.jlcomp.demon.co.uk/seminar.html )
>
> ____England______January 21/23
> ____USA_(CA, TX)_August
>
>
> The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
>
>
>
>
> Justin Cave wrote in message
> <233b7a65.0301110306.5400679d_at_posting.google.com>...
> >"vlad" <bulk_at_sfatcu.com> wrote in message
> news:<YaQT9.520599$GR5.237852_at_rwcrnsc51.ops.asp.att.net>...
> >> Hello. I've been reading up on Oracle lately and I find something
> quite
> >> strange in the "Concepts" manual. This is what they claim:
>
> >>
>
> >> -------------------------------------------------------------------
> >> The changes made by the SQL statement(s) of your transaction become
> >> permanent and visible to other users only after your transaction
> has
> >> been committed. Only other users' transactions that started after
> yours
> >> will see the committed changes.
> >> -------------------------------------------------------------------
> >
>
> >
> >The Oracle documentation is absolutely correct. How are you doing
> >your testing? My guess is that you've turned on autocommit, so each
> >statement is a transaction.
> >
> >Justin Cave
> >
>
>
>
Received on Sat Jan 11 2003 - 11:14:56 CST