Sunday, June 28, 2009

Unix For DBA

terkadang kita bingung dalam environtment unix server, script atau
tool apa saja siich yang harus di gunakan untuk kepentingan monitoring
server terkait dengan oracle database, saya sedikit share yang mudah2an membantu

Virtual memory Usage
$ vmstat 5 3

CPU Usage
$ sar -u 10 8

$ mpstat 10 2
Reports per-processor statistics on Sun Solaris (10 seconds apart; 2 times):

$ ps -e -o pcpu -o pid -o user -o args | sort -k 1 | tail -21r
Displays the top 20 CPU users on the system

display top cpu consumers
$ps -ef|sort +6|tail

cpu currently usage by each process in %
$ps auxgw|sort +2|tail

display server device values in HP-UX
$ lsdev -C

display system kernel on HP-UX
$kmtune


on AIX :
$lsattr -El sys0

display ram size on unix

uerf -r 300|grep -i mem

display ram size on HP

using $glance or $sar

display ram size on solaris

$prtconf|grep -i mem

on Aix

$lsdev -C|grep -i mem
output :
mem0 available 00-00
$lsattr -El mem0

on AIX mem Utilization :
#svmon

Display Allocated Memory Segments :
$ ipcs -pmb

================================ CPU number

Display the Number of CPUs
AIX
lsdev -C|grep Process|wc -l
Solaris
psrinfo -v|grep "Status of processor"|wc -l
to see detail cpu
psrinfo -v

Count Used Semaphores
on HP-UX
kmtune|grep sem
semaphores to be used
ipcs -sa|grep oracle

===============================================
Show Server Log in HP-UX
$ grep error /var/adm/syslog/syslog.log|more

Show Server Log in AIX
$ errpt -a|more

IO stat
#iostat 3
using >> pstack







1 comment: