Oracle Select the top 5 queries
Here are one sql script that I found some time back. This will be listing the top 5 SQL queries in Oracle.
SET linesize 300 SET PAGESIZE 200 select * from (select sql_text, sql_id, elapsed_time, cpu_time, user_io_wait_time from sys.v_$sqlarea order by 5 desc) where rownum < 6; quit;
Related articles
- SQL Fiddle (thinkvitamin.com)
- New Oracle E-Book (arnoldit.com)
- All about Security – SQL Injection (tkyte.blogspot.com)