select 
  total_cpu_time
, total_cpu_time* 100 /nullif(sum(total_cpu_time) over(rows between unbounded preceding and unbounded following),  0 ) total_cpu_time_pct
, num_executions
, total_cpu_time/nullif(num_executions,  0 ) total_cpu_time_avg
, stmt_text
from (
select 
  total_sys_cpu_time+total_usr_cpu_time as total_cpu_time
, num_executions
, stmt_text
from table(snapshot_dyn_sql('', - 1 )) t
where stmt_text is not null
) t
order by  1  desc
fetch first  10  rows only

Недопустимая спецификация окна для функции OLAP. Код причины ="1

select 
  total_cpu_time
, total_cpu_time*100/nullif(sum(total_cpu_time) over(order by total_cpu_time desc rows between unbounded preceding and unbounded following), 0) total_cpu_time_pct
, num_executions
, total_cpu_time/nullif(num_executions, 0) total_cpu_time_avg
, stmt_text
from (
select 
  total_sys_time+total_usr_time as total_cpu_time
, num_executions
, stmt_text
from table(snap_get_dyn_sql('', -1)) t
where stmt_text is not null
) t
order by total_cpu_time desc
fetch first 10 rows only