Items (391) 썸네일형 리스트형 HangAnalyze 3 SQL> oradebug hanganalyze 3 [ 3, 5, 10 ] Hang Analysis in /oracle/app/admin/EJD/udump/ejd_ora_2683086_SGA_with_level_2_SharedPoolDump.trc [level 5] : 4 node dumps -- [SINGLE_NODE] [SINGLE_NODE_NW] [IGN_DMP] [level 10] : 36 node dumps -- [IGN] *** 2011-07-31 02:48:40.154 ============== HANG ANALYSIS: ============== Open chains found: Other chains found: Chain 1 : : Chain 2 : : Chain 3 : : Chain 4.. Dump systemstate 2 SQL> oradebug dump systemstate 2 Statement processed. /oracle/app/admin/EJD/udump/ejd_ora_2683086_SYSTEM_STATE.trc Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, Data Mining and Real Application Testing options ORACLE_HOME = /oracle/app/product/102 System name:AIX Node name:EJUWED1 Release:3 Version:5 Machine:00C605A24C00 Instance name: EJD Re.. dump heapdump 536870914 (2 + 536870912) KGH Latch Directory Information 계속 반복되는 것 말고 별것이 없어 보인다. 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 /oracle/app/admin/EJD/udump/ejd_ora_2683086_SGA_TOP_5.trc Oracle .. Systemstate dumps Systemstate dumps A system state dump is trace file containing a snapshot of all processes running in a database. It is used to diagnose hang issues and has more information compared to a hanganalyze dump.There are various ways to dump the systemstate. If you can connect to the database you can dump it using SQL> oradebug setmypid Statement processed. SQL> oradebug unlimit this is important so.. 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. dump JAVA_POOL EJD@/oracle/app/admin/EJD/udump> exit SQL> oradebug setmypid Statement processed. SQL> oradebug unlimit Statement processed. SQL> alter session set tracefile_identifier='JAVA_POOL'; Session altered. SQL> oradebug dump heapdump 128 Statement processed. SQL> oradebug close_trace Statement processed. SQL> host EJD@/oracle/app/admin/EJD/udump> ls /oracle/app/admin/EJD/udump/ejd_ora_2683086_JAVA_POOL.. Dump PGA_UGA /oracle/app/admin/EJD/udump/ejd_ora_2093200_PGA_UGA.trc *** TRACE DUMP CONTINUED FROM FILE /oracle/app/admin/EJD/udump/ejd_ora_2093200.trc *** *** 2011-07-30 08:11:09.135 ****************************************************** HEAP DUMP heap name="session heap" desc=110456928 extent sz=0xff80 alt=32767 het=32767 rec=0 flg=2 opc=2 parent=110176e08 owner=70000008d981ef0 nex=0 xsz=0xff80 EXTENT 0 ad.. Dump Large Pool in SGA /oracle/app/admin/EJD/udump/ejd_ora_2093200_LARGE_POOL.trc Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, Data Mining and Real Application Testing options ORACLE_HOME = /oracle/app/product/102 System name: AIX Node name: EJUWED1 Release: 3 Version: 5 Machine: 00C605A24C00 Instance name: EJD Redo thread mounted by this instance: 1 Oracle proces.. 이전 1 ··· 36 37 38 39 40 41 42 ··· 49 다음