glandaverde · November 10, 2015 17:36
diff --git a/top_sql_in_awr.sql b/top_sql_in_awr.sql

 select * from (
 SELECT SQL_ID, MODULE, ACTION, RANK () OVER (ORDER BY avgt DESC) AS ELAPSED_RANK,avgt as "execution time(sec)" from
 (
 select SQL_ID, MODULE, ACTION,ROUND(SUM(ELAPSED_TIME_DELTA)/SUM(decode(executions_delta,0,1,executions_delta))/1000000,5) avgt
 FROM DBA_HIST_SQLSTAT
 where SNAP_ID between   and   
 group by SQL_ID, MODULE, ACTION
 ))
 WHERE ELAPSED_RANK <= 15;

	select * from (
	SELECT SQL_ID, MODULE, ACTION, RANK () OVER (ORDER BY avgt DESC) AS ELAPSED_RANK,avgt as "execution time(sec)" from
	(
	select SQL_ID, MODULE, ACTION,ROUND(SUM(ELAPSED_TIME_DELTA)/SUM(decode(executions_delta,0,1,executions_delta))/1000000,5) avgt
	FROM DBA_HIST_SQLSTAT
	where SNAP_ID between and
	group by SQL_ID, MODULE, ACTION
	))
	WHERE ELAPSED_RANK <= 15;