본문 바로가기

Oracle Wait Interface

Dump SGA level 2

SQL> oradebug setmypid
Statement processed.
SQL> oradebug unlimi
ORA-00070: command unlimi is not valid
SQL> oradebug unlimit
Statement processed.
SQL> alter session set tracefile_identifier = 'SGA_TOP_5';

Session altered.

SQL> oradebug dump heapdump 536870914
Statement processed.
SQL> oradebug close_trace
Statement processed.

'Oracle Wait Interface' 카테고리의 다른 글

buffer is pinned count  (0) 2014.02.07
조동욱 님의 OWI (Oracle Wait Interface)  (0) 2011.08.04
HangAnalyze 3  (1) 2011.07.31
Systemstate dumps  (0) 2011.07.31