在各个操作系统上有哪些工具可以跟踪oracle进程

郑全

如题.

郑全

[oracle@dbserver trace]$ ps -ef|grep LOCAL=NO
oracle   17322     1  0 14:30 ?        00:00:00 oraclesztech1 (LOCAL=NO)
oracle   17324  5167  0 14:30 pts/1    00:00:00 grep LOCAL=NO
[oracle@dbserver trace]$ pstack  17322
#1  0x00481ad3 in __read_nocancel () from /lib/libpthread.so.0
#2  0x100f0ed3 in snttread ()
#3  0x100f0052 in nttfprd ()
#4  0x100d13b1 in nsbasic_brc ()
#5  0x100d441e in nsbrecv ()
#6  0x100dc371 in nioqrc ()
#7  0x0fde4a7a in opikndf2 ()
#8  0x092d0eb3 in opitsk ()
#9  0x092d4e7f in opiino ()
#10 0x0fde73a2 in opiodr ()
#11 0x092cd643 in opidrv ()
#12 0x097d578c in sou2o ()
#13 0x0856f2eb in opimai_real ()
#14 0x097dae7a in ssthrdmain ()
#15 0x0856f267 in main ()

郑全

gdb 在linux下可以使用:

 

$ gdb $ORACLE_HOME/bin/oracle 随便一个进程号

 

(gdb) print ksudss(10)

 

(gdb) detach

 

(gdb) quit

 

之后,就可以在$ORACLE_BASE/diag/rdbms/db_name/instance_name/trace/下找到trace文件了. 

郑全

gdb

dbx

strace

truss

pstack

procstack

等