Useful Unix Command for Oracle DBA.

CPU

• How many CPU  has your server :

mpstat |tail +2 | wc -l

uname -X | grep CPU

• Details about CPU :

psrinfo -v
kstat cpu_info 

• Number of cores :

kstat cpu_info | egrep core_id | awk '{ print $2}' | uniq | wc -l

• Use of CPU :

prstat -a
prstat -U OracleUser

• Old fashion version of top ten of CPU consumer :

/usr/ucb/ps auxwww | head -11

• How many bit: 32 or 64?

/bin/isainfo -kv



Memory

• Memory Size Server

/usr/sbin/prtconf | grep "Memory size"

• Free Memory 

/usr/bin/vmstat 1 2| tail -1 | awk '{ print "Free Memory: " $5/1024 , "MB" }'



Disk I/O

•  Displays the amount of used and available space

df -h

•  Displays the amount of used and available inodos

df -o i .

•  Blocksize filesystem

df -g .