OraDebug

관련링크	http://wiki.ex-em.com/index.php/Oradebug
주의	Sqlplus 원격 접속 사용하지 말것 - x-window, telent으로 실행할 것 sysdba 사용 권한 있어야 함
명령	Sys> oradebug --- sys> oradebug help sys> oradebug unlimit <-- debug 덤프파일 크기 무제한(process를 추적할때)
사용예 ==session trace	sys> select pid from v$process where addr= 2 (select paddr from v$session where username='SCOTT'); 22 sys> oradebug setorapid 22 sys> oradebug unlimit sys> oradebug event 10046 trace name context forever, level 8 oradebug event 10046 trace name context off Statement processed. SQL> oradebug tracefile_name /u01/app/oracle/admin/orcl/udump/orcl_ora_3777.trc SQL> ! [oracle@edrsr4p1 ~]$ vi /u01/app/oracle/admin/orcl/udump/orcl_ora_3777.trc [oracle@edrsr4p1 ~]$ [oracle@edrsr4p1 ~]$ tkprof /u01/app/oracle/admin/orcl/udump/orcl_ora_3777.trc out.txt
사용예-instance	SQL> oradebug SETMYPID Statement processed. SQL> oradebug dump heapdump 2 Statement processed. SQL> oradebug TRACEFILE_NAME /u01/app/oracle/admin/orcl/udump/orcl_ora_5563.trc SQL> ! vi /u01/app/oracle/admin/orcl/udump/orcl_ora_5563.trc
옵션정보	event SGA, PGA, library cache, row cache, buffers, enqueue, latch, heap, hanganalyze Level 내용 Header only Brief Block Full Block Block 1 2 3 + lru 4 5 6 + users/waiters 8 9 10