{"id":792,"date":"2015-12-04T06:43:19","date_gmt":"2015-12-04T06:43:19","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=792"},"modified":"2015-12-04T06:43:19","modified_gmt":"2015-12-04T06:43:19","slug":"oradebug-%ec%82%ac%ec%9a%a9%eb%b2%95-2","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=792","title":{"rendered":"ORADEBUG \uc0ac\uc6a9\ubc95 – 2"},"content":{"rendered":"

[oradebug \uc0ac\uc6a9\ubc95 – 2]<\/b><\/p>\n

1.<\/span> <\/font><\/span>oradebug resume<\/font><\/p>\n

\uc77c\uc2dc \uc911\uc9c0\ub41c \ud504\ub85c\uc138\uc2a4\ub97c \uc7ac\uc2dc\uc791<\/font><\/p>\n

SQL> oradebug resume <\/p>\n

<\/p>\n

2. oradebug flush<\/p>\n

\uba54\ubaa8\ub9ac\uc5d0 \uc788\ub294 \uc815\ubcf4\ub97c Trace \ud30c\uc77c\uc5d0 Write<\/span><\/p>\n

<\/p>\n

3. oradebug close_trace  <\/p>\n

\ud504\ub85c\uc138\uc2a4\uac00 \uc7a1\uace0 \uc788\ub358 \ud2b8\ub808\uc774\uc2a4 \ud30c\uc77c close<\/p>\n

<\/p>\n

4. oradebug lkdebug <\/p>\n

\ub9ac\uc18c\uc2a4 \ub9ac\ub9c8\uc2a4\ud130\ub9c1 \uc9c1\uc811\uc218\ud589<\/span><\/p>\n


<\/span><\/p>\n

5. oradebug nsdbx<\/p>\n

Cluster Group Services (CGS) name-service debugger\ub85c <\/span><\/font>ORADEBUG \uc720\ud2f8\ub9ac\ud2f0<\/span><\/p>\n

Usage:nsdbx [options]
\n -h Help
\n -p <owner> <namespace> <key> <value> <nowait>  Publish a name-entry
\n -d <owner> <namespace> <key> <nowait>     Delete a name-entry
\n -q <namespace> <key> Query a namespace
\n -an <namespace> Print all entries in namespace
\n -ae Print all entries
\n -as Print all namespaces
\n <\/span><\/font><\/p>\n


<\/span><\/p>\n

6. oradebug -G   <\/p>\n

\ud328\ub7ec\ub7f4 \uc624\ub77c\ub514\ubc84\uadf8 \uba85\ub839\uc5b4<\/p>\n

EX) oradebug -g def event 10706 trace name context forever, level 10 <\/p>\n

<\/p>\n

7. oradebug setinst  <\/p>\n

\uc778\uc2a4\ud134\uc2a4 \uc124\uc815<\/p>\n

EX) <\/span><\/p>\n


<\/font><\/p>\n

SQL> select * from v$active_instances; <\/font><\/p>\n

INST_NUMBER   INST_NAME <\/span><\/p>\n

———– ——————————— <\/font><\/p>\n

         1     alpha:test1 <\/font><\/p>\n

         2     beta:test2 <\/font><\/p>\n

         3     omega:test3 <\/font><\/p>\n

 <\/font><\/p>\n

SQL> oradebug setinst “1”,”2″,”3″    <\/font><\/p>\n

Statement processed.                                              <\/font><\/p>\n

 <\/font><\/p>\n

SQL> oradebug setinst all <\/font><\/p>\n

Statement processed. <\/font><\/p>\n

 <\/font><\/p>\n

8. oradebug sgatofile<\/p>\n

SGA\ub97c \ud30c\uc77c\ub85c \ub364\ud504<\/p>\n

<\/p>\n

9. oradebug hanganalyze<\/p>\n

\uc2dc\uc2a4\ud15c Hang \ubd84\uc11d<\/p>\n

EX) <\/p>\n

ORADEBUG setmypid <\/p>\n

ORADEBUG setinst all <\/p>\n

ORADEBUG -g def hanganalyze  <level> <\/p>\n

<\/p>\n

[LEVEL]<\/p>\n

1-2  Only HANGANALYZE output, no process dump at all <\/font><\/p>\n

3    Level 2 + Dump only processes thought to be in a hang (IN_HANG state) <\/font><\/p>\n

4    <\/font>Level 3 + Dump leaf nodes (blockers) in wait chains (LEAF,LEAF_NW,IGN_DMP <\/span>state) <\/span><\/p>\n

5    Level 4 + Dump all processes involved in wait chains (NLEAF state) <\/font><\/p>\n

10   Dump all processes (IGN state) <\/font><\/p>\n

<\/p>\n

<\/p>\n

<\/p>\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

[oradebug \uc0ac\uc6a9\ubc95 – 2] 1. oradebug resume \uc77c\uc2dc \uc911\uc9c0\ub41c \ud504\ub85c\uc138\uc2a4\ub97c \uc7ac\uc2dc\uc791 SQL> oradebug resume  2. oradebug flush \uba54\ubaa8\ub9ac\uc5d0 \uc788\ub294 \uc815\ubcf4\ub97c Trace \ud30c\uc77c\uc5d0 Write 3. oradebug close_trace   \ud504\ub85c\uc138\uc2a4\uac00 \uc7a1\uace0 \uc788\ub358 \ud2b8\ub808\uc774\uc2a4 \ud30c\uc77c close 4. oradebug lkdebug  \ub9ac\uc18c\uc2a4 \ub9ac\ub9c8\uc2a4\ud130\ub9c1 \uc9c1\uc811\uc218\ud589 5. oradebug nsdbx Cluster Group Services (CGS) name-service debugger\ub85c ORADEBUG \uc720\ud2f8\ub9ac\ud2f0 Usage:nsdbx [options] -h Help -p <owner> <namespace> <key> <value> <nowait>  Publish a […]<\/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":[468],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/792"}],"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=792"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/792\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=792"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=792"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=792"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}