i don't know what's wrong

[bxr556]

I have a table .
somehow i don't understand how it work.

for example.

from one sqlplus window, i
delete from mytable where id=300;

and then i open another windwo , if i
try to delete from mytable with id near 300.
it will wait until the first one commit or rollback,
but any id far from 300 is ok,
say 301 will wait, 302 will wait..... , but 400 is ok, 500 is ok.

then i tried some other id like 500.
same thing happen, 501 wait, 502 wait, 600 ok, 700 ok,


this table have nothing special, no index on any column either.
can somebody explain to me what's going on?

[chrisrlong]

This seems to be a *very* similar question to the other one I just answered for you - please try to keep related issues in a single post.

See http://www.dbasupport.com/forums/sho...threadid=11697 for possible reasons

- Chris

PS - closing this thread to keep confusion to a minimum