create long running query on oracle

In order to make a resource plan on oracle, you need a long running query to test, for example:

 

select count(*) from dba_extents e, dba_segments s, dba_tables t where e.segment_name!=s.segment_name and e.segment_name!=t.table_name and s.segment_name!=t.table_name