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;
Have you ever wanted to have a quick check on your CPU performance. I know that lot of people will say that this is not the right way to do this, but here is something that you can use to check the CPU speed.
#!/bin/bash -
#===============================================================================
#
# FILE: benchmark.sh
#
# USAGE: ./benchmark.sh
#
# DESCRIPTION: Benchmark the CPU
#
# OPTIONS: ---
# REQUIREMENTS: ---
# BUGS: ---
# NOTES: ---
# AUTHOR: Amit Agarwal (aka), amit.agarwal@roamware.com
# COMPANY: Roamware India Pvt Ltd
# CREATED: 09/21/2011 11:46:03 AM IST
# Last modified: Wed Sep 21, 2011 12:22PM
# REVISION: ---
#===============================================================================
add ()
{
COUNTER=0
exec 2>&1
time=$(exec 2>&1;(time while [[ $COUNTER -lt 100000 ]]; do ((COUNTER++)) \
; done))
echo "Time for 100000 additions is "$time
} # ---------- end of function add ----------
mul ()
{
COUNTER=0
test=2
exec 2>&1
time=$(exec 2>&1;(time while [[ $COUNTER -lt 100000 ]]; do ((COUNTER++)) \
; ((test=test*2));done))
echo "Time for 100000 mul is "$time
} # ---------- end of function add ----------
div ()
{
COUNTER=0
test=1000000000000
exec 2>&1
time=$(exec 2>&1;(time while [[ $COUNTER -lt 100000 ]]; do ((COUNTER++)) \
; (( test=test/2)); done)|tr -d '\n')
echo "Time for 100000 divisions is "${time}
} # ---------- end of function add ----------
time add
time mul
time div
And here is the output :
Continue reading