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