Home > Oracle > Oracle: Which Top 10 queries are taking Time NOW

Oracle: Which Top 10 queries are taking Time NOW

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:
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: