Archive

Posts Tagged ‘Performance’

Oracle: Which Top 10 queries are taking Time NOW

October 26, 2011 Leave a comment

SELECT * FROM
(SELECT
sql_fulltext,
elapsed_time/executions/1000000,
executions,
last_load_time,
LAST_ACTIVE_TIME
FROM v$sql
Where executions > 0
ORDER BY elapsed_time desc )
WHERE ROWNUM < 11

Advertisements
Categories: Oracle Tags: