Try to use 'select for update nowait' if it is locked by other transaction you will see it.

Originally posted by sandycrab
I tried that, but this is not the case. as I told I can see the result of the same query in some other session in some other machine. For some users it will work fine but for some it won't.
Don't know what's happening. Rollback segs, temp segs are all fine...
lot of space in datafile also...
any clue...
Sandy
[Edited by kgb on 10-15-2002 at 12:25 PM]