Category: shell

# log listener # # MIOLIST=alert_$ORACLE_SID.log_`date ‘+%y%m%d%H’` lsnrctl

Kishore said if you are seeing any CPU wait, most probably that is because of DISK I/O. iostat -c 5 Thanks Paresh

iostat -pnxze 5

/********* session_info.ksh ****************/ #!/bin/ksh . /home/oracle/oraprocs/WEBP18F.env USR_ID=vivek USR_PASS=viv1ek database=WEBP18F a=`ps -ef|grep “session_info.ksh”|grep -v grep|wc -l` if [ $a -gt 4 ] then echo “Exiting because of more than 1 process is running `date`”>>/db3/oradata/log/session_info.log exit fi echo “—–Begin —– Date `date`——————————–” >> /db3/oradata/log/session_info.log $ORACLE_HOME/bin/sqlplus -s /db3/oradata/log/session_info.log $USR_ID/$USR_PASS@$database set serverout on set feedback off SET PAGES 0…

Read More “Session_info.ksh” »

#!/bin/ksh

#Description : This script will check whether free space is there for next extent allocation or not. #It checks TS level and OS level for extent allocation. Checks for UNIFORM allocated extents. #For system allocated extents. this script will check 1 GB should be there as free threshold. NODENAME1=`hostname` ORACLE_SID=WEBP18F LOG_FILE_DIR=/home/oracle/oraprocs/logs ENV_FILE=/home/oracle/oraprocs/WEBP18F.env #NOTIFY_LIST=’8774544468@skytel.com’,’8774537913@skytel.com’,’8666714349@skytel.com’,’8774538204@skytel.com’,’dbaoracle@1800flowers.com’,’8774889576@skytel.com’ NOTIFY_LIST=’pmehta@1800flowers.com’ ADMIN_USER=vivek…

Read More “chk_space_SID.ksh” »

. $ENV_FILE #sqlplus -silent / as sysdba

To Find Orphan OS processes. When a process run from command line its parent process id will be 1. Consider following example: In current session, we are executing SQLPLUS. whose process id = 22833 and parent is 22822. process 22822 is ksh. So this is not orphan process. if you find any process with parent…

Read More “To Find Orphan OS processes.” »