topic stack trace for particular Oracle process. in Operating System - HP-UX

stack trace for particular Oracle process.

James Hunt — Tue, 24 Apr 2007 04:02:37 GMT

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.

Re: stack trace for particular Oracle process.

Steven E. Protter — Tue, 24 Apr 2007 04:06:25 GMT

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

Re: stack trace for particular Oracle process.

Dennis Handly — Tue, 24 Apr 2007 04:33:13 GMT

>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

Re: stack trace for particular Oracle process.

James Hunt — Tue, 24 Apr 2007 04:37:56 GMT

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

Re: stack trace for particular Oracle process.

Dennis Handly — Tue, 28 Aug 2007 21:12:16 GMT

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