Highest Executions and Time Taken
SELECT SQL_ID, SQL_FULLTEXT, PLAN_HASH_VALUE, PARSING_SCHEMA_NAME, ELAPSED_TIME FROM V$SQL WHERE UPPER (PARSING_SCHEMA_NAME) = ? AND ELAPSED_TIME >= ? ORDER BY ELAPSED_TIME DESC;
SELECT SQL_ID, SQL_FULLTEXT, PLAN_HASH_VALUE, PARSING_SCHEMA_NAME, ELAPSED_TIME FROM V$SQL WHERE UPPER (PARSING_SCHEMA_NAME) = ? AND ELAPSED_TIME >= ? ORDER BY ELAPSED_TIME DESC;