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 [...]
Archive of entries posted on February 2012
Oracle Select the top 5 queries
27 February 2012, 11:34 am
Filed under Database.
Tagged Database, Languages, Microsoft SQL Server, mysql, oracle, Oracle Database, programming, sql
Comment
Check out all the colors on you X window system.
24 February 2012, 10:42 am
If you ever wondered what combination of some colors would look like but did not really feel like setting them in your xterm just to check them out. Or if you wanted to know about all the colors on you X window system then you can install this utility called xcolorsel. You will need to [...]
Filed under Fedora.
Tagged buzz.com, First Stable Release, Graphic Subsystems, Linux, Operating system, Operating Systems, Solaris, Terminal emulator, Wayland, Windows Phone, X Window System, X11, xterm
Comment
glances – Get a glimpse of the whole system
21 February 2012, 10:12 am
You would have used top at some point of time. Did you not wish that instead of just the processes it list all the vital statistics of the system as a whole. How good it would be to see the Memory, Net, Processes and Disk usage on the same screen. Well then you should take [...]
Hi, I am Amit Agarwal. I am the sole author of this blog and have worked on Linux for more than 10 Years now. My favourite is Fedora and am using Fedora at home and office.
I hope you will enjoy reading my blog and get in touch with me if you have any suggestions or complaints.
