Select will never come back,

I run a select-statement like this:

select count(*) from a
where not exists (select 1 from b
where b.qualifier = 'XX'
and a.id = b.id)

in v$session i can see, that the session is 'sleeping'. It takes only a few blocks an no resources.

Oracle 8.1.7.2 on Linus SusE SE7 Received on Fri Jun 07 2002 - 00:31:23 CDT