包含schema , module , 总的CPU , 执行次数 , 总时间 和 天数:
select parsing_schema_name,
module,
sum(cpu_time),
sum(executions),
sum(elapsed_time),
round(max(last_load_time) -
min(TO_DATE(substr(first_load_time, 1, 10), 'YYYY - MM - DD')),
2) "#days"
from v$sqlarea
group by parsing_schema_name, module;