Shulou(Shulou.com)06/01 Report--

SELECT *

FROM (SELECT sqlarea.sql_text

Dba_users.username

Sqlarea.sql_id

SUM (active_session_history.wait_time + active_session_history.time_waited)

Total_wait_time

FROM v$active_session_history active_session_history, v$sqlarea sqlarea, dba_users

WHERE active_session_history.sample_time BETWEEN SYSDATE-60 / 2880 AND SYSDATE

AND active_session_history.sql_id = sqlarea.sql_id

AND active_session_history.user_id = dba_users.user_id

GROUP BY active_session_history.user_id

Sqlarea.sql_text

Sqlarea.sql_id

Dba_users.username

ORDER BY 4 DESC) x

WHERE ROWNUM

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.