#!/bin/ksh # # Find Highest CPU used Oracle processes and get the Username # and SID from oracle # Only 3 character SIDNAME is displayed - Adjust the script according to your need. # # Biju Thomas - 4/22/1999 # date echo " Top 20 CPU Utilized Session from `hostname`" echo " ============================================" echo "O/S Oracle Session Session Serial UNIX Login Ora CPU Time" echo "ID User ID Status ID No ID MMDD:HHMISS SID Used" echo "-------- ----------- -------- ------- ------- ------- ----------- --- --------" ps -ef|grep LOCAL|cut -c1-15,42-79|sort -rn +2 | head -20 | while read LINE do SIDNAME=`echo $LINE | awk '{ print $4 }' | cut -c7-14` CPUTIME=`echo $LINE | awk '{ print $3 }'` UNIXPID=`echo $LINE | awk '{ print $2 }'` #echo $SIDNAME $CPUTIME $UNIXPID export ORACLE_SID=$SIDNAME SIDNAME=`echo $ORACLE_SID | cut -c4-6` export ORACLE_HOME=`/dba_script/bin/find_ohome.sh ${ORACLE_SID}` export SHLIB_PATH=$ORACLE_HOME/lib:/usr/lib export TMPDIR=/tmp export LD_LIBRARY_PATH=$ORACLE_HOME/lib export SQLPLUS="$ORACLE_HOME/bin/sqlplus -s / " $SQLPLUS >> $wlogfile <