Top SQL's In Database
SELECT *
FROM ( SELECT username,
LAST_LOAD_TIME,
sql_text,
sql_id,
elapsed_time,
cpu_time,
user_io_wait_time
FROM sys.v_$sqlarea s, dba_users u
WHERE u.USER_ID = s.PARSING_USER_ID
AND TRUNC (LAST_LOAD_TIME) = TRUNC (SYSDATE)
AND u.username =user
ORDER BY 6 DESC)
WHERE ROWNUM < 10;
FROM ( SELECT username,
LAST_LOAD_TIME,
sql_text,
sql_id,
elapsed_time,
cpu_time,
user_io_wait_time
FROM sys.v_$sqlarea s, dba_users u
WHERE u.USER_ID = s.PARSING_USER_ID
AND TRUNC (LAST_LOAD_TIME) = TRUNC (SYSDATE)
AND u.username =user
ORDER BY 6 DESC)
WHERE ROWNUM < 10;
No comments:
Post a Comment