\u58f9\u3001oracle\u8ddf\u8e64\u6587\u4ef6
\n\u00a0\u00a0\u00a0 Oracle\u8ddf\u8e64\u6587\u4ef6\u5206\u70ba\u4e09\u7a2e\u985e\u578b\u3002
\n\u00a0\u00a0\u00a0 1.\u00a0 \u58f9\u7a2e\u662f\u5f8c\u81fa\u5831\u8b66\u65e5\u8a8c\u6587\u4ef6\uff0c\u8a18\u9304\u6578\u64da\u5eab\u5728\u555f\u52d5\u3001\u95dc\u9589\u548c\u904b\u884c\u671f\u9593\u5f8c\u81fa\u9032\u7a0b\u7684\u6d3b\u52d5\u60c5\u6cc1\uff0c\u5982\u8868\u7a7a\u9593\u5275\u5efa\u3001\u56de\u6efe\u6bb5\u5275\u5efa\u3001\u67d0\u4e9balter\u547d\u4ee4\u3001\u65e5\u8a8c\u5207\u63db\u3001\u932f\u8aa4\u6d88\u606f\u7b49\u3002
\n\u00a0\u00a0\u00a0 \u5728\u6578\u64da\u5eab\u51fa\u73fe\u6545\u969c\u6642\uff0c\u61c9\u9996\u5148\u67e5\u770b\u8a72\u6587\u4ef6\uff0c\u4f46\u6587\u4ef6\u4e2d\u7684\u4fe1\u606f\u8207\u4efb\u4f55\u932f\u8aa4\u72c0\u614b\u6c92\u6709\u5fc5\u7136\u7684\u806f\u7cfb\u3002\u5f8c\u81fa\u5831\u8b66\u65e5\u8a8c\u6587\u4ef6\u4fdd\u5b58BACKGROUND_DUMP_DEST\u53c3\u6578\u6307\u5b9a\u7684\u76ee\u9304\u4e2d\uff0c\u6587\u4ef6\u683c\u5f0f\u70baSIDALRT.LOG\u3002
\n\u00a0\u00a0\u00a0 2. \u53e6\u58f9\u7a2e\u985e\u578b\u662fDBWR\u3001LGWR\u3001SMON\u7b49\u5f8c\u81fa\u9032\u7a0b\u5275\u5efa\u7684\u5f8c\u81fa\u8ddf\u8e64\u6587\u4ef6\u3002
\n\u00a0\u00a0\u00a0 \u5f8c\u81fa\u8ddf\u8e64\u6587\u4ef6\u6839\u64da\u5f8c\u81fa\u9032\u7a0b\u904b\u884c\u60c5\u6cc1\u7522\u751f\uff0c\u5f8c\u81fa\u8ddf\u8e64\u6587\u4ef6\u4e5f\u4fdd\u5b58\u5728BACKGROUND_DUMP_DEST\u53c3\u6578\u6307\u5b9a\u7684\u76ee\u9304\u4e2d\uff0c\u6587\u4ef6\u683c\u5f0f\u70basiddbwr.trc\u3001sidsmon.trc\u7b49\u3002
\n\u00a0\u00a0\u00a0 3. \u9084\u6709\u58f9\u7a2e\u985e\u578b\u662f\u7531\u9023\u63a5\u5230Oracle\u7684\u7528\u6236\u9032\u7a0b\uff08Server Processes\uff09\u751f\u6210\u7684\u7528\u6236\u8ddf\u8e64\u6587\u4ef6\u3002
\n\u00a0\u00a0\u00a0 \u9019\u4e9b\u6587\u4ef6\u50c5\u5728\u7528\u6236\u6703\u8a71\u671f\u9593\u9047\u5230\u932f\u8aa4\u6642\u7522\u751f\u3002\u6b64\u5916\uff0c\u7528\u6236\u53ef\u4ee5\u901a\u904e\u57f7\u884coracle\u8ddf\u8e64\u4e8b\u4ef6\uff08\u898b\u5f8c\u9762\uff09\u4f86\u751f\u6210\u8a72\u985e\u6587\u4ef6\uff0c\u7528\u6236\u8ddf\u8e64\u6587\u4ef6\u4fdd\u5b58\u5728USER_DUMP_DEST\u53c3\u6578\u6307\u5b9a\u7684\u76ee\u9304\u4e2d\uff0c\u6587\u4ef6\u683c\u5f0f\u70baoraxxxxx.trc\uff0cxxxxx\u70ba\u5275\u5efa\u6587\u4ef6\u7684\u9032\u7a0b\u865f\uff08\u6216\u7dda\u7a0b\u865f\uff09\u3002
\n\u00a0\u00a0\u00a0 \u4e8c\u3001Oracle\u8ddf\u8e64\u4e8b\u4ef6
\n\u00a0\u00a0\u00a0 Oracle\u63d0\u4f9b\u4e86\u58f9\u985e\u547d\u4ee4\uff0c\u53ef\u4ee5\u5c07Oracle\u5404\u985e\u5167\u90e8\u7d50\u69cb\u4e2d\u6240\u5305\u542b\u7684\u4fe1\u606f\u8f49\u5132\uff08dump\uff09\u5230\u8ddf\u8e64\u6587\u4ef6\u4e2d\uff0c\u4ee5\u4fbf\u7528\u6236\u80fd\u6839\u64da\u6587\u4ef6\u5167\u5bb9\u4f86\u89e3\u6c7a\u5404\u7a2e\u6545\u969c\u3002
\n\u00a0\u00a0\u00a0 \u8a2d\u7f6e\u8ddf\u8e64\u4e8b\u4ef6\u6709\u5169\u7a2e\u65b9\u6cd5\uff0c\u58f9\u7a2e\u662f\u5728init.ora\u6587\u4ef6\u4e2d\u8a2d\u7f6e\u4e8b\u4ef6\uff0c\u9019\u6a23open\u6578\u64da\u5eab\u5f8c\uff0c\u5c07\u5f71\u97ff\u5230\u6240\u6709\u7684\u6703\u8a71\u3002\u8a2d\u7f6e\u683c\u5f0f\u5982\u4e0b\uff1a
\n\u00a0\u00a0\u00a0 EVENT=”eventnumber trace name eventname [forever,] [level levelnumber] : \u2026\u2026” \u901a\u904e\uff1a\u7b26\u865f\uff0c\u53ef\u4ee5\u9023\u7e8c\u8a2d\u7f6e\u591a\u500b\u4e8b\u4ef6\uff0c\u4e5f\u53ef\u4ee5\u901a\u904e\u9023\u7e8c\u4f7f\u7528event\u4f86\u8a2d\u7f6e\u591a\u500b\u4e8b\u4ef6\u3002
\n\u00a0\u00a0\u00a0 \u53e6\u58f9\u7a2e\u65b9\u6cd5\u662f\u5728\u6703\u8a71\u904e\u7a0b\u4e2d\u4f7f\u7528alter session set events\u547d\u4ee4\uff0c\u53ea\u5c0d\u7576\u524d\u6703\u8a71\u6709\u5f71\u97ff\u3002\u8a2d\u7f6e\u683c\u5f0f\u5982\u4e0b\uff1a
\n\u00a0\u00a0\u00a0 alter session set events ‘[eventnumber|immediate] trace name eventname [forever] [, level levelnumber] : \u2026\u2026’
\n\u00a0\u00a0\u00a0 \u901a\u904e\uff1a\u7b26\u865f\uff0c\u53ef\u4ee5\u9023\u7e8c\u8a2d\u7f6e\u591a\u500b\u4e8b\u4ef6\uff0c\u4e5f\u53ef\u4ee5\u901a\u904e\u9023\u7e8c\u4f7f\u7528alter session set events \u4f86\u8a2d\u7f6e\u591a\u500b\u4e8b\u4ef6\u3002
\n\u00a0\u00a0\u00a0 \u683c\u5f0f\u8aaa\u660e\uff1aeventnumber\u6307\u89f8\u767cdump\u7684\u4e8b\u4ef6\u865f\uff0c\u4e8b\u4ef6\u865f\u53ef\u4ee5\u662fOracle\u932f\u8aa4\u865f\uff08\u51fa\u73fe\u76f8\u61c9\u932f\u8aa4\u6642\u8ddf\u8e64\u6307\u5b9a\u7684\u4e8b\u4ef6\uff09\u6216oralce\u5167\u90e8\u4e8b\u4ef6\u865f\uff0c\u5167\u90e8\u4e8b\u4ef6\u865f\u572810000\u523010999\u4e4b\u9593\uff0c\u4e0d\u80fd\u8207immediate\u95dc\u9375\u5b57\u540c\u7528\u3002
\n\u00a0\u00a0\u00a0 immediate\u95dc\u9375\u5b57\u8868\u793a\u547d\u4ee4\u767c\u51fa\u5f8c\uff0c\u7acb\u5373\u5c07\u6307\u5b9a\u7684\u7d50\u69cbdump\u5230\u8ddf\u8e64\u6587\u4ef6\u4e2d\uff0c\u9019\u500b\u95dc\u9375\u5b57\u53ea\u7528\u5728alter session\u8a9e\u53e5\u4e2d\uff0c\u4e26\u4e14\u4e0d\u80fd\u8207 eventnumber\u3001forever\u95dc\u9375\u5b57\u540c\u7528\u3002
\n\u00a0\u00a0\u00a0 trace name \u662f\u95dc\u9375\u5b57\u3002
\n\u00a0\u00a0\u00a0 eventname\u6307\u4e8b\u4ef6\u540d\u7a31\uff08\u898b\u5f8c\u9762\uff09\uff0c\u5373\u8981\u9032\u884cdump\u7684\u5be6\u969b\u7d50\u69cb\u540d\u3002\u82e5eventname\u70bacontext\uff0c\u5247\u6307\u6839\u64da\u5167\u90e8\u4e8b\u4ef6\u865f\u9032\u884c\u8ddf\u8e64\u3002
\n\u00a0\u00a0\u00a0 forever\u95dc\u9375\u5b57\u8868\u793a\u4e8b\u4ef6\u5728\u5be6\u4f8b\u6216\u6703\u8a71\u7684\u5468\u671f\u5167\u4fdd\u6301\u6709\u6548\u72c0\u614b\uff0c\u4e0d\u80fd\u8207immediate\u540c\u7528\u3002
\n\u00a0\u00a0\u00a0 levelnumber\u8868\u793a\u4e8b\u4ef6\u7d1a\u5225\u865f\uff0c\u58f9\u822c\u5f9e1\u523010\uff0c1\u8868\u793a\u53eadump\u7d50\u69cb\u982d\u90e8\u4fe1\u606f\uff0c10\u8868\u793adump\u7d50\u69cb\u7684\u6240\u6709\u4fe1\u606f\u3002
\n\u00a0\u00a0\u00a0 \u8ddf\u8e64\u4e8b\u4ef6\u8aaa\u660e\uff1a
\n\u00a0\u00a0\u00a0 1\u3001buffers\u4e8b\u4ef6\uff1adump SGA\u7de9\u6c96\u5340\u4e2d\u7684db buffer\u7d50\u69cb
\n\u00a0\u00a0\u00a0 alter session set events ‘immediate trace name buffers level 1’; –\u8868\u793adump\u7de9\u6c96\u5340\u7684\u982d\u90e8\u3002
\n\u00a0\u00a0\u00a0 2\u3001blockdump\u4e8b\u4ef6\uff1adump\u6578\u64da\u6587\u4ef6\u3001\u7d22\u5f15\u6587\u4ef6\u3001\u56de\u6efe\u6bb5\u6587\u4ef6\u7d50\u69cb
\n\u00a0\u00a0\u00a0 alter session set events ‘immediate trace name blockdump level 66666’; –\u8868\u793adump\u584a\u5730\u5740\u70ba6666\u7684\u6578\u64da\u584a\u3002
\n\u00a0\u00a0\u00a0 \u5728Oracle 8i\u4ee5\u5f8c\u8a72\u547d\u4ee4\u5df2\u6539\u70ba\uff1a
\n\u00a0\u00a0\u00a0 alter system dump datafile 11 block 9; –\u8868\u793adump\u6578\u64da\u6587\u4ef6\u865f\u70ba11\u4e2d\u7684\u7b2c9\u500b\u6578\u64da\u584a\u3002
\n\u00a0\u00a0\u00a0 3\u3001controlf\u4e8b\u4ef6\uff1adump\u63a7\u5236\u6587\u4ef6\u7d50\u69cb
\n\u00a0\u00a0\u00a0 alter session set events ‘immediate trace name controlf level 10’; –\u8868\u793adump\u63a7\u5236\u6587\u4ef6\u7684\u6240\u6709\u5167\u5bb9\u3002
\n\u00a0\u00a0\u00a0 4\u3001locks\u4e8b\u4ef6\uff1adump LCK\u9032\u7a0b\u7684\u9396\u4fe1\u606f
\n\u00a0\u00a0\u00a0 alter session set events ‘immediate trace name locks level 5’;
\n\u00a0\u00a0\u00a0 5\u3001redohdr\u4e8b\u4ef6\uff1adump redo\u65e5\u8a8c\u7684\u982d\u90e8\u4fe1\u606f
\n\u00a0\u00a0\u00a0 alter session set events ‘immediate trace name redohdr level 1’; –\u8868\u793adump redo\u65e5\u8a8c\u982d\u90e8\u7684\u63a7\u5236\u6587\u4ef6\u9805\u3002
\n\u00a0\u00a0\u00a0 alter session set events ‘immediate trace name redohdr level 2’; –\u8868\u793adump redo\u65e5\u8a8c\u7684\u901a\u7528\u6587\u4ef6\u982d\u3002
\n\u00a0\u00a0\u00a0 alter session set events ‘immediate trace name redohdr level 10’; –\u8868\u793adump redo\u65e5\u8a8c\u7684\u5b8c\u6574\u6587\u4ef6\u982d\u3002
\n\u00a0\u00a0\u00a0 \u8a3b\u610f\uff1aredo\u65e5\u8a8c\u7684\u5167\u5bb9dump\u53ef\u4ee5\u91c7\u7528\u4e0b\u9762\u7684\u8a9e\u53e5\uff1a
\n\u00a0\u00a0\u00a0 alter system dump logfile ‘logfilename’;
\n\u00a0\u00a0\u00a0 6\u3001loghist\u4e8b\u4ef6\uff1adump\u63a7\u5236\u6587\u4ef6\u4e2d\u7684\u65e5\u8a8c\u6b77\u53f2\u9805
\n\u00a0\u00a0\u00a0 alter session set events ‘immediate trace name loghist level 1’; –\u8868\u793a\u53eadump\u6700\u65e9\u548c\u6700\u9072\u7684\u65e5\u8a8c\u6b77\u53f2\u9805\u3002
\n\u00a0\u00a0\u00a0 levelnumber\u5927\u65bc\u7b49\u65bc2\u6642\uff0c\u8868\u793a2\u7684levelnumber\u6b21\u65b9\u500b\u65e5\u8a8c\u6b77\u53f2\u9805\u3002
\n\u00a0\u00a0\u00a0 alter session set events ‘immediate trace name loghist level 4’; –\u8868\u793adump 16\u500b\u65e5\u8a8c\u6b77\u53f2\u9805\u3002
\n\u00a0\u00a0\u00a0 7\u3001file_hdrs\u4e8b\u4ef6\uff1adump \u6240\u6709\u6578\u64da\u6587\u4ef6\u7684\u982d\u90e8\u4fe1\u606f
\n\u00a0\u00a0\u00a0 alter session set events ‘immediate trace name file_hdrs level 1’; –\u8868\u793adump \u6240\u6709\u6578\u64da\u6587\u4ef6\u982d\u90e8\u7684\u63a7\u5236\u6587\u4ef6\u9805\u3002
\n\u00a0\u00a0\u00a0 alter session set events ‘immediate trace name file_hdrs level 2’; –\u8868\u793adump \u6240\u6709\u6578\u64da\u6587\u4ef6\u7684\u901a\u7528\u6587\u4ef6\u982d\u3002
\n\u00a0\u00a0\u00a0 alter session set events ‘immediate trace name file_hdrs level 10’; –\u8868\u793adump \u6240\u6709\u6578\u64da\u6587\u4ef6\u7684\u5b8c\u6574\u6587\u4ef6\u982d\u3002
\n\u00a0\u00a0\u00a0 8\u3001errorstack\u4e8b\u4ef6\uff1adump \u932f\u8aa4\u68e7\u4fe1\u606f\uff0c\u901a\u5e38Oracle\u767c\u751f\u932f\u8aa4\u6642\u524d\u81fa\u9032\u7a0b\u5c07\u5f97\u5230\u58f9\u689d\u932f\u8aa4\u4fe1\u606f\uff0c\u4f46\u67d0\u4e9b\u60c5\u6cc1\u4e0b\u5f97\u4e0d\u5230\u932f\u8aa4\u4fe1\u606f\uff0c\u53ef\u4ee5\u91c7\u7528\u9019\u7a2e\u65b9\u5f0f\u5f97\u5230Oracle\u932f\u8aa4\u3002
\n\u00a0\u00a0\u00a0 alter session set events ‘604 trace name errorstack forever’; –\u8868\u793a\u7576\u51fa\u73fe604\u932f\u8aa4\u6642\uff0cdump \u932f\u8aa4\u68e7\u548c\u9032\u7a0b\u68e7\u3002
\n\u00a0\u00a0\u00a0 9\u3001systemstate\u4e8b\u4ef6\uff1adump\u6240\u6709\u7cfb\u7d71\u72c0\u614b\u548c\u9032\u7a0b\u72c0\u614b
\n\u00a0\u00a0\u00a0 alter session set events ‘immediate trace name systemstate level 10’; –\u8868\u793adump \u6240\u6709\u7cfb\u7d71\u72c0\u614b\u548c\u9032\u7a0b\u72c0\u614b\u3002
\n\u00a0\u00a0\u00a0 10\u3001coalesec\u4e8b\u4ef6\uff1adump\u6307\u5b9a\u8868\u7a7a\u9593\u4e2d\u7684\u81ea\u7531\u5340\u9593
\n\u00a0\u00a0\u00a0 levelnumber\u4ee5\u5341\u516d\u9032\u5236\u8868\u793a\u6642\uff0c\u5169\u500b\u9ad8\u4f4d\u5b57\u7bc0\u8868\u793a\u81ea\u7531\u5340\u9593\u6578\u76ee\uff0c\u5169\u500b\u4f4e\u4f4d\u5b57\u7bc0\u8868\u793a\u8868\u7a7a\u9593\u865f\uff0c\u59820x00050000\u8868\u793adump\u7cfb\u7d71\u8868\u7a7a\u9593\u4e2d\u76845\u500b\u81ea\u7531\u5340\u9593\uff0c\u8f49\u63db\u6210\u5341\u9032\u5236\u5c31\u662f327680\uff0c\u5373\uff1a
\n\u00a0\u00a0\u00a0 alter session set events ‘immediate trace name coalesec level 327680’;
\n\u00a0\u00a0\u00a0 11\u3001processsate\u4e8b\u4ef6\uff1adump\u9032\u7a0b\u72c0\u614b
\n\u00a0\u00a0\u00a0 alter session set events ‘immediate trace name processsate level 10’;
\n\u00a0\u00a0\u00a0 12\u3001library_cache\u4e8b\u4ef6\uff1adump library cache\u4fe1\u606f
\n\u00a0\u00a0\u00a0 alter session set events ‘immediate trace name library_cache level 10’;
\n\u00a0\u00a0\u00a0 13\u3001heapdump\u4e8b\u4ef6\uff1adump PGA\u3001SGA\u3001UGA\u4e2d\u7684\u4fe1\u606f
\n\u00a0\u00a0\u00a0 alter session set events ‘immediate trace name heapdump level 1’;
\n\u00a0\u00a0\u00a0 14\u3001row_cache\u4e8b\u4ef6\uff1adump\u6578\u64da\u5b57\u5178\u7de9\u6c96\u5340\u4e2d\u7684\u4fe1\u606f
\n\u00a0\u00a0\u00a0 alter session set events ‘immediate trace name row_cache level 1’;<\/p>\n","protected":false},"excerpt":{"rendered":"
\u58f9\u3001oracle\u8ddf\u8e64\u6587\u4ef6 \u00a0\u00a0\u00a0 Oracle\u8ddf\u8e64\u6587\u4ef6\u5206\u70ba\u4e09\u7a2e\u985e\u578b\u3002 \u00a0\u00a0\u00a0 1.\u00a0 \u58f9\u7a2e\u662f\u5f8c\u81fa\u5831\u8b66\u65e5\u8a8c\u6587\u4ef6\uff0c […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[2748,750,708],"class_list":["post-1801","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-oracle","tag-750","tag-708"],"_links":{"self":[{"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/posts\/1801","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/comments?post=1801"}],"version-history":[{"count":0,"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/posts\/1801\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/media?parent=1801"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/categories?post=1801"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/tags?post=1801"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}