$ ps -ef | grep pmon
oracle 4000 1 0 13:02 ? 00:00:00 ora_pmon_orcl
SQL> oradebug SETOSPID 4000
Oracle pid: 2, Unix process pid: 4000, image: oracle@linuxtest01 (PMON)
SQL> oradebug CORE
Statement processed.
SQL> show parameter core_dump_dest
NAME TYPE VALUE
core_dump_dest string /u01/app/oracle/diag/rdbms/orcl/orcl/cdump
SQL> !ls /u01/app/oracle/diag/rdbms/orcl/orcl/cdump
core_4000
SQL> !ls -l /u01/app/oracle/diag/rdbms/orcl/orcl/cdump/core_4000
total 2816
-rw------- 1 oracle oinstall 5226496 Aug 14 13:09 core.4226
然后用gdb分析,或者给供应商去深度分析
收起