dbms_utility.get_cpu_time returns the current CPU time as 100th's of a second from some arbitrary epoch. connect by clause requires approximately 9 to 10 centiseconds of CPU time: with s as (
select /*+ materialize */
dbms_utility.get_cpu_time tart
from
dual
)
select count(*) from (
select
null
from
s connect by s.tart + 10 > dbms_utility.get_cpu_time
);