Oracle Tools Class SQL

First, the query performs the slowest SQL

SELECT * FROM (select SA. Sql_text,        SA. Sql_fulltext,        SA. Executions "number of executions",        round (SA. elapsed_time/1000000, 2) "Total execution time",        round (SA. Elapsed_time/1000000/sa. Executions, 2) "Average execution time",        Sa.command_type,        SA. parsing_user_id "User ID",        u.username "user name",        SA. Hash_value from     V$sqlarea sa left     join all_users u on      sa. parsing_user_id = u.user_id     where SA. Executions > 0     ORDER by (SA. Elapsed_time/sa. executions) desc) where rownum <= 50;

Second, the most frequently queried SQL

SELECT * FROM (select S.sql_text,        s.executions "number of executions",        s.parsing_user_id "username",        rank () over (order by Executions desc) Exec_rank from     V$sql s left     joins All_users u on      u.user_id = s.parsing_user_id) T where Exec_r Ank <= 100;

Summarize

Oracle Tools Class SQL