stack trace for particular Oracle process.

[James Hunt]

Is there anyway that you can debug/create a stack trace for a certain process id on a server?
Oracle need the stack trace for one of our processes that has gone crazy.

PSTACK looks like it would have done the trick but we're running hpux11i.

many thanks.

[Steven E. Protter]

Shalom,

tusc is a pretty good tool.

http://hpux.cs.utah.edu/hppd/hpux/Sysadmin/tusc-7.8/

HP has stable and binary forms of it as well.

SEP

[Dennis Handly]

>but we're running hpux11i.

You need to be more specific, 11i v1?
(You can never go wrong with saying B.11.??. :-) And whether PA or Integrity.

>SEP: tusc is a pretty good tool.

This is useless for stack tracing, tusc will only give system calls.

If you aren't on 11.31, you can use gdb to attach to the process then you use "bt" to get a stack trace:
# gdb oracle-binary oracle-PID
(gdb) bt
(gdb) detach
(gdb) q

[James Hunt]

sorry,
yep, were running 11i v1. PA RISC.

[Dennis Handly]

pstack and pldd are now there on 11.23 for IPF in the latest linker patches.