Re: [HACKERS] Q about read committed in Oracle...

On Tue, Jul 14, 1998 at 07:14:10PM +0800, Vadim Mikheev wrote:
> Could someone run in Oracle test below?

I could, but how do I make Oracle use read committed mode?

>
> 1. CREATE TABLE test (x integer, y integer)
> 2. INSERT INTO test VALUES (1, 1);
> INSERT INTO test VALUES (1, 2);
> INSERT INTO test VALUES (3, 2);
> 3. run two session T1 and T2 (in read committed mode)
> 4. in session T2 run
> UPDATE test SET x = 1, y = 2 WHERE x <> 1 OR y <> 2;
> 5. in session T1 run
> UPDATE test SET y = 3 WHERE x = 1;
> 6. in session T2 run
> COMMIT;
> 7. in session T1 run
> SELECT * FROM test; -- results?
> 8. in session T1 run
> COMMIT;
> 9. now in session T2 run
> UPDATE test SET x = 2;
> 10. in session T1 run
> UPDATE test SET y = 4 WHERE x = 1;
> 11. in session T2 run
> COMMIT;
> 12. in session T1 run
> SELECT * FROM test; -- results?
>
> TIA,
> Vadim

Michael
--
Dr. Michael Meskes meskes(at)online-club(dot)de, meskes(at)debian(dot)org
Go SF49ers! Go Rhein Fire! Use Debian GNU/Linux!