{"id":656,"date":"2015-11-19T01:21:34","date_gmt":"2015-11-19T01:21:34","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=656"},"modified":"2015-11-19T01:21:34","modified_gmt":"2015-11-19T01:21:34","slug":"oracle-rac-%ed%99%98%ea%b2%bd-%ec%9d%98-udp-%eb%a5%bc-%ed%86%b5%ed%95%9c-%ec%ba%90%ec%8b%9c%ed%93%a8%ec%a0%84%ec%8b%9c-%ec%84%b1%eb%8a%a5-%eb%ac%b8%ec%a0%9c-%ed%99%95%ec%9d%b8%ed%95%98%eb%8a%94","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=656","title":{"rendered":"Oracle RAC \ud658\uacbd \uc758 UDP \ub97c \ud1b5\ud55c \uce90\uc2dc\ud4e8\uc804\uc2dc \uc131\ub2a5 \ubb38\uc81c \ud655\uc778\ud558\ub294 \ubc95"},"content":{"rendered":"

Oracle RAC \ud658\uacbd \uc758 UDP \ub97c \ud1b5\ud55c \uce90\uc2dc\ud4e8\uc804\uc2dc \uc131\ub2a5 \ubb38\uc81c\ub97c \uac04\ub2e8\ud788 \ud655\uc778\ud558\ub294 \ubc95<\/p>\n

<\/p>\n

RAC\uad6c\uc870\uc5d0\uc11c UDP \ubc84\ud37c\uc0ac\uc774\uc988\uac00 \uc791\uc544\uc11c \ubb38\uc81c\uac00  \uc0dd\uae38\uc2dc \uc544\ub798 \ubc29\ubc95\uc744 \ud1b5\ud574 \ud655\uc778 \ud558\uace0 \uacb0\uacfc\uc801\uc73c\ub85c UDP \ubc84\ud37c \uc0ac\uc774\uc988\ub97c \ud0a4\uc6cc\uc8fc\uba74 \ub429\ub2c8\ub2e4.<\/p>\n

<\/p>\n

<\/p>\n

<\/p>\n

\ube44\ud6a8\uc728\uc801\uc778 \ub124\ud2b8\uc6cc\ud06c \uc124\uc815 \ud655\uc778<\/p>\n

<\/p>\n

 – Gigabit Ethernet Interconnect\uc5d0\uc11c\ub294 UDP(User Diagram Protocol) \uc0ac\uc6a9<\/p>\n

 – \ud655\uc778 \ubc29\ubc95 :<\/p>\n

 SQL> oradebug setmypid<\/p>\n

 SQL> oradebug ipc<\/p>\n

 SQL> oradebug tracefile_name<\/p>\n

 <\/p>\n

[\uc608\uc81c]<\/p>\n

<\/p>\n

oracle@srac1:~$ sqlplus “\/as sysdba”<\/p>\n

<\/p>\n

SQL*Plus: Release 12.1.0.2.0 Production on Thu Nov 19 01:06:42 2015<\/p>\n

<\/p>\n

Copyright (c) 1982, 2014, Oracle.  All rights reserved.<\/p>\n

<\/p>\n

<\/p>\n

Connected to:<\/p>\n

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production<\/p>\n

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,<\/p>\n

Advanced Analytics and Real Application Testing options<\/p>\n

<\/p>\n

SQL> oradebug setmypid<\/p>\n

Statement processed.<\/p>\n

SQL> oradebug ipc<\/p>\n

IPC information written to the trace file<\/p>\n

SQL> oradebug tracefile_name<\/p>\n

\/oracle\/app\/diag\/rdbms\/soldb\/soldb1\/trace\/soldb1_ora_22881.trc<\/p>\n

SQL> exit<\/p>\n

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production<\/p>\n

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,<\/p>\n

Advanced Analytics and Real Application Testing options<\/p>\n

oracle@srac1:~$ more \/oracle\/app\/diag\/rdbms\/soldb\/soldb1\/trace\/soldb1_ora_22881.trc<\/p>\n

<\/p>\n

<\/p>\n

* TRACE \ud30c\uc77c \ub0b4\uc6a9 \uc911 \ud14c\uc2a4\ud2b8 \uacb0\uacfc\uac00 \ucc0d\ud600 \uc788\ub2e4.<\/p>\n

<\/p>\n

WAIT HISTORY<\/p>\n

Wait Time  Time since     Fast reaps  Wait Type  Return Code<\/p>\n

  (ms)     prev wait(ms)  before                           <\/p>\n

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

wait delta 11 sec (11907 msec) ctx ts 0 sec (2 msec) last ts 0 msec twait secs 5 (blocked 0) curts = 11907<\/p>\n

 <\/p>\n

 EXTENDED WAIT HISTORY STATS<\/p>\n

 Time       Prev      Ncomp     Nwait     Nloop     Nsel      Select    No Svc     Events      <\/p>\n

 (-ms)      (ms)                                              (ms)      (ms)                   <\/p>\n

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

 current (0)<\/p>\n

      11908         0         0         0         0         0         0          0           0 <\/p>\n

 <\/p>\n

 user cpu time since last wait 0 sec 0 ticks<\/p>\n

 system cpu time since last wait 0 sec 0 ticks<\/p>\n

 locked 2<\/p>\n

 blocked 0<\/p>\n

 timed wait receives 0<\/p>\n

 fast reaps since last wait 0<\/p>\n

 context timestamp 0x2<\/p>\n

 <\/p>\n

<\/p>\n

SSKGXPT ffff80ffbdfe27d0 flags 0x5 { READPENDING } sockno 4 IP 192.168.55.191 UDP 53806 lerr 0<\/p>\n

…<\/p>\n

SSKGXPT ffff80ffbdefeda0 flags 0x0  sockno 10 IP 192.168.55.191 UDP 42095 lerr 0<\/p>\n

<\/p>\n

…<\/p>\n

<\/p>\n

<\/p>\n

 <\/p>\n

 – RAC Interconnect \uc131\ub2a5\uacfc \uac00\uc7a5 \uc5f0\uad00 \uc788\ub294 \uac83\uc740 UDP Buffer Size.<\/span><\/b><\/span><\/p>\n


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

 – \uc624\ub77c\ud074 \uad8c\uc7a5 UDP buffer size = 256K<\/span><\/b><\/span><\/p>\n


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

 – UDP Buffer Size\uac00 \uc791\uc73c\uba74 \ud328\ud0b7\uc720\uc2e4(Packet loss) \ud604\uc0c1\uc774 \ubc1c\uc0dd. (gc cr\/current block lost \ubc1c\uc0dd)<\/span><\/b><\/span><\/p>\n


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

 <\/p>\n

 <\/p>\n

 <\/p>\n

 * \ud328\ud0b7 \uc720\uc2e4 \ud655\uc778 <\/p>\n

 <\/p>\n

 Solaris netstat -s -P udp<\/p>\n

<\/p>\n

UDP     udpInDatagrams      =250263     udpInErrors         =     0<\/p>\n

        udpOutDatagrams     =229050     udpOutErrors        =     0<\/p>\n

<\/p>\n

 <\/p>\n

 HP_UX> netstat -s -p udp<\/p>\n

udp:<\/p>\n

        57726 incomplete headers<\/p>\n

        4795 bad checksums<\/p>\n

        52931 socket overflows<\/p>\n

 <\/p>\n

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

Oracle RAC \ud658\uacbd \uc758 UDP \ub97c \ud1b5\ud55c \uce90\uc2dc\ud4e8\uc804\uc2dc \uc131\ub2a5 \ubb38\uc81c\ub97c \uac04\ub2e8\ud788 \ud655\uc778\ud558\ub294 \ubc95 RAC\uad6c\uc870\uc5d0\uc11c UDP \ubc84\ud37c\uc0ac\uc774\uc988\uac00 \uc791\uc544\uc11c \ubb38\uc81c\uac00  \uc0dd\uae38\uc2dc \uc544\ub798 \ubc29\ubc95\uc744 \ud1b5\ud574 \ud655\uc778 \ud558\uace0 \uacb0\uacfc\uc801\uc73c\ub85c UDP \ubc84\ud37c \uc0ac\uc774\uc988\ub97c \ud0a4\uc6cc\uc8fc\uba74 \ub429\ub2c8\ub2e4. \ube44\ud6a8\uc728\uc801\uc778 \ub124\ud2b8\uc6cc\ud06c \uc124\uc815 \ud655\uc778  – Gigabit Ethernet Interconnect\uc5d0\uc11c\ub294 UDP(User Diagram Protocol) \uc0ac\uc6a9  – \ud655\uc778 \ubc29\ubc95 :  SQL> oradebug setmypid  SQL> oradebug ipc  SQL> oradebug tracefile_name   […]<\/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":[25],"tags":[323,90,324,325],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/656"}],"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=656"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/656\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=656"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=656"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=656"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}