[oradebug 사용법 – 2]
1. oradebug resume
일시 중지된 프로세스를 재시작
SQL> oradebug resume
2. oradebug flush
메모리에 있는 정보를 Trace 파일에 Write
3. oradebug close_trace
프로세스가 잡고 있던 트레이스 파일 close
4. oradebug lkdebug
리소스 리마스터링 직접수행
5. oradebug nsdbx
Cluster Group Services (CGS) name-service debugger로 ORADEBUG 유틸리티
Usage:nsdbx [options]
-h Help
-p <owner> <namespace> <key> <value> <nowait> Publish a name-entry
-d <owner> <namespace> <key> <nowait> Delete a name-entry
-q <namespace> <key> Query a namespace
-an <namespace> Print all entries in namespace
-ae Print all entries
-as Print all namespaces
6. oradebug -G
패러럴 오라디버그 명령어
EX) oradebug -g def event 10706 trace name context forever, level 10
7. oradebug setinst
인스턴스 설정
EX)
SQL> select * from v$active_instances;
INST_NUMBER INST_NAME
———– ———————————
1 alpha:test1
2 beta:test2
3 omega:test3
SQL> oradebug setinst “1”,”2″,”3″
Statement processed.
SQL> oradebug setinst all
Statement processed.
8. oradebug sgatofile
SGA를 파일로 덤프
9. oradebug hanganalyze
시스템 Hang 분석
EX)
ORADEBUG setmypid
ORADEBUG setinst all
ORADEBUG -g def hanganalyze <level>
[LEVEL]
1-2 Only HANGANALYZE output, no process dump at all
3 Level 2 + Dump only processes thought to be in a hang (IN_HANG state)
4 Level 3 + Dump leaf nodes (blockers) in wait chains (LEAF,LEAF_NW,IGN_DMP state)
5 Level 4 + Dump all processes involved in wait chains (NLEAF state)
10 Dump all processes (IGN state)