"오라클 trace 로그"의 두 판 사이의 차이
DB CAFE
(새 문서: == trace 로그 == <source lang=sql> -- trace,incident,cdump 위치 SELECT * FROM V$DIAG_INFO -- WHERE NAME LIKE 'Diag%' ; </source> Diag Trace /oracle/app/oracle/dia...) |
|||
7번째 줄: | 7번째 줄: | ||
; | ; | ||
</source> | </source> | ||
− | + | <PRE> | |
Diag Trace /oracle/app/oracle/diag/rdbms/SID/XXXX/trace | Diag Trace /oracle/app/oracle/diag/rdbms/SID/XXXX/trace | ||
Diag Alert /oracle/app/oracle/diag/rdbms/SID/XXXX/alert | Diag Alert /oracle/app/oracle/diag/rdbms/SID/XXXX/alert | ||
Diag Incident /oracle/app/oracle/diag/rdbms/SID/XXXX/incident | Diag Incident /oracle/app/oracle/diag/rdbms/SID/XXXX/incident | ||
Diag Cdump /oracle/app/oracle/diag/rdbms/SID/XXXX/cdump | Diag Cdump /oracle/app/oracle/diag/rdbms/SID/XXXX/cdump | ||
+ | </PRE> |
2019년 11월 19일 (화) 14:07 판
thumb_up 추천메뉴 바로가기
- DBA { Oracle DBA 명령어 > DBA 초급 과정 > DBA 고급 과정 }
- 튜닝 { 오라클 튜닝 목록 }
- 모델링 { 데이터 모델링 가이드 }
trace 로그[편집]
-- trace,incident,cdump 위치
SELECT *
FROM V$DIAG_INFO
-- WHERE NAME LIKE 'Diag%'
;
Diag Trace /oracle/app/oracle/diag/rdbms/SID/XXXX/trace Diag Alert /oracle/app/oracle/diag/rdbms/SID/XXXX/alert Diag Incident /oracle/app/oracle/diag/rdbms/SID/XXXX/incident Diag Cdump /oracle/app/oracle/diag/rdbms/SID/XXXX/cdump