create long running query on oracle

Posted on Mon 27 October 2014 in misc • 1 min read

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