Rule of Thumb for Estimating Concurrent DB Connections on a 24-Core Machine (Single Thread Each) The number of concurrent database connections a 24-core machine can handle depends on various factors, including: Hypothetical Calculation Based on CPU A single-threaded, single-core system can typically handle 2-10 concurrent active queries (depending on execution time and parallelism). For a…
Following script will be useful for tracking Oracle GoldenGate replicat process and related lag. This script will generate output on standard screen. You can redirect it using file redirection to logfile or other locations. while true do <goldengate home directory>/ggsci <<EOF > test.out info all exit EOF lag=`cat test.out | grep TESTREPLICAT | awk ‘{print…
Following script will help to collect CPU based on on every SAMPLE_TIME. This will help to collect IDLE CPU our from “vmstat” and store them in a file. #Setup SAMPLE_TIME for cpu data collection interval SAMPLE_TIME=5 while true do x=`vmstat | grep -v procs | grep -v swpd | awk ‘{print $15}’` echo `date +”%m-%d-%y…
Read More “How to collect CPU usage on Linux using Shell script” »
less /proc/cpuinfo
To get cpu speed, use psrinfo -v psrinfo -v Status of virtual processor 0 as of: 12/10/2010 11:33:07 on-line since 08/01/2010 15:55:44. The sparcv9 processor operates at 1800 MHz, and has a sparcv9 floating point processor. Status of virtual processor 1 as of: 12/10/2010 11:33:07 on-line since 08/01/2010 15:55:50. The sparcv9 processor operates at 1800…
cat test1 | egrep ‘TNS-|Client address’ | sed -e ‘s/^.*HOST/HOST/’
fuser -cu /directory_name
Seeing kernel version (32/64 Bit) on Unix flavors. -isainfo -kv on Solaris -lsconf on AIX -uname -a on Linux to See configuration -prtdiag on Solaris -lsconf on AIX -dmidecode on Linux Other useful Unix commands: Disk usage. # df -al Memory information. # free Network information. # ifconfig -a Installed Modules information. #lsmod Currently mounted…
#!/bin/ksh typeset -L30 fieldA typeset -R15 fieldB fieldA=”Paresh” fieldB=”Vatti” echo “${fieldA}${fieldB}”
oracle@dbmonitor*-/export/home/oracle/paresh ==>echo `sum 1.sh` 4206 1 1.sh oracle@dbmonitor*-/export/home/oracle/paresh ==>echo `sum 1.sh` | awk ‘{print $1}’ 4206 oracle@dbmonitor*-/export/home/oracle/paresh ==>echo `sum 1.sh` | awk ‘{print $2}’ 1 oracle@dbmonitor*-/export/home/oracle/paresh ==>
