{"id":794,"date":"2015-12-04T09:09:16","date_gmt":"2015-12-04T09:09:16","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=794"},"modified":"2015-12-04T09:09:16","modified_gmt":"2015-12-04T09:09:16","slug":"oradebug-dumps","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=794","title":{"rendered":"ORADEBUG DUMPS"},"content":{"rendered":"

\uc624\ub77c\ub514\ubc84\uadf8\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ub0b4\ubd80 \uc815\ubcf4\ub97c \uc5bb\uc744 \ub54c \uc720\uc6a9\ud558\uac8c \uc0ac\uc6a9\ub41c\ub2e4.<\/p>\n

<\/p>\n

1. oradebug dump   <\/p>\n

\ub364\ud504 \uc218\ud589<\/p>\n

<\/p>\n

[ Syntax ] <\/p>\n

oradebug dump  <dump_name> <level> [addr] <\/p>\n

<\/p>\n

[ Parameter ]<\/p>\n

<dump_name>    <\/p>\n

<level> <\/p>\n

[<addr>]   <\/p>\n

<\/p>\n

<\/p>\n

SQL> oradebug dumplist  ( Oradebug \uc5d0\uc11c \ub364\ud504\ud560 \uc218 \uc788\ub294 Named Event)<\/p>\n

EVENTS <\/p>\n

TRACE_BUFFER_ON <\/p>\n

TRACE_BUFFER_OFF <\/p>\n

HANGANALYZE <\/p>\n

LATCHES <\/p>\n

PROCESSSTATE <\/p>\n

SYSTEMSTATE <\/p>\n

INSTANTIATIONSTATE <\/p>\n

REFRESH_OS_STATS <\/p>\n

CROSSIC <\/p>\n

CONTEXTAREA <\/p>\n

HEAPDUMP <\/p>\n

HEAPDUMP_ADDR <\/p>\n

POKE_ADDRESS <\/p>\n

POKE_LENGTH \u2026\u2026\u2026. <\/p>\n

 <\/p>\n

<\/p>\n

2.  oradebug  dump systemstate<\/p>\n

\uc2dc\uc2a4\ud15c \uc0c1\ud0dc \uc815\ubcf4 \ub364\ud504<\/p>\n

EX)<\/p>\n

 <\/p>\n

SQL> oradebug setmypid <\/p>\n

Statement processed. <\/p>\n

SQL> oradebug unlimit <\/p>\n

Statement processed. <\/p>\n

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

Statement processed. <\/p>\n

SQL> oradebug -g def dump systemstate 10 <\/p>\n

Statement processed. <\/p>\n

<\/p>\n

3. oradebug  dump processstate  <\/p>\n

\ud504\ub85c\uc138\uc2a4 \uc0c1\ud0dc \uc815\ubcf4 \ub364\ud504<\/p>\n

EX)<\/p>\n

SQL> oradebug setmypid <\/p>\n

Statement processed. <\/p>\n

SQL> oradebug unlimit <\/p>\n

Statement processed. <\/p>\n

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

Statement processed. <\/p>\n

SQL> oradebug -g def dump systemstate 10 <\/p>\n

Statement processed. <\/p>\n

<\/p>\n

4. oradebug  dump errorstack <\/p>\n

error stack \ub364\ud504<\/p>\n

<\/p>\n

Dump Level                        Dump Contains <\/p>\n

0                              dump error buffer <\/p>\n

1                              level 0 + call stack <\/p>\n

2                              level 1 + process state objects <\/p>\n

3                              level 2 + context area <\/p>\n

<\/p>\n

EX)<\/p>\n

 <\/p>\n

SQL> oradebug setospid 13446 <\/p>\n

Oracle pid: 12, Unix process pid: 13446, image: oracle@apollo (TNS V1-V3) <\/p>\n

SQL> oradebug unlimit <\/p>\n

Statement processed. <\/p>\n

SQL> oradebug dump errorstack 3 <\/p>\n

Statement processed. <\/p>\n

 <\/p>\n

5. oradebug dump controlf<\/p>\n

\ub370\uc774\ud130\ud30c\uc77c\uacfc \ucf58\ud2b8\ub864\ud30c\uc77c \ud5e4\ub354\ub97c \ub364\ud504\ud558\ub294 \uac83\uc73c\ub85c \ub9ac\ucee4\ubc84\ub9ac\ub098 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc624\ud508\uc2dc \ud30c\uc77c\ub4e4 \uc0c1\ud0dc\uac00 \uc77c\uce58\ud558\uc9c0 \uc54a\ub294\ub2e4\ub294 <\/p>\n

