1. hang dump
-- rac
sqlplus / as sysdba > /tmp/hangdump << EOF
set linsize 140
oradebug setmypid
oradebug setinst all
oradebug -g def hanganalyze 3
exit
EOF
/tmp/hangdump 내용 검토
-- single
sqlplus / as sysdba > /tmp/hangdump << EOF
set linsize 140
oradebug setmypid
oradebug hanganalyze 3
exit
EOF
/tmp/hangdump 내용 검토
2. sysdump
-- rac
sqlplus / as sysdba > /tmp/systemdump << EOF
set linsize 140
oradebug setmypid
oradebug unlimit
oradebug -g def dump systemstate 10
oradebug tracefile_name
exit
EOF
/tmp/systemdump 내용 검토
--single
sqlplus / as sysdba > /tmp/systemdump << EOF
set linsize 140
oradebug setmypid
oradebug unlimit
oradebug dump systemstate 10
oradebug tracefile_name
exit
EOF
/tmp/systemdump 내용 검토
'RDB > Oracle' 카테고리의 다른 글
| oracle 18c 기능 (0) | 2018.11.15 |
|---|---|
| oracle db compatibility jdbc version (0) | 2018.10.04 |
| oracle snapshot 관리 (0) | 2018.09.18 |
| oracle 12c rac scm0 프로세스 (0) | 2018.09.13 |
| awr 테이블 데이터 지우기 (0) | 2018.09.06 |