{"id":223,"date":"2011-10-19T23:37:45","date_gmt":"2011-10-19T15:37:45","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=223"},"modified":"2011-10-20T08:02:51","modified_gmt":"2011-10-20T00:02:51","slug":"ora-600729%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=223","title":{"rendered":"ORA-600(729)\u9519\u8bef"},"content":{"rendered":"<p>\u5ba2\u6237\u6570\u636e\u5e93\u51fa\u73b0ORA-600[729]\u9519\u8bef\u3002<br \/>\n\u8be6\u7ec6\u4fe1\u606f\u5982\u4e0b\uff1a<\/p>\n<pre lang='SQL'>Sun Oct 16 04:31:31 2011\r\nErrors in file \/u01\/app\/oracle\/admin\/db1\/udump\/db1_ora_6459722.trc:\r\nORA-00600: internal error code, arguments: [729], [360], [space leak], [], [], [], [], []<\/pre>\n<p>\u8fd9\u4e2aORA-600\u7684\u4e09\u4e2a\u53c2\u6570\u7684\u542b\u4e49\u5206\u522b\u4e3a\uff1a729\u662f\u9519\u8bef\u7684\u7f16\u53f7\uff0c729\u7684\u9519\u8bef\u548c\u5185\u5b58\u6cc4\u6f0f\u76f8\u5173\uff1b360\u662f\u5185\u5b58\u6cc4\u6f0f\u7684\u5b57\u8282\u6570\uff1bspace leak\uff1a\u5bf9\u4e8e729\u9519\u8bef\uff0c\u7b2c\u4e09\u4e2a\u53c2\u6570\u6c38\u8fdc\u662fspace leak\uff0c\u8868\u660e\u8fd9\u662f\u4e00\u4e2a\u5185\u5b58\u6cc4\u6f0f\u7684\u95ee\u9898\u3002<br \/>\n\u6b63\u5e38\u60c5\u51b5\u4e0b\uff0cOracle\u7684\u8fdb\u7a0b\u4f1a\u81ea\u52a8\u7ba1\u7406\u5f53\u524d\u8fdb\u7a0b\u5185\u5b58\u7684\u5206\u914d\u548c\u91ca\u653e\uff0c\u53ea\u6709\u5f53\u8fdb\u7a0b\u7ed3\u675f\u7684\u65f6\u5019\uff0cOracle\u4f1a\u63a5\u7ba1\u8fdb\u7a0b\u7684\u5185\u5b58\uff0c\u5c06\u5176\u5168\u90e8\u91ca\u653e\u3002\u5728Oracle\u91ca\u653e\u8fdb\u7a0b\u7684\u5185\u5b58\u65f6\uff0c\u4f1a\u68c0\u67e5\u6bcf\u4e2a\u5185\u5b58chunk\u7684\u72b6\u6001\uff0c\u6b63\u5e38\u60c5\u51b5\u4e0b\u6240\u6709\u7684\u72b6\u6001\u90fd\u662ffree\u548cpermanent\uff0c\u5982\u679c\u51fa\u73b0\u4e86\u5176\u4ed6\u72b6\u6001\uff0c\u6bd4\u5982FREEABLE\u6216\u8005RECREATABLE\u7b49\uff0c\u8bf4\u660e\u8fdb\u7a0b\u6ca1\u6709\u53ca\u65f6\u7684\u91ca\u653e\u4e00\u4e9b\u5185\u5b58chunk\uff0c\u8fd9\u5c31\u662f\u6240\u8c13\u7684\u5185\u5b58\u6cc4\u6f0f\u3002<br \/>\n\u8be6\u7ec6\u7684TRACE\u5982\u4e0b\uff1a<\/p>\n<pre lang='SQL'>*** 2011-10-16 04:31:31.115\r\n*** SERVICE NAME:(SYS$USERS) 2011-10-16 04:31:31.114\r\n*** SESSION ID:(6191.1172) 2011-10-16 04:31:31.114\r\n******** ERROR: UGA memory leak detected 360 ********\r\n******************************************************\r\nHEAP DUMP heap name=\"session heap\"  desc=1104473d8\r\n extent sz=0xff80 alt=32767 het=32767 rec=0 flg=2 opc=3\r\n parent=110198a30 owner=7000013ff452bf0 nex=0 xsz=0xff80\r\nEXTENT 0 addr=110490080\r\n  Chunk        110490090 sz=     7800    perm      \"perm           \"  alo=4480\r\n  Chunk        110491f08 sz=    57592    free      \"               \"\r\nEXTENT 1 addr=110480080\r\n  Chunk        110480090 sz=    16184    free      \"               \"\r\n  Chunk        110483fc8 sz=      192    perm      \"perm           \"  alo=192\r\n  Chunk        110484088 sz=    22136    free      \"               \"\r\n  Chunk        110489700 sz=      360    freeable  \"K2I iter       \"\r\nDump of memory from 0x0000000110489700 to 0x0000000110489868\r\n110489700 00B38F00 00000169 00000001 10484088  [.......i.....H@.]\r\n110489710 00000001 04DEFFC0 0000BEA1 0000000A  [................]\r\n110489720 00000008 00000000 00000001 104897E4  [.............H..]\r\n110489730 00000001 10489824 00000000 00000000  [.....H.$........]\r\n.\r\n.\r\n.\r\n110489860 00000000 00000000                    [........]        \r\n  Chunk        110489868 sz=    26520    free      \"               \"\r\nEXTENT 2 addr=110460080\r\n  Chunk        110460090 sz=     2200    perm      \"perm           \"  alo=2200\r\n  Chunk        110460928 sz=    63192    free      \"               \"\r\nEXTENT 3 addr=110450098\r\n  Chunk        1104500a8 sz=    41392    perm      \"perm           \"  alo=41392\r\n  Chunk        11045a258 sz=    23976    free      \"               \"\r\nTotal heap size    =   261544\r\nFREE LISTS:\r\n Bucket 0 size=56\r\n Bucket 1 size=88\r\n Bucket 2 size=152\r\n Bucket 3 size=168\r\n Bucket 4 size=280\r\n Bucket 5 size=432\r\n Bucket 6 size=536\r\n Bucket 7 size=1048\r\n Bucket 8 size=2072\r\n Bucket 9 size=4120\r\n Bucket 10 size=8216\r\n  Chunk        110480090 sz=    16184    free      \"               \"\r\n Bucket 11 size=16408\r\n  Chunk        11045a258 sz=    23976    free      \"               \"\r\n  Chunk        110489868 sz=    26520    free      \"               \"\r\n  Chunk        110484088 sz=    22136    free      \"               \"\r\n Bucket 12 size=32792\r\n  Chunk        110460928 sz=    63192    free      \"               \"\r\n  Chunk        110491f08 sz=    57592    free      \"               \"\r\n Bucket 13 size=65560\r\n Bucket 14 size=131096\r\n Bucket 15 size=262168\r\n Bucket 16 size=524312\r\n Bucket 17 size=2097176\r\nTotal free space   =   209600\r\nUNPINNED RECREATABLE CHUNKS (lru first):\r\nPERMANENT CHUNKS:\r\n  Chunk        110490090 sz=     7800    perm      \"perm           \"  alo=4480\r\n  Chunk        110483fc8 sz=      192    perm      \"perm           \"  alo=192\r\n  Chunk        110460090 sz=     2200    perm      \"perm           \"  alo=2200\r\n  Chunk        1104500a8 sz=    41392    perm      \"perm           \"  alo=41392\r\nPermanent space    =    51584\r\n******************************************************\r\n*** 2011-10-16 04:31:31.116\r\nksedmp: internal or fatal error\r\nORA-00600: internal error code, arguments: [729], [360], [space leak], [], [], [], [], []\r\n----- Call Stack Trace -----\r\ncalling              call     entry                argument values in hex      \r\nlocation             type     point                (? means dubious value)     \r\n-------------------- -------- -------------------- ----------------------------\r\nksedst+001c          bl       ksedst1              088424844 ? 041124844 ?\r\nksedmp+0290          bl       ksedst               104A506E8 ?\r\nksfdmp+0018          bl       03F4BE78             \r\nkgeriv+0108          bl       _ptrgl               \r\nkgesiv+0080          bl       kgeriv               10008FD0C ? 1100CAFF0 ?\r\n                                                   000000000 ? 00000000A ?\r\n                                                   1100CB230 ?\r\nksesic2+0060         bl       kgesiv               110000BF8 ? 104B032A8 ?\r\n                                                   FFFFFFFFFFF9260 ? 000000000 ?\r\n                                                   7000013FF453A10 ?\r\nksmuhe+02dc          bl       ksesic2              2D9000002D9 ? 000000000 ?\r\n                                                   000000168 ? 000000001 ?\r\n                                                   00000000A ? 104A4F2D8 ?\r\n                                                   000000000 ? 000000000 ?\r\nksmugf+01b8          bl       03F49FA0             \r\nksuxds+0c04          bl       01FB5D60             \r\nksudel+0054          bl       ksuxds               7000013FF452BF0 ? 104B032A8 ?\r\nopilof+0c7c          bl       03F49D84             \r\nopiodr+0ae0          bl       _ptrgl               \r\nttcpip+1020          bl       _ptrgl               \r\nopitsk+1124          bl       ttcpip               1100CB0D8 ? FFFFFFFFFFFBBB0 ?\r\n                                                   000000001 ? 000000000 ?\r\n                                                   FFFFFFFFFFFBB30 ? 1100E0428 ?\r\n                                                   000000000 ? 1104B0B70 ?\r\nopiino+0990          bl       opitsk               000000000 ? 000000000 ?\r\nopiodr+0ae0          bl       _ptrgl               \r\nopidrv+0484          bl       01FB7E64             \r\nsou2o+0090           bl       opidrv               3C02AB90DC ? 440660000 ?\r\n                                                   FFFFFFFFFFFF9D0 ?\r\nopimai_real+01bc     bl       01FB5C2C             \r\nmain+0098            bl       opimai_real          000000000 ? 000000000 ?\r\n__start+0098         bl       main                 000000000 ? 000000000 ?\r\n--------------------- Binary Stack Dump ---------------------<\/pre>\n<p>\u5728TRACE\u6587\u4ef6\u4e2d\uff0c\u8fd9\u4e2a\u8bb0\u5f55\u4fe1\u606f\u8868\u660e\u4e86\u5185\u5b58\u6cc4\u6f0f\u7684\u5b58\u5728\uff1a<\/p>\n<pre lang='SQL'>  Chunk        110489700 sz=      360    freeable  \"K2I iter       \"<\/pre>\n<p>\u800c\u5728TRACE\u6587\u4ef6\u4e2d\uff0c\u8fd8\u5b58\u5728opilof\u51fd\u6570\uff0c\u8bf4\u660e\u627e\u4e2a\u4f1a\u8bdd\u5728\u8fdb\u884cLOGOFF\u64cd\u4f5c\u3002\u5176\u5b9e\u5bf9\u4e8e4000\u4ee5\u4e0b\u7684\u5185\u5b58\u6cc4\u6f0f\uff0c\u88ab\u8ba4\u4e3a\u662f\u5b89\u5168\u7684\uff0cOracle\u751a\u81f3\u63d0\u4f9b\u4e86EVENTS 10262\u53ef\u4ee5\u5c4f\u853d\u8fd9\u4e2a\u9519\u8bef\u7684\u4ea7\u751f\u3002\u800c\u5982\u679c\u5728alert\u6587\u4ef6\u4e2d\u53d1\u73b0\u8fd9\u4e2a\u9519\u8bef\u65f6\uff0c\u66fe\u7ecf\u6cc4\u6f0f\u7684\u5185\u5b58\u5df2\u7ecf\u88ab\u91ca\u653e\uff0c\u56e0\u6b64\u8fd9\u4e2a\u95ee\u9898\u4e0d\u4f1a\u5bf9\u5b9e\u4f8b\u7684\u8fd0\u884c\u9020\u6210\u5f71\u54cd\u3002<br \/>\n\u5982\u679c\u9519\u8bef\u9891\u7e41\u53d1\u751f\uff0c\u6216\u8005\u6cc4\u6f0f\u7684\u7a7a\u95f4\u8d85\u8fc74000\u6216\u66f4\u9ad8\uff0c\u53ef\u4ee5\u8fdb\u4e00\u6b65\u53bb\u5206\u6790\uff0c\u6216\u8005\u53bb\u5bfb\u627e\u4e13\u95e8\u7684\u8865\u4e01\uff0cMetalink\u6587\u6863Understanding and Diagnosing ORA-600 [729] Space Leak Errors [ID 403584.1]\u4ecb\u7ecd\u4e86space leak\u76f8\u5173\u7684\u5185\u5bb9\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5ba2\u6237\u6570\u636e\u5e93\u51fa\u73b0ORA-600[729]\u9519\u8bef\u3002 \u8be6\u7ec6\u4fe1\u606f\u5982\u4e0b\uff1a Sun Oct 16 04:31:31 2011 Errors in file \/u01\/app\/oracle\/admin\/db1\/udump\/db1_ora_6459722.trc: ORA-00600: internal error code, arguments: [729], [360], [space leak], [], [], [], [], [] \u8fd9\u4e2aORA-600\u7684\u4e09\u4e2a\u53c2\u6570\u7684\u542b\u4e49\u5206\u522b\u4e3a\uff1a729\u662f\u9519\u8bef\u7684\u7f16\u53f7\uff0c729\u7684\u9519\u8bef\u548c\u5185\u5b58\u6cc4\u6f0f\u76f8\u5173\uff1b360\u662f\u5185\u5b58\u6cc4\u6f0f\u7684\u5b57\u8282\u6570\uff1bspace leak\uff1a\u5bf9\u4e8e729\u9519\u8bef\uff0c\u7b2c\u4e09\u4e2a\u53c2\u6570\u6c38\u8fdc\u662fspace leak\uff0c\u8868\u660e\u8fd9\u662f\u4e00\u4e2a\u5185\u5b58\u6cc4\u6f0f\u7684\u95ee\u9898\u3002 \u6b63\u5e38\u60c5\u51b5\u4e0b\uff0cOracle\u7684\u8fdb\u7a0b\u4f1a\u81ea\u52a8\u7ba1\u7406\u5f53\u524d\u8fdb\u7a0b\u5185\u5b58\u7684\u5206\u914d\u548c\u91ca\u653e\uff0c\u53ea\u6709\u5f53\u8fdb\u7a0b\u7ed3\u675f\u7684\u65f6\u5019\uff0cOracle\u4f1a\u63a5\u7ba1\u8fdb\u7a0b\u7684\u5185\u5b58\uff0c\u5c06\u5176\u5168\u90e8\u91ca\u653e\u3002\u5728Oracle\u91ca\u653e\u8fdb\u7a0b\u7684\u5185\u5b58\u65f6\uff0c\u4f1a\u68c0\u67e5\u6bcf\u4e2a\u5185\u5b58chunk\u7684\u72b6\u6001\uff0c\u6b63\u5e38\u60c5\u51b5\u4e0b\u6240\u6709\u7684\u72b6\u6001\u90fd\u662ffree\u548cpermanent\uff0c\u5982\u679c\u51fa\u73b0\u4e86\u5176\u4ed6\u72b6\u6001\uff0c\u6bd4\u5982FREEABLE\u6216\u8005RECREATABLE\u7b49\uff0c\u8bf4\u660e\u8fdb\u7a0b\u6ca1\u6709\u53ca\u65f6\u7684\u91ca\u653e\u4e00\u4e9b\u5185\u5b58chunk\uff0c\u8fd9\u5c31\u662f\u6240\u8c13\u7684\u5185\u5b58\u6cc4\u6f0f\u3002 \u8be6\u7ec6\u7684TRACE\u5982\u4e0b\uff1a *** 2011-10-16 04:31:31.115 *** SERVICE NAME:(SYS$USERS) 2011-10-16 04:31:31.114 *** SESSION &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=223\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5],"tags":[159,8,160],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-3B","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/223"}],"collection":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=223"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/223\/revisions"}],"predecessor-version":[{"id":224,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/223\/revisions\/224"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=223"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=223"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=223"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}