Category: Linux/Unix

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…

Read More “tuning commmand for cpu, ip and memory stats” »

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…

Read More “ipcs -l” »

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…

Read More “Search and replace editor command in vi” »

#!/usr/bin/ksh a=`ps -ef|grep “mv_iotto.ksh”|grep -v grep|wc -l` if [ $a -gt 2 ] then echo “Exiting because of more than 1 Moving archive log script is running ” exit fi for fname in `ls -rlt /tmpdb2/oradata/UOCIOTTO_ARCH/*.arc | awk ‘{print $9}’ | sed ‘$d’ | sed ‘$d’` do print “”; print “File Name : $fname “;…

Read More “Follwoing korn shell is used to move files from source folder to destination folder and gzip it in destination folder. mv_iotto.ksh” »