Oracle Select the top 5 queries
2012-02-27
64 words
1 min read
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)
Related Articles:
- 2010/06/04 SQuirrel SQL for Graphical interface to Oracle/MySQL and loads of other database – OSS and free.
- 2011/12/01 Backup of files in the directory.
- 2012/02/21 glances – Get a glimpse of the whole system
- 2012/01/15 Benchmarking the system/CPU performance
- 2012/01/06 BASH Script Performace
Authored By Amit Agarwal
Amit Agarwal, Linux and Photography are my hobbies.Creative Commons Attribution 4.0 International License.