# Exit if no first parameter $1. if [ -z “$1” ] then echo “Usage: check_parms.ksh (where value is > 100)” exit 99 fi # Exit if no second parameter $2. if [ -z “$2” ] then echo “Usage: check_parms.ksh (where value is > 100)” exit 99 fi # Exit if parm is not greater…
Read More “Logic to chech # of parameters command line parameters” »
dbaltxprod51->WEBP18F@(/oracle/app/oracle/admin/WEBP18F/bdump/BACKUP)egrep -i “INSERT” /tmp/v1aa|awk -F”trc” ‘{print $2}’|sort |uniq -c dbaltxprod51->WEBP18F@(/oracle/app/oracle/admin/WEBP18F/bdump/BACKUP)egrep -i “Select” /tmp/v1aa|awk -F””trc ‘{print $2}’|sort |uniq -c|sort -nr dbaltxprod51->WEBP18F@(/oracle/app/oracle/admin/WEBP18F/bdump/BACKUP)egrep -i “Select” /tmp/v1aa|awk -F”:” ‘{print $2}’|sort |uniq -c|sort -nr dbaltxprod51->WEBP18F@(/oracle/app/oracle/admin/WEBP18F/bdump/BACKUP)egrep -i “Select” /tmp/v1aa|awk ‘{print $2}’|more|sort |uniq -c dbaltxprod51->WEBP18F@(/oracle/app/oracle/admin/WEBP18F/bdump/BACKUP)egrep -i “Delete” /tmp/v1aa|awk ‘{print $2}’|more|sort |uniq -c dbaltxprod51->WEBP18F@(/oracle/app/oracle/admin/WEBP18F/bdump/BACKUP)egrep -i “Update” /tmp/v1aa|awk ‘{print $2}’|more|sort |uniq -c dbaltxprod51->WEBP18F@(/oracle/app/oracle/admin/WEBP18F/bdump/BACKUP) dbaltxprod51->WEBP18F@(/oracle/app/oracle/admin/WEBP18F/bdump/BACKUP)egrep…
Read More “Vivek’s egrep commands to trace problem. (on linux x86-64)” »
SQL> !mpstat Linux 2.6.9-34.ELsmp (dbaltxprod51) 09/12/2006 05:45:41 PM CPU %user %nice %system %iowait %irq %soft %idle intr/s 05:45:41 PM all 1.34 0.00 4.17 0.47 0.02 0.11 93.89 1413.67 SQL> !vmstat procs ———–memory———- —swap– —–io—- –system– —-cpu—- r b swpd free buff cache si so bi bo in cs us sy id wa 7 0 86476…
http://www.dbspecialists.com/presentations/oracle10glinux.html
The following commands can be used to identify the processor architecture on your database server: $ uname -m $ grep “model name” /proc/cpuinfo
dbaltxprod51->WEBP18F@(/home/oracle/paresh)ipcs -l —— Shared Memory Limits ——– max number of segments = 4096 max seg size (kbytes) = 4002706 max total shared memory (kbytes) = 8388608 min seg size (bytes) = 1 —— Semaphore Limits ——– max number of arrays = 128 max semaphores per array = 250 max semaphores system wide = 32000 max…
SHMMAX = The maximum size(in bytes) of a single shared memory segment. SHMMIN = The minimum size(in bytes) of a single shared memory segment. The above settings let the max be bigger then we wil ever use and the min much smaller. They are sufficient for pretty much all systems. SHMMNI = The number of…
Read More “Kernel Parameter setting explaination for Processes Parameter” »
#!/usr/bin/ksh ########## Configuration ############# ENV_FILE=$1
. $ENV_FILE echo “Started test.ksh `date +%D-%T`” V1=1; V3=One; $ORACLE_HOME/bin/sqlplus pvm/pvm
To search and replace between line1 and line2 use following: (*) This is vi editor command: following command will serach and replace whole file. (this is default with %s). :line1,$ s/old_string/new_string/g following command will search and replace only in specific lines: :line1,line2 s/old_string/new_string/g for example, :3,5 s/CIF/UOC/g above command will replace CIF with UOC in…
