Where IN

Hi,

on 11.2.0.3 I have the following queries with different execution time.

This one only 0.09 second :

select owner, object_type, object_name, data_object_id from dba_objects DBO, v$session_event SE, v$session S

where DBO.object_id=S.row_wait_obj# and SE.sid=S.SID and SE.event='db file sequential read' and S.row_wait_obj# !=-1

And the following 72 seconds :

select owner, object_type, object_name, data_object_id

from dba_objects

where object_id in (select row_wait_obj#

from v$session where sid in (select sid from  v$session_event

  WHERE event='db file sequential read'