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

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

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

\ud504\ub85c\uc138\uc2a4 \ucda9\ub3cc \uc5c6\uc774 \ucf54\uc5b4 \ub364\ud504<\/font><\/p>\n

<\/p>\n

2. oradebug ipc   <\/p>\n

\uc624\ub77c\ud074\uc774 \uc0ac\uc6a9 \uc911\uc778 OS shared memory segment \uc815\ubcf4, \uc138\ub9c8\ud3ec\uc5b4 \uc815\ubcf4, RAC \uc778 \uacbd\uc6b0 Interconnect \ub124\ud2b8\uc6cc\ud06c
\n\uc815\ubcf4\ub85c, <\/p>\n

\uc0ac\uc6a9\ud558\uae30 \uc804\uc5d0 \ud504\ub85c\uc138\uc2a4 \uc544\uc774\ub514\ub97c \uc124\uc815\ud55c\ub2e4.<\/p>\n

EX)  <\/p>\n

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

Number of semaphores per set:    = 77 <\/p>\n

Semaphores key overhead per set: = 4 <\/p>\n

User Semaphores per set:         = 73 <\/p>\n

Number of semaphore sets:        = 3 <\/p>\n

Semaphore identifiers:           = 3 <\/p>\n

Semaphore List= <\/p>\n

2293760 <\/p>\n

————– system semaphore information ————- <\/p>\n

IPC status from <running system> as of Tue Jul 22 13:49:16 EDT 2003 <\/p>\n

T         ID      KEY        MODE        OWNER    GROUP  CREATOR   CGROUP NSEMS   <\/p>\n

OTIME    CTIME <\/p>\n

Semaphores: <\/p>\n

s    2293760  0xddce3cac –ra-r—–   oracle     dba   oracle     dba    77 10:32:36   11:06:49 <\/p>\n

s     524289   0xddce3cad –ra-r—–   oracle     dba   oracle     dba    77 no-entry    11:06:49 <\/p>\n

s     524290   0xddce3cae –ra-r—–   oracle      dba   oracle    dba    77 11:06:50    11:06:49 <\/p>\n

<\/p>\n

3. oradebug unlimit  <\/p>\n

\ud2b8\ub808\uc774\uc2a4 \ud30c\uc77c\uc5d0 \ub300\ud55c \ud06c\uae30 \uc81c\ud55c\uc744 \uc81c\uac70<\/p>\n

<\/p>\n

4. oradebug procstat   <\/p>\n

\ud504\ub85c\uc138\uc2a4 \ud1b5\uacc4\ub97c \ub364\ud504<\/p>\n

EX) <\/p>\n

 <\/p>\n

Dump statistics for the DBWR background process: <\/p>\n

  select pid,name <\/p>\n

  from v$process p, v$bgprocess b <\/p>\n

  where b.paddr = p.addr <\/p>\n

SQL> \/ <\/p>\n

 <\/p>\n

      PID NAME <\/p>\n

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

        2 PMON <\/p>\n

        3 DBWR<\/p>\n

        4 LGWR <\/p>\n

        5 CKPT <\/p>\n

        6 SMON <\/p>\n

        7 RECO <\/p>\n

 <\/p>\n

6 rows selected. <\/p>\n

 <\/p>\n

SQL> oradebug setorapid 3 <\/p>\n

Unix process pid: 15668, image: oracle@apollo (DBW0) <\/p>\n

SQL> oradebug procstat <\/p>\n

Statement processed. <\/p>\n

 <\/p>\n

To find out where is the trace file located run: <\/p>\n

 <\/p>\n

SQL> oradebug tracefile_name <\/p>\n

\/ora-main\/app\/oracle\/admin\/test\/bdump\/test_dbw0_15668.trc <\/p>\n

SQL> <\/p>\n

 <\/p>\n

5. oradebug call<\/p>\n

\ud568\uc218\ub97c \ud638\ucd9c<\/p>\n

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

[oradebug \uc0ac\uc6a9\ubc95 – 3] 1. oradebug core   \ud504\ub85c\uc138\uc2a4 \ucda9\ub3cc \uc5c6\uc774 \ucf54\uc5b4 \ub364\ud504 2. oradebug ipc    \uc624\ub77c\ud074\uc774 \uc0ac\uc6a9 \uc911\uc778 OS shared memory segment \uc815\ubcf4, \uc138\ub9c8\ud3ec\uc5b4 \uc815\ubcf4, RAC \uc778 \uacbd\uc6b0 Interconnect \ub124\ud2b8\uc6cc\ud06c \uc815\ubcf4\ub85c,  \uc0ac\uc6a9\ud558\uae30 \uc804\uc5d0 \ud504\ub85c\uc138\uc2a4 \uc544\uc774\ub514\ub97c \uc124\uc815\ud55c\ub2e4. EX)   ———              part of the trace file  —————————-  Number of semaphores per […]<\/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\/793"}],"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=793"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/793\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=793"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=793"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=793"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}