Oracle DBA on Linux

zie http://www.oracle-base.com/articles/misc/unix-for-dbas.php

 

TOP

top: gebruik de pid column van een os-process om bijbehorende query te identificeren

SELECT a.username, 
       a.osuser, 
       a.program, 
       spid, 
       sid, 
       a.serial#
FROM   v$session a,
       v$process b
WHERE  a.paddr = b.addr
AND    spid = '&pid';

 SAR

• CPU:
  
  • Basic CPU: sar [-u] [interval [count]]
  • Load Average: sar -q [interval [count]]
• Memory:
  
  • Kernel Paging: sar -B [interval [count]]
  • Unused Memory: sar -r [interval [count]]
  • Swap Space: sar -S [interval [count]]
• Disk:
  
  • Average Disk I/O: sar -b [interval [count]]
  • Disk I/O: sar -dp [interval [count]]
• Network:
  
  • Network: sar -n DEV [interval [count]]
  • Network Errors: sar -n EDEV [interval [count]]