{"id":424,"date":"2015-09-02T08:39:56","date_gmt":"2015-09-02T08:39:56","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=424"},"modified":"2015-09-02T08:39:56","modified_gmt":"2015-09-02T08:39:56","slug":"oracle-dump-%eb%9c%a8%ea%b8%b0-%ec%8a%a4%ed%81%ac%eb%a6%bd%ed%8a%b8","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=424","title":{"rendered":"Oracle Dump \ub728\uae30 \uc2a4\ud06c\ub9bd\ud2b8"},"content":{"rendered":"<p>1. \ub364\ud504<\/p>\n<p>&nbsp;&nbsp;<\/p>\n<p>&nbsp; \ub364\ud504 : \uc77c\ud68c\uc131\uc73c\ub85c \uadf8 \uc21c\uac04\uc758 \uc0c1\ud0dc\uc815\ubcf4\ub97c \uac00\uc9d1\ub2c8\ub2e4.&nbsp;<\/p>\n<p>&nbsp; \ud2b8\ub808\uc774\uc2a4 : 10046, 10053 \ub4f1\uc758 \uc774\ubca4\ud2b8\ub97c \uac78\uac8c \ub418\uba74 \uc21c\uac04\uc758 \uc0c1\ud0dc(immediate) \ub610\ub294&nbsp;<\/p>\n<p>&nbsp; \uc138\uc158\uc774 close\ub420\ub54c\uae4c\uc9c0\uc758 \uc815\ubcf4(trace name context forever) \ub97c trace\ub85c&nbsp;<\/p>\n<p>&nbsp; \ub0a8\uae41\ub2c8\ub2e4.<\/p>\n<p>&nbsp; \ucc38\uace0\ub85c udump \uc5d0 \uc5c6\ub2e4\uace0 \ud574\uc11c \uace0\ubbfc\ud558\uc9c0 \ub9d0\uad6c\uc694. bdump\ub97c \ucc3e\uc544\ubcf4\uc138\uc694.&nbsp;<\/p>\n<p>&nbsp; background process\ub97c \uc774\uc6a9\ud574\uc11c dump\ub97c \ub728\ub294 \uacbd\uc6b0\uc5d0\ub294 bdump\uc5d0 \ub098\uc624\uaca0\uc8e0.<\/p>\n<p>&nbsp;<\/p>\n<p>2. \ubb38\uc81c\ubc1c\uc0dd\uc2dc \ub364\ud504 \ub728\ub294 \ubc29\ubc95&nbsp;<\/p>\n<p>&nbsp; \ubb38\uc81c\ubc1c\uc0dd \uc138\uc158\uc5d0 \ub300\ud55c 10046 event, truss output, errorstack dump&nbsp;<\/p>\n<p>&nbsp; OS engineer\uc758 system state dump&nbsp;<\/p>\n<p>&nbsp; system state dump 2~3\ud68c&nbsp;<\/p>\n<p>&nbsp; hang analyze dump 2~3\ud68c&nbsp;<\/p>\n<p>&nbsp; system state dump 1~2\ud68c&nbsp;<\/p>\n<p>&nbsp; hang analyze dump 1~2\ud68c<\/p>\n<p>&nbsp;<\/p>\n<p>3. \uc5d0\ub7ec\uc2a4\ud0dd \ub728\uae30(\uaf2d \uc218\ud589\ud560 \ub54c\ub9c8\ub2e4 exit\ub098\uc640\uc11c \ub2e4\uc2dc \uc11c\ubc84\uc5d0 \uc811\uc18d\ud574\uc11c \ub730 \uac83)&nbsp;<\/p>\n<p>&nbsp; oradebug setospid XX&nbsp;<\/p>\n<p>&nbsp; oradebug unlimit&nbsp;<\/p>\n<p>&nbsp; oradebug dump errorstack 3&nbsp;<\/p>\n<p>&nbsp; oradebug tracefile_name<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp; \ub610\ub294<\/p>\n<p>&nbsp; alter system set max_dump_file_size=unlimited;<\/p>\n<p>&nbsp; alter session set tracefile_identifier=&#8217;error1&#8242;;<\/p>\n<p>&nbsp; alter session set events &#8216;immediate trace name errorstack level 3&#8217;;&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>4. hanganalyze, systemstate dump \ub728\uae30(\uaf2d \uc218\ud589\ud560 \ub54c\ub9c8\ub2e4 exit\ub098\uc640\uc11c \ub2e4\uc2dc \uc11c\ubc84\uc5d0 \uc811\uc18d\ud574\uc11c \ub730 \uac83)&nbsp;<\/p>\n<p>&nbsp; &#8211; systemstate dump\ub294 database\uc758 \uc804\ubc18\uc801\uc778 hang\uc774\ub098 slow performance\uc0c1\ud669\uc5d0 \uc694\uad6c\ub41c\ub2e4.<\/p>\n<p>&nbsp; &nbsp; \ub610\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud574\uc11c \uc7ac\uae30\ub3d9\ud560 \ub54c\uc5d0 , \ucd94\ud6c4 \ubd84\uc11d\uc744 \uc704\ud574\uc11c \uc7ac\uae30\ub3d9 \uc804\uc5d0<\/p>\n<p>&nbsp; &nbsp; \uc801\uc808\ud55c systemstate dump\ub97c \ud655\ubcf4\ud55c\ub2e4.<\/p>\n<p>&nbsp; &nbsp; \ubcf4\ud1b5 system state dump\ub294 3~5\ubd84 \uac04\uaca9\uc73c\ub85c 3\ubc88 \uc218\ud589\uc744 \uad8c\uc7a5\ud558\ub294\ub370, \uc774 \ub54c \ub9e4\ubc88<\/p>\n<p>&nbsp; &nbsp; \uc0c8\ub85c\uc6b4 \uc811\uc18d\uc744 \ud574\uc57c \uac01\uac01\uc774 \uac01\uac01 \ub2e4\ub978 \ud30c\uc77c\uba85\uc73c\ub85c \uc0dd\uc131\ub41c\ub2e4.<\/p>\n<p>&nbsp; &nbsp; \uac19\uc740 \uc138\uc158\uc5d0\uc11c 3\ubc88 \uc218\ud589\ud558\uba74, \ud55c \ud30c\uc77c\uc5d0 \uc774\uc5b4\uc11c \uc0dd\uc131\ub41c\ub2e4.<\/p>\n<p>&nbsp; &#8211; hanganalyze dump\ub294 \ub9c8\ucc2c\uac00\uc9c0\ub85c hang\uc774\ub098 slow performance \uc0c1\ud669\uc5d0 \uc0ac\uc6a9\ub41c\ub2e4.<\/p>\n<p>&nbsp; &nbsp; \uadf8\ub7ec\ub098 hanganalyze dump\ub294 \ub9ac\uc18c\uc2a4(latch\/eueueue\ub4f1\ub4f1)\uc744 \uc810\uc720\ud558\ub294 blocker\ub97c<\/p>\n<p>&nbsp; &nbsp; \ubcf4\uc5ec\uc8fc\ubbc0\ub85c , \uc774 blocker\ub97c \uc815\ub9ac\ud568\uc73c\ub85c \ubb38\uc81c \ud574\uacb0\uc5d0 \uc811\uadfc\ud560 \uc218 \uc788\ub2e4.<\/p>\n<p>&nbsp; &nbsp;&nbsp;<\/p>\n<p>&nbsp; oradebug setmypid&nbsp;<\/p>\n<p>&nbsp; oradebug unlimit&nbsp;<\/p>\n<p>&nbsp; oradebug hanganalyze 4&nbsp;<\/p>\n<p>&nbsp;&nbsp;<\/p>\n<p>&nbsp; oradebug setmypid<\/p>\n<p>&nbsp; oradebug unlimit<\/p>\n<p>&nbsp; oradebug dump systemstate 10&nbsp;<\/p>\n<p>&nbsp;&nbsp;<\/p>\n<p>&nbsp; \ub610\ub294<\/p>\n<p>&nbsp; alter system set max_dump_file_size=unlimited;<\/p>\n<p>&nbsp; alter session set tracefile_identifier=&#8217;sys1&#8242;;<\/p>\n<p>&nbsp; alter session set events &#8216;immediate trace name systemstate level 10&#8217;;<\/p>\n<p>&nbsp;&nbsp;<\/p>\n<p>&nbsp; alter system set max_dump_file_size=unlimited;<\/p>\n<p>&nbsp; alter session set tracefile_identifier=&#8217;hang1&#8242;;<\/p>\n<p>&nbsp; alter session set events &#8216;immediate trace name hanganalyze level 4&#8217;;<\/p>\n<p>&nbsp;&nbsp;<\/p>\n<p>5. oradebug\ub85c event \uac78\uae30(10046 event\ub294 sql \ud2b8\ub808\uc774\uc2a4 \uc815\ubcf4, 10053\uc740 optimizer\uc5d0 \ub300\ud55c \ud2b8\ub808\uc774\uc2a4 \uc815\ubcf4)&nbsp;<\/p>\n<p>&nbsp; oradebug setospid XX&nbsp;<\/p>\n<p>&nbsp; oradebug unlimit&nbsp;<\/p>\n<p>&nbsp; oradebug event 10046 trace name context forever, level 12;&nbsp;<\/p>\n<p>&nbsp; oradebug event 10053 trace name context forever, level 1;&nbsp;<\/p>\n<p>&nbsp; oradebug tracefile_name&nbsp;<\/p>\n<p>&nbsp; oradebug event 10046 trace name context off;&nbsp;<\/p>\n<p>&nbsp; oradebug event 10053 trace name context off;<\/p>\n<p>&nbsp;<\/p>\n<p>6. \ubb38\uc81c\uac00 \uc788\ub294 \uc138\uc158\uc758 process state dump \ub728\uae30&nbsp;<\/p>\n<p>&nbsp; oradebug setospid &lt;process ID&gt;&nbsp;<\/p>\n<p>&nbsp; oradebug unlimit&nbsp;<\/p>\n<p>&nbsp; oradebug dump processstate 10<\/p>\n<p>&nbsp;<\/p>\n<p>7. \ud2b9\uc815 event\uac00 \ubc1c\uc0dd\ud560 \uacbd\uc6b0\uc5d0heap dump \ub728\uae30 ( 4031 \uc5d0\ub7ec\uc758 \uacbd\uc6b0 )<\/p>\n<p>&nbsp; init \ud30c\ub77c\ubbf8\ud130\uc5d0 event name \ud558\ub098\uc5d0 trace name\uc744 \uc5ec\ub7ec\uac1c\ub97c \uc0ac\uc6a9 &nbsp;\ud560 \uacbd\uc6b0 ; \ub97c \ubd99\uc784<\/p>\n<p>&nbsp; init \ud30c\ub77c\ubbf8\ud130\uc5d0 \uc5ec\ub7ec\uac1c event\ub97c \ubd99\uc77c \uacbd\uc6b0 : \uc744 \uc0ac\uc6a9\ud568<\/p>\n<p>&nbsp; &nbsp; &nbsp;<\/p>\n<p>&nbsp; event = &#8220;4031 trace name heapdump level 1;name errorstack level 3&#8221;<\/p>\n<p>&nbsp; \ub610\ub294 sqlplus\uc5d0\uc11c&nbsp;<\/p>\n<p>&nbsp; alter session set events &#8216;4031 trace name heapdump level 1<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ;name errorstack level 3&#8242;; &nbsp; &nbsp;&nbsp;<\/p>\n<p>&nbsp;&nbsp;<\/p>\n<p>8. \uc5f0\uc18d\uc801\uc73c\ub85c event\ub97c \ubd99\uc5b4 \ub123\uae30<\/p>\n<p>&nbsp; &nbsp;init \ud30c\ub77c\ubbf8\ud130&nbsp;<\/p>\n<p>&nbsp; &nbsp; &nbsp;event=&#8221;10015 trace name context forever&#8221;<\/p>\n<p>&nbsp; &nbsp; &nbsp;event=&#8221;10046 trace name context forever, level 4&#8243;<\/p>\n<p>&nbsp; &nbsp;\ub610\ub294<\/p>\n<p>&nbsp; &nbsp; &nbsp;event=&#8221;10015 trace name context forever:<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10046 trace name context forever, level 4&#8243;<\/p>\n<p>&nbsp; &nbsp;<\/p>\n<p>&nbsp; &nbsp;sqlplus \uc5d0\uc11c &nbsp;&nbsp;<\/p>\n<p>&nbsp; &nbsp; alter session set events &#8216;10015 trace name context forever:<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10046 trace name context forever, level 4&#8242;;<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<\/p>\n<p>9. alter session \uba85\ub839\uc73c\ub85c \uc790\uc2e0 \uc138\uc158\uc5d0 &nbsp;event\uac78\uae30(session \uc774 logout\ud560\ub54c\uae4c\uc9c0 \uc218\ud589\ub428)&nbsp;<\/p>\n<p>&nbsp; &nbsp;alter session set timed_statistics=true;&nbsp;<\/p>\n<p>&nbsp; &nbsp;alter session set max_dump_file_size=unlimited;&nbsp;<\/p>\n<p>&nbsp; &nbsp;alter session set tracefile_identifier=&#8217;10046evnt1&#8242;;&nbsp;<\/p>\n<p>&nbsp; &nbsp;alter session set events &#8216;10046 trace name context forever , level 12&#8217;;&nbsp;<\/p>\n<p>&nbsp; &nbsp;alter session set events &#8216;10053 trace name context forever , level 1&#8217;;&nbsp;<\/p>\n<p>&nbsp; &nbsp;alter session set events &#8216;10046 trace name context off&#8217;;&nbsp;<\/p>\n<p>&nbsp; &nbsp;alter session set events &#8216;10053 trace name context off&#8217;;<\/p>\n<p>&nbsp;<\/p>\n<p>10. \uc804\uccb4 \uc2dc\uc2a4\ud15c\uc5d0 event \uac78\uae30<\/p>\n<p>&nbsp; &nbsp;alter system set timed_statistics=true;&nbsp;<\/p>\n<p>&nbsp; &nbsp;alter system set max_dump_file_size=unlimited;&nbsp;<\/p>\n<p>&nbsp; &nbsp;alter system set tracefile_identifier=&#8217;10046evnt1&#8242;;&nbsp;<\/p>\n<p>&nbsp; &nbsp;alter system set events &#8216;10046 trace name context forever , level 12&#8217;;&nbsp;<\/p>\n<p>&nbsp; &nbsp;alter system set events &#8216;10053 trace name context forever , level 1&#8217;;&nbsp;<\/p>\n<p>&nbsp; &nbsp;alter system set events &#8216;10046 trace name context off&#8217;;&nbsp;<\/p>\n<p>&nbsp; &nbsp;alter system set events &#8216;10053 trace name context off&#8217;;<\/p>\n<p>&nbsp;<\/p>\n<p>11. alter session \uba85\ub839\uc73c\ub85c ORA-4031 \uc5d0\ub7ec\uc5d0 \ub300\ud55c event \uac78\uae30(immediate\ub85c \uc989\uac01 \ub5a8\uc5b4\uc9c0\ub3c4\ub85d)&nbsp;<\/p>\n<p>&nbsp; &nbsp;alter session set max_dump_file_size=unlimited;&nbsp;<\/p>\n<p>&nbsp; &nbsp;alter session set tracefile_identifier=&#8217;4031evnt1&#8242;;&nbsp;<\/p>\n<p>&nbsp; &nbsp;alter session set events &#8216;04031 trace name errorstack level 3&#8217;;&nbsp;<\/p>\n<p>&nbsp; &nbsp;alter session set events &#8216;04031 trace name systemstate level 10&#8217;;<\/p>\n<p>&nbsp;<\/p>\n<p>12. sqlplus \ub85c \uc811\uc18d\uc774 \ubd88\uac00\ub2a5\ud560 \uacbd\uc6b0 \ubc31\uadf8\ub77c\uc6b4\ub4dc \ud504\ub85c\uc138\uc2a4\uc758 systemstate \ub364\ud504 \ub728\uae30&nbsp;<\/p>\n<p>&nbsp;\uc704\ud5d8\ud55c \uba85\ub839\uc784, \uc11c\ube44\uc2a4 \uc911\uc5d4 \uc0ac\uc6a9\uae08\uc9c0, \ubb38\uc81c \ubc1c\uc0dd\uc73c\ub85c DB\ub97c \ub0b4\ub9ac\uae30\uc804\uc5d0 \uc218\ud589<\/p>\n<p>&nbsp; &nbsp;OS debuger\ub97c \uc0ac\uc6a9\ud558\uba74 \ud2b9\uc815 process\uc5d0\uac8c \ud2b9\uc815 function\uc744 \ud638\ucd9c\ud558\ub3c4\ub85d \ud560 \uc218&nbsp;<\/p>\n<p>&nbsp; &nbsp;\uc788\uc2b5\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uc810\uc744 \uc774\uc6a9\ud558\uba74 ORACLE\uc5d0\uc11c systemstate dump\ub97c \uc694\uccad\ud560 \ub54c&nbsp;<\/p>\n<p>&nbsp; &nbsp;\uc0ac\uc6a9\ud558\ub294 ksudss function\uc744 \ud638\ucd9c\ud560 \uc218 \uc788\uc73c\uba70, \uc808\ucc28\ub294 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4.&nbsp;<\/p>\n<p>&nbsp; &nbsp;cf&gt; dbx -&gt; \uc720\ub2c9\uc2a4\uc5d0\uc11c \uc0ac\uc6a9<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp;gdb -&gt; \ub9ac\ub205\uc2a4\uc5d0\uc11c \uc0ac\uc6a9<\/p>\n<p>&nbsp; &nbsp;<\/p>\n<p>&nbsp; &nbsp;1) \uba3c\uc800 attach\ud560 ORACLE process\uc5d0 \ub300\ud55c OS PID\ub97c \uc54c\uc544 \ub461\ub2c8\ub2e4.&nbsp;<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp;(\uc5ec\uae30\uc11c\ub294 PMON process\ub97c \uc608\ub97c \ub4e4\uc5c8\uc2b5\ub2c8\ub2e4.)&nbsp;<\/p>\n<p>&nbsp; &nbsp;$ ps -ef | grep $ORACLE_SID | grep pmon&nbsp;<\/p>\n<p>&nbsp; &nbsp; &nbsp; aprdbms 1432 1 0 23:14:50 ? 0:00 ora_pmon_APR920U6&nbsp;<\/p>\n<p>&nbsp; &nbsp;2) Pmon process\uc5d0 debuger\ub97c \uc0ac\uc6a9\ud558\uc5ec attach\ud569\ub2c8\ub2e4.&nbsp;<\/p>\n<p>&nbsp; &nbsp; &nbsp; $gdb $ORACLE_HOME\/bin\/oracle 1432&nbsp;<\/p>\n<p>&nbsp; &nbsp;3) Ksudss function\uc744 \ud638\ucd9c\ud569\ub2c8\ub2e4.&nbsp;<\/p>\n<p>&nbsp; &nbsp; &nbsp; gdb) call ksudss (10)&nbsp;<\/p>\n<p>&nbsp; &nbsp;4) Pmon\uc740 ksudss\ub97c \ud638\ucd9c\ud558\uc5ec systemstate dump\ub97c \ubc1b\uac8c \ub429\ub2c8\ub2e4.&nbsp;<\/p>\n<p>&nbsp; &nbsp; &nbsp; attach\ud55c process\uac00 ksudss function call \uc694\uccad\uc744 \ubc1b\uc544 \ub4e4\uc774\uae30 \uc704\ud574\uc11c\ub294&nbsp;<\/p>\n<p>&nbsp; &nbsp; &nbsp; system call\uc744 \uc218\ud589 \uc911\uc5d0 \uc788\uc9c0 \uc54a\uc544\uc57c \ud569\ub2c8\ub2e4.&nbsp;<\/p>\n<p>&nbsp;&nbsp;<\/p>\n<p>13. Tracing Oracle Process \ub97c \ud1b5\ud574\uc11c \uc11c\ubc84 \ud504\ub85c\uc138\uc2a4 \ud2b8\ub808\uc774\uc2a4 \ud655\uc778<\/p>\n<p>&nbsp; &#8211; os\uc5d0\uc11c \uc5b4\ub5bb\uac8c \ucc98\ub9ac\ud558\uace0 \uc788\ub294\uc9c0\ub97c \ud655\uc778\ud560 \uacbd\uc6b0 \uc0ac\uc6a9<\/p>\n<p>&nbsp; &#8211; DB\ub97c \ub0b4\ub9b4 \uac83\uc774 \uc544\ub2c8\ub77c\uba74 background \ud504\ub85c\uc138\uc2a4\uc5d0 \uc2e4\ud589\ud558\uc9c0 \ub9d0\uac83<\/p>\n<p>&nbsp; &#8211; db\uac00 \ub0b4\ub824\uac08 \uc218 \uc788\uc73c\ubbc0\ub85c \ud504\ub85c\uc138\uc2a4\uc5d0 \ub300\ud55c OS trace\ub97c \ub0a8\uae30\uace0\uc790 \ud560 \uacbd\uc6b0\uc5d0<\/p>\n<p>&nbsp; &nbsp; \uc138\uc158\uc744 \uc8fd\uc774\uae30 \uc804\uc5d0 \uc218\ud589\ud558\uae30<\/p>\n<p>&nbsp; &#8211; where\uc5d0 \ub098\uc628 \ubd80\ubd84\uc5d0\uc11c \uc77d\ub294 \ubc29\ubc95\uc740 \uac70\uafb8\ub85c \uc62c\ub77c\uac00\uba70 \uc77d\uc5b4\uc57c \ud568<\/p>\n<p>&nbsp; &nbsp;&nbsp;<\/p>\n<p>&nbsp; $dbx -a (\ud504\ub85c\uc138\uc2a4id) \ub610\ub294 gdb $ORACLE_HOME\/bin\/oracle 11270<\/p>\n<p>&nbsp; &nbsp;(dbx) where<\/p>\n<p>&nbsp; &nbsp;(dbx) detach<\/p>\n<p>&nbsp;&nbsp;<\/p>\n<p>&nbsp; &#8211; \uc608&gt;<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp;PROD:\/opt\/oracle\/product\/9.2.0\/network\/admin$script dbx.log<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp;Script started, file is dbx.log<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp;PROD:\/opt\/oracle\/product\/9.2.0\/network\/admin$gdb $ORACLE_HOME\/bin\/oracle 11270<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp;GNU gdb Red Hat Linux (5.3.90-0.20030710.40rh)<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp;Copyright 2003 Free Software Foundation, Inc.<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp;(gdb) where<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp;#0 &nbsp;0xb71836e1 in fsync () from \/lib\/i686\/libpthread.so.0<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp;#1 &nbsp;0x09826f33 in skgfcfi ()<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp;#2 &nbsp;0x082bf561 in ksfdcls ()<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp;#3 &nbsp;0x08b669ea in kcflckf ()<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp;#4 &nbsp;0x08b66bc3 in kcflbi ()<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp;#5 &nbsp;0x00000003 in ?? ()<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp;#6 &nbsp;0x0ae0bb44 in ?? ()<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp;#7 &nbsp;0x00000010 in ?? ()<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp;#8 &nbsp;0x565fa0cc in ?? ()<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp;#9 &nbsp;0x00080002 in ?? ()<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp;(gdb) detach<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp;ctrl+c<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp;$ script off<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp;<\/p>\n<p>14. truss \ub0a8\uae30\uae30(db\ub97c \ub0b4\ub9ac\uae30 \uc804\uc5d0 OS\uc5d0\uc11c \uc218\ud589, \ud3c9\uc0c1\uc2dc \uc0ac\uc6a9 \uae08\uc9c0) note 110888.1<\/p>\n<p>&nbsp;(1) hp-ux \uc758 \uacbd\uc6b0&nbsp;<\/p>\n<p>&nbsp; &nbsp;$ tusc -afpo &lt;output file&gt; &lt;pid&gt; &lt;executable&gt;<\/p>\n<p>&nbsp;(2) AIX 5L&nbsp;<\/p>\n<p>&nbsp; &nbsp;$ truss -aefo &lt;output file&gt; &lt;executable&gt;<\/p>\n<p>&nbsp;(3) LINUX<\/p>\n<p>&nbsp; &nbsp;$ strace -fo &lt;output file&gt; &lt;executable&gt;<\/p>\n<p>&nbsp;(4) solaris<\/p>\n<p>&nbsp; &nbsp;$ truss -aefo &lt;output file&gt; &lt;executable&gt;<\/p>\n<p>&nbsp; &nbsp; \uc608) truss -o truss.txt -p (process pid)<\/p>\n<p>&nbsp; &nbsp; &nbsp; truss -p (process id)<\/p>\n<p>&nbsp;&nbsp;<\/p>\n<p>&nbsp;(5) sqlplus\ud1b5\ud574\uc11c db\uae30\ub3d9\uc2dc \uc5d0\ub7ec\uac00 \ub0a0 \uacbd\uc6b0(\uc608\ub97c\ub4e4\uc5b4 ORA-27302 failure occured at skgxpvaddr9<\/p>\n<p>&nbsp; &nbsp; &nbsp; truss\ub97c \uc774\uc6a9\ud574\uc11c sqlplus \uc5d0 \uc811\uc18d\ud6c4\ub97c truss \ub0a8\uae30\uae30<\/p>\n<p>&nbsp; &nbsp; &nbsp; linux\uc758 \uacbd\uc6b0 strace -o truss.log sqlplus &#8216;\/as sysdba&#8217; \uc774 \uba85\ub839\uc73c\ub85c \ub4e4\uc5b4\uac00\uae30<\/p>\n<p>&nbsp; &nbsp; &#8211;&nbsp;<\/p>\n<p>&nbsp; &nbsp; &nbsp;$truss -o truss.log -fae sqlplus &#8216;\/as sysdba&#8217;<\/p>\n<p>&nbsp; &nbsp; &nbsp;sql&gt; startup<\/p>\n<p>&nbsp; &nbsp; &nbsp;ORA-27302 failure occured at skgxpvaddr9<\/p>\n<p>&nbsp; &nbsp; &nbsp;&#8230;<\/p>\n<p>&nbsp; &nbsp; &nbsp;$cat truss.log<\/p>\n<p>15. \ub124\ud2b8\uc6cc\ud06c\uc5d0 \ub300\ud55c \ud074\ub77c\uc774\uc5b8\ud2b8 trace \ub0a8\uae30\uae30<\/p>\n<p>&nbsp;&#8211; \ud074\ub77c\uc774\uc5b8\ud2b8\uc5d0\uc11c sqlnet.ora \ud30c\uc77c\uc5d0\uc11c<\/p>\n<p>&nbsp; &nbsp;trace_level_client=16<\/p>\n<p>&nbsp; &nbsp;trace_directory_client=c:\\temp (\uc708\ub3c4\uc6b0)<\/p>\n<p>&nbsp; &nbsp;log_directory_client=\/tmp &nbsp;(\uc720\ub2c9\uc2a4)<\/p>\n<p>&nbsp; &nbsp;<\/p>\n<p>16. dump, error , stack\uc758 \uc885\ub958 \ubc0f \ucd5c\ub300 \ub808\ubca8<\/p>\n<p>&nbsp; &nbsp;10046 event sql trace \ub0a8\uae30\uae30, level 12<\/p>\n<p>&nbsp; &nbsp;10053 event \ud504\ub85c\uc138\uc2a4\uac00 \uc218\ud589\ud55c \ucffc\ub9ac\uc758 optimizer\uc5d0 \ub300\ud55c \uc815\ubcf4, level 1<\/p>\n<p>&nbsp; &nbsp;hanganalyze \uc2dc\uc2a4\ud15c hang\uc774 \uac78\ub838\uc744 \uacbd\uc6b0 dump, level 4<\/p>\n<p>&nbsp; &nbsp;errorstack \uc2dc\uc2a4\ud15c \ud2b9\uc815 \uc5d0\ub7ec \ubc1c\uc0dd\uc5d0 \ub300\ud574\uc11c \uac04\ub2e8\ud55c \uc5d0\ub7ec \uc815\ubcf4 dump, level 3<\/p>\n<p>&nbsp; &nbsp;systemstate dump \uc804\uccb4 \uc2dc\uc2a4\ud15c \uc0c1\ud0dc\uc5d0 \ub300\ud55c dump, level 10<\/p>\n<p>&nbsp; &nbsp;heapdump \uba54\ubaa8\ub9ac \uc5d0\ub7ec \ubc1c\uc0dd\uc2dc heap\uc601\uc5ed\uc5d0 \ub300\ud55c dump, level 3<\/p>\n<p>&nbsp;&nbsp;<\/p>\n<p>17. event \uc885\ub958<\/p>\n<p>&nbsp; &nbsp;10046 sql trace \ub0a8\uae30\uae30, level 12\ub294 bind\ubcc0\uc218 \ubc0f plan, tuning statistics \uae4c\uc9c0 \ucd9c\ub825<\/p>\n<p>&nbsp; &nbsp;10053 optimizer\uc5d0 \ub300\ud55c \uc815\ubcf4\uae4c\uc9c0 \ucd9c\ub825, level 1 \uc774 \ucd5c\ub300<\/p>\n<p>&nbsp; &nbsp;10015 rollback segment\ub97c \ubd84\uc11d \ubc0f \uc0ac\uc6a9\uc911\uc9c0 \ud558\ub3c4\ub85d \ud558\ub294 event<\/p>\n<p>&nbsp; &nbsp;10233 index opereation \uc5d0\uc11c corrupted index block\uc744 skip\ud558\uae30<\/p>\n<p>&nbsp; &nbsp;10061 disable SMON from cleaning temp segment(smon\ud504\ub85c\uc138\uc2a4\uac00 extent\uc815\ub9ac\ub97c \uc548\ud558\ub3c4\ub85d \uc124\uc815)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. \ub364\ud504 &nbsp;&nbsp; &nbsp; \ub364\ud504 : \uc77c\ud68c\uc131\uc73c\ub85c \uadf8 \uc21c\uac04\uc758 \uc0c1\ud0dc\uc815\ubcf4\ub97c \uac00\uc9d1\ub2c8\ub2e4.&nbsp; &nbsp; \ud2b8\ub808\uc774\uc2a4 : 10046, 10053 \ub4f1\uc758 \uc774\ubca4\ud2b8\ub97c \uac78\uac8c \ub418\uba74 \uc21c\uac04\uc758 \uc0c1\ud0dc(immediate) \ub610\ub294&nbsp; &nbsp; \uc138\uc158\uc774 close\ub420\ub54c\uae4c\uc9c0\uc758 \uc815\ubcf4(trace name context forever) \ub97c trace\ub85c&nbsp; &nbsp; \ub0a8\uae41\ub2c8\ub2e4. &nbsp; \ucc38\uace0\ub85c udump \uc5d0 \uc5c6\ub2e4\uace0 \ud574\uc11c \uace0\ubbfc\ud558\uc9c0 \ub9d0\uad6c\uc694. bdump\ub97c \ucc3e\uc544\ubcf4\uc138\uc694.&nbsp; &nbsp; background process\ub97c \uc774\uc6a9\ud574\uc11c dump\ub97c \ub728\ub294 \uacbd\uc6b0\uc5d0\ub294 bdump\uc5d0 \ub098\uc624\uaca0\uc8e0. &nbsp; 2. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[14],"tags":[179,180,181],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/424"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=424"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/424\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=424"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=424"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=424"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}