AskDba.org Weblog

We intend to keep this page as easy reference for Unix commands/links which are useful to DBA in day – day work.  If you too have some command’s which can be useful , then you can use the comment’s section to add it and we will include in main page after cross-checking it. In case there are any corrections, then also let us know.

These commands will be categorised into Generic, AIX, Solaris, Linux and HP-UX.

AIX

Number of Cpu’s

$/usr/sbin/lsdev -C -c processor -S Available| wc -l

Memory Details

$/usr/sbin/lsattr -E -l sys0 -a realmem

Swap Configured

$/usr/sbin/lsps -a

To find maximum processes allowed and change it to 10000

$lsattr -El sys0 -a maxuproc
#chdev -l sys0 -a maxuproc='10000'

Find memory utilization by process on AIX

ps axwv | awk '{t=t+$7 - $10 ;print $7 - $10,$1,$11,$12,$13}END{print t}' | sort -rn | pg

Script for Monitoring memory just like vmstat
===============================================
copy the contents in file like mem_mon.sh

### Usage mem_mon.sh (interval) (occurences) e.g sh mem_mon.sh 2 10 ###
### This will give top 10 memory consuming processes #####
wt_time=$1
lmt=$2
 let a=0
while [[ $a -lt $lmt ]] ; do
ps axwv |sort -nrk 7,7|grep -v "COMMAND" \
|awk 'BEGIN {printf ("MemoryinKb \t ProcessId \t PerCPU \t PerMem \t Command \n")}{t=t+$7 - $10 ;printf("%13d \t %10d \t %6.2f \t %6.2f \t %s \n",$7 - $10,$1,$11,$12,$13)}END{print t}'|head -10
 let      a+=1
sleep $wt_time
done

HP-UX

Number of Cpu’s

$/usr/sbin/ioscan -kfnC processor | grep processor | wc -l

Memory Details

$grep -i Physical: /var/adm/syslog/syslog.log

Swap Configured

$/usr/sbin/swapinfo -a -m

Nic configuration

lanscan -v

Linux
Check number of CPU’s

$cat /proc/cpuinfo

Check memory information

cat /proc/meminfo

Check swap

$swapon -s

Kernel parameter

#/sbin/sysctl -a
cat /etc/sysctl.conf

System error log

/var/log/messages

Nic configuration

ifconfig -a

Useful Links-

Linux file and related commands - http://www.oracle.com/technology/pub/articles/advanced-linux-commands/part1.html

Top,find and snice commands – http://www.oracle.com/technology/pub/articles/advanced-linux-commands/part2.html

free,vmstat,iostat and sar – http://www.oracle.com/technology/pub/articles/advanced-linux-commands/part3.html

ifconfig,netstat (network commands)  - http://www.oracle.com/technology/pub/articles/advanced-linux-commands/part4.html

cpio,tar and Oracle VM – http://www.oracle.com/technology/pub/articles/advanced-linux-commands/part5.html

Solaris

Check number of CPU’s

/usr/sbin/psrinfo -v

Check kernel version

isainfo -kv

Display Swap size

swap -l

List kernel parameters

sysdef -i

List Installed packages

#pkginfo

Nic configuration

ifconfig -a

Generic

Awk Tutorial – http://www.vectorsite.net/tsawk.html

Sed & Awk (Oreilly ebook) – http://docstore.mik.ua/orelly/unix/sedawk/index.htm