Month: February 2012

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;
Enhanced by Zemanta

Check out all the colors on you X window system.

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.

xcolorsel
xcolorsel

You will need to setup the rpm-shere repo for this.

Using this tool is very intuitive, just select the color and then press set as foreground/background to check how the color combination would look.

Enhanced by Zemanta

glances – Get a glimpse of the whole system

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 a look at glances. Here is how it looks:

glances
glances

For using this tool, here is what you need to do :

sudo yum install glances

and here is the description of the tool:

Description :
Glances is a CLI curses based monitoring tool for both GNU/Linux and BSD.

Glances uses the libstatgrab library to get information from your system.
Glances is developed in Python and uses the python-statgrab lib.

Hope you like it.

Enhanced by Zemanta