ORA-1113, ORA-376 \ub4f1\uc758 \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud558\ub294 \uacbd\uc6b0 CONTROLF \uc640 FILE_HDRS \ub97c \uc0ac\uc6a9\ud558\uc5ec \uac01 \ud30c\uc77c\uc758 \ud5e4\ub354\ub97c \ub364\ud504\ud558\uc5ec \ud30c\uc77c\ub4e4\uc758 \uc0c1\ud0dc\uc640 \uc5c5\ub370\uc774\ud2b8 \uc2dc\uac04\uc744 \ube44\uad50<\/p>\n

<\/div>\n

Dump Level                                  Dump Contains <\/p>\n

 1                                      only the file header <\/p>\n

 2                                      just the file header, the database info record, and checkpoint progress records  <\/p>\n

 3                                      all record types, but just the earliest and latest records for circular reuse record types <\/p>\n

 4                                      as above, but includes the 4 most recent records for circular reuse record types <\/p>\n

 5+                                    as above, but the number of circular reuse records included doubles with each level <\/p>\n

 <\/p>\n

6. Memory Dumps <\/p>\n

\ubc84\ud37c\uce90\uc2dc \ub364\ud504 \uc218\ud589<\/p>\n

Dump Level                            Dump Contains <\/p>\n

1                                      dump the buffer headers only   <\/p>\n

2                                      include the cache and transaction headers from each block   <\/p>\n

3                                      include a full dump of each block   <\/p>\n

4                                      dump the working set lists and the buffer headers and the cache header for each block  <\/p>\n

5                                      include the transaction header from each block   <\/p>\n

6                                      include a full dump of each block   <\/p>\n

<\/p>\n

7. oradebug dump library_cache<\/p>\n

\ub77c\uc774\ube0c\ub7ec\ub9ac \uce90\uc2dc \ud1b5\uacc4 \ub364\ud504<\/p>\n

Dump Level                            Dump Contains <\/p>\n

1                                      dump libracy cache statistics <\/p>\n

2                                             also include a hash table  <\/p>\n

3                                      level 2 + dump of the library  object handles <\/p>\n

4                                      Level 3 + dump of the heap <\/p>\n

<\/p>\n

 EX) <\/p>\n

 SQL> oradebug setmypid <\/p>\n

Statement processed. <\/p>\n

 SQL> oradebug dump library_cache 2 <\/p>\n

Statement processed. <\/p>\n

 <\/p>\n

8. oradebug dump heapdump <\/p>\n

 \ud2b9\uc815 \uc624\ub77c\ud074 \ud504\ub85c\uc138\uc2a4\uc758 \uba54\ubaa8\ub9ac\uac00 \uc9c0\uc18d\uc801\uc73c\ub85c \uc99d\uac00\ub9cc\ud558\uac70\ub098 \ud55c\ubc88 \uc99d\uac00\ud55c \ud6c4 \uc904\uc5b4\ub4e4\uc9c0 \uc54a\ub294 \uacbd\uc6b0 \uba54\ubaa8\ub9ac
\n\uc815\ubcf4\ub97c \ub364\ud504\ud558\uc5ec, <\/p>\n

 \uc5b4\ub290 \uba54\ubaa8\ub9ac \uc138\uadf8\uba3c\ud2b8 \ubd80\ubd84\uc774 \ub9ce\uc774 \ucc28\uc9c0\ud558\ub294\uc9c0 \ubd84\uc11d\ud558\uae30 \uc704\ud574 HEAPDUMP \ub97c \uc218\ud589<\/p>\n

<\/p>\n

Dump Level               Dump Contains <\/p>\n

1                      include PGA heap <\/p>\n

2                      include Shared Pool <\/p>\n

4                      include UGA heap  <\/p>\n

8                      include CGA heap <\/p>\n

16                     include Top CGA <\/p>\n

32                     include Large Pool <\/p>\n

<\/p>\n

9. oradebug dump heapdump_addr<\/p>\n

<\/p>\n

Dump Level          Dump Contains <\/p>\n

1                  dump structure <\/p>\n

2                  also include contents <\/p>\n

 <\/p>\n

EX)<\/p>\n

SQL> oradebug setmypid <\/p>\n

Statement processed. <\/p>\n

SQL> oradebug unlimit <\/p>\n

Statement processed. <\/p>\n

SQL> oradebug dump heapdump 2 <\/p>\n

Statement processed. <\/p>\n

<\/p>\n

 <\/p>\n

