(1) Find all SQL files that contain “dba” pattern in current directory. find . -name “*sql” -print | xargs grep -i “dba” (2) script to kill all Oracle background processes for a database. This is a common Unix script used by Oracle DBAs when a database is locked up, and Server Manager cannot be used…
# 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
