ORACLE - Linux

Linux Utility:

TOP
top : example -

top - 16:10:43 up 18 days,  4:03,  6 users,  load average: 0.00, 0.04, 0.05
Tasks: 253 total,   2 running, 251 sleeping,   0 stopped,   0 zombie
Cpu(s):  3.2%us,  1.2%sy,  0.0%ni, 95.5%id,  0.1%wa,  0.0%hi,  0.0%si,  0.0%st
Mem:   8186944k total,  7507860k used,   679084k free,   121516k buffers
Swap:  8388600k total,   878620k used,  7509980k free,  5440128k cached

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
27368 oracle    20   0 2635m 211m 201m R  7.6  2.7   0:08.36 oracle
30508 root      20   0 17276 1348  920 S  0.7  0.0   0:00.05 top

iostat :  reports CPU, disk I/O, and NFS statistics
>iostat
Linux 2.6.39-200.24.1.el6uek.x86_64 (hqmidb02)  01/29/2013      _x86_64_        (4 CPU)
avg-cpu:  %user   %nice %system %iowait  %steal   %idle
           1.93    0.05    0.60   12.20    0.00   85.22
Device:            tps   Blk_read/s   Blk_wrtn/s   Blk_read   Blk_wrtn
sda              31.64      2797.05      2908.67 4393977081 4569325965
sdb              63.58      3913.73      2626.79 6148215412 4126514780
dm-0             63.58      3913.73      2626.79 6148211845 4126514780

vmstat : reports virtual memory statistics
> vmstat
procs -----------memory---------- ---swap-- -----io---- --system-- -----cpu-----
 r  b   swpd   free   buff  cache   si   so    bi    bo   in   cs us sy id wa st
 0  0 878624 703044 122140 5426164    0    1   840   692    4    2  2  1 85 12  0


mpstat – Display cpu statistics of individual cpu/core

> mpstat -P ALL
Linux 2.6.39-200.24.1.el6uek.x86_64 (testdb02)  01/29/2013      _x86_64_        (4 CPU)
04:15:22 PM  CPU    %usr   %nice    %sys %iowait    %irq   %soft  %steal  %guest   %idle
04:15:22 PM  all    1.93    0.05    0.58   12.21    0.00    0.02    0.00    0.00   85.21
04:15:22 PM    0    2.23    0.04    0.54   15.83    0.00    0.02    0.00    0.00   81.33
04:15:22 PM    1    2.25    0.04    0.56   15.73    0.00    0.02    0.00    0.00   81.41
04:15:22 PM    2    1.59    0.07    0.60    8.59    0.00    0.02    0.00    0.00   89.14
04:15:22 PM    3    1.65    0.06    0.62    8.69    0.00    0.01    0.00    0.00   88.97

mpstat -P 0 : To display statistics information of a particular cpu

Check multipathing:
hqmidb02 temp-db-bkup $ sudo /sbin/multipath -ll
mpath1 (360a98000486e5865465a6e344e427058) dm-0 NETAPP,LUN
size=1022G features='3 queue_if_no_path pg_init_retries 50' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=4 status=active
  `- 0:0:3:0 sdd 8:48 active ready running
mpathd (360a98000486e5865465a70446e4e6164) dm-3 NETAPP,LUN
size=200G features='3 queue_if_no_path pg_init_retries 50' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=4 status=active
  `- 0:0:3:1 sdg 8:96 active ready running
mpathc (3600601603d410f0028ae7c5e2879dd11) dm-2 DGC,RAID 5
size=174G features='1 queue_if_no_path' hwhandler='1 emc' wp=rw
|-+- policy='round-robin 0' prio=1 status=active
| `- 0:0:4:0 sde 8:64 active ready running
`-+- policy='round-robin 0' prio=0 status=enabled
  `- 0:0:2:0 sdc 8:32 active ready running
mpathb (36006016078a1120016ce23afb7b1dd11) dm-1 DGC,RAID 5
size=695G features='1 queue_if_no_path' hwhandler='1 emc' wp=rw
|-+- policy='round-robin 0' prio=1 status=active
| `- 0:0:0:0 sda 8:0  active ready running
`-+- policy='round-robin 0' prio=0 status=enabled
  `- 0:0:1:0 sdb 8:16 active ready running

Checking netstat :
# netstat -in
IPv4:
Name      Mtu  Network         Address         Ipkts   Ierrs Opkts   Oerrs Coll
lan3      1500 172.16.1.208    172.16.1.211    11253193 0     5803471 0     0  
lan1:1    1500 10.20.188.0     10.20.188.29    458846207 0     4936    0     0  
lan1      1500 10.20.188.0     10.20.188.28    1878306228 7     2033507389 0     0  
lo0       4136 127.0.0.0       127.0.0.1       136644525 0     136644147 0     0  
lan7      1500 172.16.1.8      172.16.1.10     11217800 0     5771345 0     0  
lan5*     1500 none            none            31236   0     97824   0     0  
lan901    1500 172.16.1.0      172.16.1.2      3352355011 0     781342961 0     0  
lan4      1500 10.0.1.0        10.0.1.10       563999056 0     563158801 0     0  
lan900    1500 172.22.14.0     172.22.14.25    988494814 0     4141010767 0     0