原来那个找不到文件的问题,今天咨询了熊哥,
SQL> oradebug setospid 578038
Oracle pid: 3, Unix process pid: 578038, image: oracle@orasrva (DIAG)
SQL> oradebug close_trace
Statement processed.
SQL> oradebug setinst all
Statement processed.
SQL> oradebug -g def hanganalyze 3
Hang Analysis in /oracle/admin/sptdi/bdump/sptdi1_diag_578038.trc
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options
$ tail -10 /oracle/admin/sptdi/bdump/sptdi1_diag_578038.trc
END OF HANG ANALYSIS
====================
PORADATA SERIAL:0 RINST:2 RDIAG:287516
PORADATA SERIAL:0 RINST:2 REMOTE EXEC OSPID:287516
PORADATA SERIAL:0 RINST:2 TRACEFILE:/oracle/admin/sptdi/bdump/sptdi2_diag_287516.trc
PORADATA SERIAL:0 RINST:2 DONE
session (kjzddbx) is about to end
session (kjzddbx) is about to end
Registered session (kjzddbx)[11][4][0][1] is cleaned up
Switch to long timeout for ipc polling
因为在一个实例期间,一个进程产生的日志文件的名字是一样的
而原来产生的那个文件被我删 除了,执行上面的步骤,文件就有了。
谢谢,熊哥。。
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/25099483/viewspace-714972/
,如需转载,请注明出处,否则将追究法律责任。