Hi, Tom
Today, I was trying to collect the current running SQL statements which elapsed more than 10 seconds per execution. To caculate the SQL Elapsed time, I have tried some SQL dictionary views (such as gv$sql, gv$sqlarea, gv$transaction, gv$session), but the "Elapsed_time" column on these views just present the total Elapsed time for a SQL statment, rather than per executions. SO I had to divide the "Elpased time" into "Executions", like the SQL Statments shown below:

SELECT A.SID,A.SERIAL#,S.ELAPSED_TIME/1000000,executions,A.PROGRAM,S.SQL_TEXT,S.SQL_ID FROM GV$SESSION A,GV$SQL S
WHERE A.SQL_HASH_VALUE = S.HASH_VALUE
AND ROUND(ELAPSED_TIME / 1000000 / (CASE
WHEN (EXECUTIONS = 0 OR NVL(EXECUTIONS, 1 ) = 1) THEN
1
ELSE
EXECUTIONS
END),
2)> 10
AND UPPER(SQL_TEXT) LIKE 'SELECT%'
AND A.STATUS = 'ACTIVE';


Is there any SQL dictionary view records the SQL per execution time, rather than total elapsed time?