Cacher is the code snippet organizer for pro developers

SELECT 
    parsing_schema_name,
    sql_text,
    SUM(executions) AS executions,
    SUM(ROUND(elapsed_time / 10000000, 3)) AS elapsed_secs,
    SUM(ROUND(cpu_time / 10000000, 3)) AS cpu_secs,
    ROUND(AVG(cpu_time / 10000000 / executions), 3) AS avg_time
FROM v$sql
WHERE executions > 0 AND last_active_time > (SYSDATE - 1/24) 
  AND parsing_schema_name IN ('EQW_RDB', 'EQW_RDB_LOG')
GROUP BY parsing_schema_name, sql_text
ORDER BY avg_time DESC;