Re: read consistency

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 29 Jun 2006 18:00:00 +0200
Message-ID: <44a3f901$0$11194$636a55ce@news.free.fr>

"Prasath" <prasath.rao_at_gmail.com> a écrit dans le message de news: 1151596534.551557.236640_at_x69g2000cwx.googlegroups.com...
| Session 1:
| --------------------
| select * from my_table; ->takes 5 minutes
|
| Session 2:
| -------------------
| delete from my_table where my_col = 1; -> takes less than 1 second
|
| commit;
|
|
| Question
| ---------------------
| Do the records deleted in session 2 appear in session 1?
|

Yes, if session 1 query starts before session 2 commit.

Regards
Michel Cadot Received on Thu Jun 29 2006 - 11:00:00 CDT