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;