Hi,
I have this simple query
select distinct e.id1
from v$session d, v$lock e
where d.lockwait = e.kaddr;
which is taking for ever, where as when I issue
select distinct e.id1
from v$session d, v$lock e
where d.lockwait = e.kaddr and d.lockwait is not null;
it comes back in a minute.
What could be the reason?
Badrinath