Wednesday, July 29, 2009

CPU Utilization check

1) % ulimit -Sa ,SVMON,

2)CPU utilization
OS Command
~~~~~~~~~~ ~~~~~~~~~
Sun Solaris: sar -u
IBM: ps av (or) iostat 3 20
Digital: /usr/sbin/pset_info
Linux: xosview

In addition of monitoring the CPU usage you should monitor the runqueue to determine if
processes are waiting for an available processor.
You can use "sar -q" to monitor the runqueue.

3)CPU usage by processor
To see how much CPU time is being used by each processor on a multiprocessor machine:
OS Command
~~~~~~~~~~ ~~~~~~~~~
Sun Solaris: /usr/bin/mpstat
HP: /usr/sbin/sar -M 5 5
IBM: vmstat -> Under cpu, if "us" is a very high number you have a cpu intensive process

4)Number of CPU's
To see the number of CPUs there are in the machine, and their status:
OS Command
~~~~~~~~~~ ~~~~~~~~~
Sun Solaris: /usr/sbin/mpstat
HP: /usr/sbin/sar -M 2 2
IBM: /usr/sbin/bindprocessor -q
Digital: /usr/sbin/psrinfo -v
Linux: xosview
5)Swap space
To see the amount of swap space is on the machine and the usage:
OS Command
~~~~~~~~~~ ~~~~~~~~~
Sun Solaris: /etc/swap -l and /etc/swap -s
HP: /etc/swapinfo -m ( must be root Unix id)
IBM: lsps -a
Digital: /usr/sbin/swapon -s
Linux: free -t
6)Shared memory
To see the current usage of shared memory & semaphores:
"ipcs -b"

user level export and import

expdp parfile=PLCT170.par oracle@uslp123sd7dfcvxsza > more PLCT050.par userid= "/ as sysdba" dumpfile=T050.dmp logfile=expdpT0...