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