read consistency

From: Prasath <prasath.rao_at_gmail.com>
Date: 29 Jun 2006 08:55:34 -0700
Message-ID: <1151596534.551557.236640@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? Received on Thu Jun 29 2006 - 10:55:34 CDT