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