——————      part of the trace file       ——————– <\/p>\n

*** SESSION ID:(7.14111) 2003-09-03 13:01:21.412 <\/p>\n

****************************************************** <\/p>\n

HEAP DUMP heap name=”sga heap”  desc=0x80000030 <\/p>\n

extent sz=0xfc4 alt=48 het=32767 rec=9 flg=2 opc=0 <\/p>\n

parent=0 owner=0 nex=0 xsz=0x3d2bdf4 <\/p>\n

EXTENT 0 <\/p>\n

 Chunk b5815ff8 sz= 41699524    perm      “perm           ”  alo=19395672 <\/p>\n

 Chunk b7fda8bc sz=   887380    free      ”               ” <\/p>\n

 Chunk b80b3310 sz=      560    freeable  “library cache  ”  ds=b80b5a0c <\/p>\n

 Chunk b80b3540 sz=     2588    freeable  “sql area         ”  ds=b80b5898 <\/p>\n

 Chunk b80b3f5c sz=      732    freeable  “sql area           ”  ds=b80ba69c <\/p>\n

 Open the trace file and look for the ds (descriptor  address).Convert hex to decimal and do the <\/p>\n

dump. <\/p>\n

 <\/p>\n

SQL> oradebug dump heapdump_addr 1 3087751692 <\/p>\n

 <\/p>\n

————————— part of the trace file generated using command above ————- <\/p>\n

Statement processed. <\/p>\n

*** 2003-09-03 13:12:35.330 <\/p>\n

*** SESSION ID:(8.20679) 2003-09-03 13:12:35.322 <\/p>\n

HEAP DUMP heap name=”library cache”  desc=0xb80b5a0c <\/p>\n

extent sz=0x224 alt=32767 het=8 rec=9 flg=2 opc=0 <\/p>\n

parent=80000030 owner=b80b5804 nex=0 xsz=0x224 <\/p>\n

EXTENT 0 <\/p>\n

 Chunk b80b3324 sz=      464    perm      “perm           ”  alo=176 <\/p>\n

 Chunk b80b34f4 sz=       76    freeable  “kgltbtab       ” <\/p>\n

EXTENT 1 <\/p>\n

 Chunk b80b55b4 sz=      500    perm      “perm           ”  alo=500 <\/p>\n

 Chunk b80b57a8 sz=       40    free      ”               ” <\/p>\n

EXTENT 2 <\/p>\n

 Chunk b80b57f4 sz=      244    perm      “perm           ”  alo=244 <\/p>\n

 Chunk b80b58e8 sz=       52    free      ”               ” <\/p>\n

 Chunk b80b591c sz=       76    freeable  “kgltbtab       ” <\/p>\n

 Chunk b80b5968 sz=       76    freeable  “kgltbtab       ” <\/p>\n

 <\/p>\n

10 . INDEX DUMP<\/p>\n

oradebug dump treedump<\/p>\n

\uc778\ub371\uc2a4 \uad6c\uc870\ub97c \ub364\ud504 <\/p>\n

<\/p>\n

EX)<\/p>\n

select  object_id  from sys.dba_objects <\/p>\n

where owner = upper(‘&Owner’) and <\/p>\n

object_name = upper(‘&IndexName’); <\/p>\n

 <\/p>\n

SQL> oradebug setmypid <\/p>\n

Statement processed. <\/p>\n

SQL> oradebug dump treedump 40 <\/p>\n

Statement processed. <\/p>\n

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

\uc624\ub77c\ub514\ubc84\uadf8\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ub0b4\ubd80 \uc815\ubcf4\ub97c \uc5bb\uc744 \ub54c \uc720\uc6a9\ud558\uac8c \uc0ac\uc6a9\ub41c\ub2e4. 1. oradebug dump    \ub364\ud504 \uc218\ud589 [ Syntax ]  oradebug dump  <dump_name> <level> [addr]  [ Parameter ] <dump_name>     <level>  [<addr>]    SQL> oradebug dumplist  ( Oradebug \uc5d0\uc11c \ub364\ud504\ud560 \uc218 \uc788\ub294 Named Event) EVENTS  TRACE_BUFFER_ON  TRACE_BUFFER_OFF  HANGANALYZE  LATCHES  PROCESSSTATE  SYSTEMSTATE  INSTANTIATIONSTATE  REFRESH_OS_STATS  CROSSIC  CONTEXTAREA  HEAPDUMP  HEAPDUMP_ADDR  POKE_ADDRESS  […]<\/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\/794"}],"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=794"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/794\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=794"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=794"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=794"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}