{"id":932,"date":"2022-07-03T22:46:44","date_gmt":"2022-07-03T14:46:44","guid":{"rendered":"http:\/\/dba.qishuo.xin\/?p=932"},"modified":"2023-06-03T01:33:30","modified_gmt":"2023-06-02T17:33:30","slug":"oracle%e5%8f%82%e6%95%b0%e6%9f%a5%e7%9c%8b%e6%8c%81%e7%bb%ad%e6%9b%b4%e6%96%b0%e4%b8%ad","status":"publish","type":"post","link":"http:\/\/dba.qishuo.xin\/?p=932","title":{"rendered":"Oracle\u53c2\u6570\u67e5\u770b(\u6301\u7eed\u66f4\u65b0\u4e2d)"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 ez-toc-wrap-right counter-hierarchy ez-toc-counter ez-toc-light-blue ez-toc-container-direction\">\n<label for=\"ez-toc-cssicon-toggle-item-69f24f2c7d442\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-69f24f2c7d442\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#1_%E6%95%B0%E6%8D%AE%E5%BA%93%E6%80%BB%E4%BD%93%E8%BF%90%E8%A1%8C%E6%83%85%E5%86%B5\" >1. \u6570\u636e\u5e93\u603b\u4f53\u8fd0\u884c\u60c5\u51b5<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#11_%E6%95%B0%E6%8D%AE%E5%BA%93%E8%BF%90%E8%A1%8C%E6%97%B6%E9%97%B4%E6%9F%A5%E8%AF%A2\" >1.1. \u6570\u636e\u5e93\u8fd0\u884c\u65f6\u95f4\u67e5\u8be2<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#12_%E5%BD%93%E5%89%8D%E6%97%B6%E5%88%BB%E6%B4%BB%E5%8A%A8%E7%9A%84%E4%BC%9A%E8%AF%9D%E6%8C%89%E7%94%A8%E6%88%B7%E7%BB%9F%E8%AE%A1\" >1.2. \u5f53\u524d\u65f6\u523b\u6d3b\u52a8\u7684\u4f1a\u8bdd(\u6309\u7528\u6237\u7edf\u8ba1)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#13_%E6%9F%A5%E8%AF%A2%E4%BC%9A%E8%AF%9D%E7%9A%84%E7%AD%89%E5%BE%85%E4%BA%8B%E4%BB%B6\" >1.3. \u67e5\u8be2\u4f1a\u8bdd\u7684\u7b49\u5f85\u4e8b\u4ef6<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#14_%E5%BD%93%E5%89%8D%E6%97%B6%E5%88%BB%E6%B4%BB%E5%8A%A8%E4%BC%9A%E8%AF%9D%E6%AD%A3%E5%9C%A8%E6%89%A7%E8%A1%8C%E7%9A%84SQL\" >1.4. \u5f53\u524d\u65f6\u523b\u6d3b\u52a8\u4f1a\u8bdd\u6b63\u5728\u6267\u884c\u7684SQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#15_%E6%95%B0%E6%8D%AE%E5%BA%93%E9%95%BF%E6%97%B6%E9%97%B4%E6%89%A7%E8%A1%8C%E7%9A%84SQL\" >1.5. \u6570\u636e\u5e93\u957f\u65f6\u95f4\u6267\u884c\u7684SQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#16_%E6%9F%A5%E7%9C%8B%E6%95%B0%E6%8D%AE%E5%BA%93%E5%8E%86%E5%8F%B2%E7%9A%84%E8%B4%9F%E8%BD%BD\" >1.6. \u67e5\u770b\u6570\u636e\u5e93\u5386\u53f2\u7684\u8d1f\u8f7d<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#17_%E6%9F%A5%E8%AF%A2%E6%89%A7%E8%A1%8C%E6%85%A2%E7%9A%84SQL\" >1.7. \u67e5\u8be2\u6267\u884c\u6162\u7684SQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#18_%E6%9F%A5%E8%AF%A2%E6%97%A5%E5%BF%97%E5%88%87%E6%8D%A2%E9%A2%91%E7%8E%87\" >1.8. \u67e5\u8be2\u65e5\u5fd7\u5207\u6362\u9891\u7387<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#19_%E6%9F%A5%E7%9C%8B%E9%97%AA%E5%9B%9E%E5%8C%BA%E7%9A%84%E4%BD%BF%E7%94%A8%E7%8E%87\" >1.9. \u67e5\u770b\u95ea\u56de\u533a\u7684\u4f7f\u7528\u7387<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#110_%E5%AE%B9%E5%99%A8%E6%95%B0%E6%8D%AE%E5%BA%93%E5%AD%97%E7%AC%A6%E9%9B%86\" >1.10. \u5bb9\u5668\u6570\u636e\u5e93\u5b57\u7b26\u96c6<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#111_%E6%9F%A5%E7%9C%8B%E6%95%B0%E6%8D%AE%E5%BA%93%E5%AE%89%E8%A3%85%E7%9A%84%E7%BB%84%E4%BB%B6\" >1.11. \u67e5\u770b\u6570\u636e\u5e93\u5b89\u88c5\u7684\u7ec4\u4ef6<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#112_%E6%9F%A5%E7%9C%8B%E6%95%B0%E6%8D%AE%E5%BA%93%E7%89%88%E6%9C%AC%E5%8F%B7\" >1.12. \u67e5\u770b\u6570\u636e\u5e93\u7248\u672c\u53f7<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#113_%E6%9F%A5%E7%9C%8B%E6%95%B0%E6%8D%AE%E5%BA%93%E8%A1%A5%E4%B8%81\" >1.13. \u67e5\u770b\u6570\u636e\u5e93\u8865\u4e01<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#2_%E5%BD%93%E5%89%8D%E4%BC%9A%E8%AF%9D\" >2. \u5f53\u524d\u4f1a\u8bdd<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#21_%E6%9F%A5%E7%9C%8B%E5%BD%93%E5%89%8D%E7%94%A8%E6%88%B7%E7%9A%84sid%E5%92%8Cserial\" >2.1. \u67e5\u770b\u5f53\u524d\u7528\u6237\u7684sid\u548cserial<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#22_%E6%9F%A5%E7%9C%8B%E5%BD%93%E5%89%8D%E4%BC%9A%E8%AF%9D%E7%9A%84spid_%E4%B8%8E_trace_file%E8%B7%AF%E5%BE%84\" >2.2. \u67e5\u770b\u5f53\u524d\u4f1a\u8bdd\u7684spid \u4e0e trace file\u8def\u5f84<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#23_%E6%A0%B9%E6%8D%AEsession%E7%9B%B8%E5%85%B3%E4%BF%A1%E6%81%AF%E6%9F%A5%E8%AF%A2%E6%93%8D%E4%BD%9C%E7%B3%BB%E7%BB%9F%E8%BF%9B%E7%A8%8B%E5%8F%B7\" >2.3. \u6839\u636esession\u76f8\u5173\u4fe1\u606f\u67e5\u8be2\u64cd\u4f5c\u7cfb\u7edf\u8fdb\u7a0b\u53f7<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#24_%E5%B7%B2%E7%9F%A5spid%EF%BC%8C%E6%9F%A5%E7%9C%8B%E5%BD%93%E5%89%8D%E6%AD%A3%E5%9C%A8%E6%89%A7%E8%A1%8C%E6%88%96%E6%9C%80%E8%BF%91%E4%B8%80%E6%AC%A1%E6%89%A7%E8%A1%8C%E7%9A%84%E8%AF%AD%E5%8F%A5\" >2.4. \u5df2\u77e5spid\uff0c\u67e5\u770b\u5f53\u524d\u6b63\u5728\u6267\u884c\u6216\u6700\u8fd1\u4e00\u6b21\u6267\u884c\u7684\u8bed\u53e5<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#25_%E6%9F%A5%E8%AF%A2%E4%BC%9A%E8%AF%9D%E6%89%93%E5%BC%80%E7%9A%84%E6%B8%B8%E6%A0%87%E6%95%B0\" >2.5. \u67e5\u8be2\u4f1a\u8bdd\u6253\u5f00\u7684\u6e38\u6807\u6570<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-21\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#3_%E9%98%BB%E5%A1%9E%E4%B8%8E%E9%94%81\" >3. \u963b\u585e\u4e0e\u9501<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-22\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#31_%E6%9F%A5%E7%9C%8B%E5%BD%93%E5%89%8D%E9%98%BB%E5%A1%9E%E4%B8%8E%E8%A2%AB%E9%98%BB%E5%A1%9E%E7%9A%84%E4%BC%9A%E8%AF%9D\" >3.1. \u67e5\u770b\u5f53\u524d\u963b\u585e\u4e0e\u88ab\u963b\u585e\u7684\u4f1a\u8bdd<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-23\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#32_%E6%9F%A5%E8%AF%A2%E9%94%81%E7%9A%84%E6%BA%90%E5%A4%B4SID\" >3.2. \u67e5\u8be2\u9501\u7684\u6e90\u5934SID<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-24\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#33_%E6%9F%A5%E8%AF%A2%E6%95%B0%E6%8D%AE%E5%BA%93%E4%B8%AD%E8%A2%AB%E9%94%81%E7%9A%84%E5%AF%B9%E8%B1%A1\" >3.3. \u67e5\u8be2\u6570\u636e\u5e93\u4e2d\u88ab\u9501\u7684\u5bf9\u8c61<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-25\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#4_%E8%A1%A8%E7%A9%BA%E9%97%B4%E4%B8%8E%E6%95%B0%E6%8D%AE%E5%BA%93%E6%96%87%E4%BB%B6\" >4. \u8868\u7a7a\u95f4\u4e0e\u6570\u636e\u5e93\u6587\u4ef6<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-26\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#41_%E6%9F%A5%E7%9C%8B%E6%95%B0%E6%8D%AE%E5%BA%93%E8%A1%A8%E7%A9%BA%E9%97%B4\" >4.1. \u67e5\u770b\u6570\u636e\u5e93\u8868\u7a7a\u95f4<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-27\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#42_%E6%9F%A5%E7%9C%8B%E6%95%B0%E6%8D%AE%E5%BA%93undo%E8%A1%A8%E7%A9%BA%E9%97%B4%E6%89%80%E5%AF%B9%E5%BA%94%E7%9A%84%E6%95%B0%E6%8D%AE%E6%96%87%E4%BB%B6\" >4.2. \u67e5\u770b\u6570\u636e\u5e93undo\u8868\u7a7a\u95f4\u6240\u5bf9\u5e94\u7684\u6570\u636e\u6587\u4ef6<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-28\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#43_%E6%9F%A5%E7%9C%8B%E6%95%B0%E6%8D%AE%E5%BA%93%E6%B0%B8%E4%B9%85%E8%A1%A8%E7%A9%BA%E9%97%B4%E6%89%80%E5%AF%B9%E5%BA%94%E7%9A%84%E6%95%B0%E6%8D%AE%E6%96%87%E4%BB%B6\" >4.3. \u67e5\u770b\u6570\u636e\u5e93\u6c38\u4e45\u8868\u7a7a\u95f4\u6240\u5bf9\u5e94\u7684\u6570\u636e\u6587\u4ef6<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-29\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#44_%E6%9F%A5%E7%9C%8B%E6%95%B0%E6%8D%AE%E5%BA%93%E4%B8%B4%E6%97%B6%E8%A1%A8%E7%A9%BA%E9%97%B4%E6%89%80%E5%AF%B9%E5%BA%94%E7%9A%84%E6%95%B0%E6%8D%AE%E6%96%87%E4%BB%B6\" >4.4. \u67e5\u770b\u6570\u636e\u5e93\u4e34\u65f6\u8868\u7a7a\u95f4\u6240\u5bf9\u5e94\u7684\u6570\u636e\u6587\u4ef6<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-30\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#45_%E6%9F%A5%E7%9C%8B%E6%95%B0%E6%8D%AE%E5%BA%93%E8%81%94%E6%9C%BA%E9%87%8D%E5%81%9A%E6%97%A5%E5%BF%97%E6%96%87%E4%BB%B6%E6%89%80%E5%AF%B9%E5%BA%94%E7%9A%84%E6%95%B0%E6%8D%AE%E6%96%87%E4%BB%B6\" >4.5. \u67e5\u770b\u6570\u636e\u5e93\u8054\u673a\u91cd\u505a\u65e5\u5fd7\u6587\u4ef6\u6240\u5bf9\u5e94\u7684\u6570\u636e\u6587\u4ef6<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-31\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#46_%E6%9F%A5%E7%9C%8B%E6%95%B0%E6%8D%AE%E5%BA%93%E5%BD%92%E6%A1%A3%E6%97%A5%E5%BF%97%E6%96%87%E4%BB%B6%E6%89%80%E5%AF%B9%E5%BA%94%E7%9A%84%E6%95%B0%E6%8D%AE%E6%96%87%E4%BB%B6\" >4.6. \u67e5\u770b\u6570\u636e\u5e93\u5f52\u6863\u65e5\u5fd7\u6587\u4ef6\u6240\u5bf9\u5e94\u7684\u6570\u636e\u6587\u4ef6<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-32\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#47_%E6%9F%A5%E8%AF%A2%E8%A1%A8%E7%A9%BA%E9%97%B4%E4%BD%BF%E7%94%A8%E5%A4%A7%E5%B0%8F%E4%B8%8E%E5%89%A9%E4%BD%99%E5%AE%B9%E9%87%8F\" >4.7. \u67e5\u8be2\u8868\u7a7a\u95f4\u4f7f\u7528\u5927\u5c0f\u4e0e\u5269\u4f59\u5bb9\u91cf<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-33\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#48_%E6%9F%A5%E8%AF%A2%E6%AD%A3%E5%9C%A8%E4%BD%BF%E7%94%A8%E5%9B%9E%E6%BB%9A%E6%AE%B5UNDO%E7%9A%84%E4%BC%9A%E8%AF%9D%E5%8D%95%E5%AE%9E%E4%BE%8B\" >4.8. \u67e5\u8be2\u6b63\u5728\u4f7f\u7528\u56de\u6eda\u6bb5(UNDO)\u7684\u4f1a\u8bdd(\u5355\u5b9e\u4f8b)<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-34\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#5_%E6%95%B0%E6%8D%AE%E5%BA%93CPU%E4%B8%8E%E5%86%85%E5%AD%98\" >5. \u6570\u636e\u5e93CPU\u4e0e\u5185\u5b58<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-35\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#51_%E6%9F%A5%E7%9C%8B%E6%95%B0%E6%8D%AE%E5%BA%93%E5%86%85%E5%AD%98%E5%88%86%E9%85%8D%E6%A8%A1%E5%BC%8F\" >5.1. \u67e5\u770b\u6570\u636e\u5e93\u5185\u5b58\u5206\u914d\u6a21\u5f0f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-36\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#52_%E6%9F%A5%E7%9C%8B%E6%95%B0%E6%8D%AE%E5%BA%93%E5%86%85%E5%AD%98%E4%BD%BF%E7%94%A8%E7%8E%87\" >5.2. \u67e5\u770b\u6570\u636e\u5e93\u5185\u5b58\u4f7f\u7528\u7387<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-37\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#53_19c_%E6%95%B0%E6%8D%AE%E5%BA%93%E5%90%AF%E7%94%A8_IN-Memory%E7%89%B9%E6%80%A7\" >5.3. 19c \u6570\u636e\u5e93\u542f\u7528 IN-Memory\u7279\u6027<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-38\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#6_%E5%85%B6%E4%BB%96\" >6. \u5176\u4ed6<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-39\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#61_%E5%9C%A8RAC%E7%8E%AF%E5%A2%83%E4%B8%8B%E6%9F%A5%E7%9C%8BSCANIP\" >6.1. \u5728RAC\u73af\u5883\u4e0b\u67e5\u770bSCANIP<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-40\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#63_%E6%9F%A5%E8%AF%A2%E5%AE%B9%E5%99%A8%E6%95%B0%E6%8D%AE%E5%BA%93%E4%B8%AD%E6%89%80%E6%9C%89%E7%8A%B6%E6%80%81%E4%B8%BAOPEN%E7%9A%84%E7%94%A8%E6%88%B7\" >6.3. \u67e5\u8be2\u5bb9\u5668\u6570\u636e\u5e93\u4e2d\u6240\u6709\u72b6\u6001\u4e3aOPEN\u7684\u7528\u6237<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-41\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#7_RMAN%E5%A4%87%E4%BB%BD%E7%9B%B8%E5%85%B3\" >7. RMAN\u5907\u4efd\u76f8\u5173<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-42\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#71_%E6%9F%A5%E8%AF%A2RMAN%E5%A4%87%E4%BB%BD%E6%97%B6%E5%88%86%E9%85%8D%E4%BF%A1%E9%81%93%E5%AF%B9%E5%BA%94%E7%9A%84%E6%93%8D%E4%BD%9C%E7%B3%BB%E7%BB%9F%E8%BF%9B%E7%A8%8B%E5%8F%B7\" >7.1. \u67e5\u8be2RMAN\u5907\u4efd\u65f6\u5206\u914d\u4fe1\u9053\u5bf9\u5e94\u7684\u64cd\u4f5c\u7cfb\u7edf\u8fdb\u7a0b\u53f7<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-43\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#72_%E6%9F%A5%E8%AF%A2_RMAN_%E5%A4%87%E4%BB%BD%E8%BF%9B%E5%BA%A6\" >7.2. \u67e5\u8be2 RMAN \u5907\u4efd\u8fdb\u5ea6<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-44\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#73_%E6%9F%A5%E7%9C%8B%E6%AF%8F%E5%A4%A9RMAN%E5%A4%87%E4%BB%BD%E5%A4%A7%E5%B0%8F\" >7.3. \u67e5\u770b\u6bcf\u5929RMAN\u5907\u4efd\u5927\u5c0f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-45\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#74_%E6%9F%A5%E7%9C%8B%E6%95%B0%E6%8D%AE%E5%BA%93%E6%98%AF%E5%90%A6%E5%BC%80%E5%90%AF%E4%BA%86%E5%9D%97%E6%94%B9%E5%8F%98%E8%B7%9F%E8%B8%AA\" >7.4. \u67e5\u770b\u6570\u636e\u5e93\u662f\u5426\u5f00\u542f\u4e86\u5757\u6539\u53d8\u8ddf\u8e2a<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-46\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#8_%E5%85%83%E6%95%B0%E6%8D%AE%E7%9B%B8%E5%85%B3\" >8. \u5143\u6570\u636e\u76f8\u5173<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-47\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#81_%E6%9F%A5%E8%AF%A2%E6%9F%90%E4%B8%AA%E7%94%A8%E6%88%B7%E4%B8%8B%E8%A1%A8%E7%9A%84%E5%B1%9E%E6%80%A7\" >8.1. \u67e5\u8be2\u67d0\u4e2a\u7528\u6237\u4e0b\u8868\u7684\u5c5e\u6027<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-48\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#82_%E6%9F%A5%E8%AF%A2%E6%9F%90%E4%B8%AA%E7%94%A8%E6%88%B7%E4%B8%8B%E5%AD%97%E6%AE%B5%E7%9A%84%E5%B1%9E%E6%80%A7\" >8.2. \u67e5\u8be2\u67d0\u4e2a\u7528\u6237\u4e0b\u5b57\u6bb5\u7684\u5c5e\u6027<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-49\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#83_%E8%8E%B7%E5%8F%96%E6%9F%90%E4%B8%AA%E7%94%A8%E6%88%B7%E4%B8%8B%E4%B8%BB%E9%94%AE%E3%80%81%E5%94%AF%E4%B8%80%E6%80%A7%E7%BA%A6%E6%9D%9F%E5%92%8C%E6%A3%80%E6%9F%A5%E7%BA%A6%E6%9D%9F%E7%9A%84%E5%88%9B%E5%BB%BA%E8%AF%AD%E5%8F%A5\" >8.3. \u83b7\u53d6\u67d0\u4e2a\u7528\u6237\u4e0b\u4e3b\u952e\u3001\u552f\u4e00\u6027\u7ea6\u675f\u548c\u68c0\u67e5\u7ea6\u675f\u7684\u521b\u5efa\u8bed\u53e5<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-50\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#84_%E6%9F%A5%E7%9C%8B%E8%A1%A8%E4%B8%8E%E7%B4%A2%E5%BC%95%E7%9A%84%E5%88%9B%E5%BB%BA%E8%AF%AD%E5%8F%A5\" >8.4. \u67e5\u770b\u8868\u4e0e\u7d22\u5f15\u7684\u521b\u5efa\u8bed\u53e5<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-51\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#85_%E6%9F%A5%E7%9C%8B%E7%B4%A2%E5%BC%95%E5%8D%A0%E7%94%A8%E7%9A%84%E5%AD%98%E5%82%A8%E5%A4%A7%E5%B0%8F\" >8.5. \u67e5\u770b\u7d22\u5f15\u5360\u7528\u7684\u5b58\u50a8\u5927\u5c0f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-52\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#86_%E8%8E%B7%E5%8F%96%E6%9F%90%E4%B8%AA%E7%94%A8%E6%88%B7%E4%B8%8B%E5%A4%96%E9%94%AE%E7%BA%A6%E6%9D%9F%E7%9A%84%E5%88%9B%E5%BB%BA%E8%AF%AD%E5%8F%A5\" >8.6. \u83b7\u53d6\u67d0\u4e2a\u7528\u6237\u4e0b\u5916\u952e\u7ea6\u675f\u7684\u521b\u5efa\u8bed\u53e5<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-53\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#87_%E5%90%AF%E7%94%A8%E7%A6%81%E7%94%A8%E6%9F%90%E4%B8%AA%E7%94%A8%E6%88%B7%E4%B8%8B%E5%A4%96%E9%94%AE%E7%BA%A6%E6%9D%9F%E7%9A%84%E8%AF%AD%E5%8F%A5\" >8.7. \u542f\u7528\/\u7981\u7528\u67d0\u4e2a\u7528\u6237\u4e0b\u5916\u952e\u7ea6\u675f\u7684\u8bed\u53e5<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-54\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#88_%E9%80%9A%E8%BF%87%E9%93%BE%E6%8E%A5%E6%95%B0%E6%8D%AE%E5%BA%93%E8%8E%B7%E5%8F%96%E6%8F%92%E5%85%A5%E8%A1%A8%E7%9A%84SQL\" >8.8. \u901a\u8fc7\u94fe\u63a5\u6570\u636e\u5e93\u83b7\u53d6\u63d2\u5165\u8868\u7684SQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-55\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#023_%E6%9F%A5%E8%AF%A2%E6%95%B0%E6%8D%AE%E5%BA%93%E7%9A%84%E5%AF%86%E7%A0%81%E7%94%9F%E5%91%BD%E5%90%8C%E6%9C%9F\" >023. \u67e5\u8be2\u6570\u636e\u5e93\u7684\u5bc6\u7801\u751f\u547d\u540c\u671f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-56\" href=\"http:\/\/dba.qishuo.xin\/?p=932\/#025_%E6%9F%A5%E8%AF%A2%E8%A7%92%E8%89%B2%E5%8F%8A%E7%B3%BB%E7%BB%9F%E6%9D%83%E9%99%90\" >025. \u67e5\u8be2\u89d2\u8272\u53ca\u7cfb\u7edf\u6743\u9650<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<p>Oralce Database Reference\uff1a<a target=\"_blank\" href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/refrn\/index.html\" title=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/refrn\/index.html\">https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/refrn\/index.html<\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"1_%E6%95%B0%E6%8D%AE%E5%BA%93%E6%80%BB%E4%BD%93%E8%BF%90%E8%A1%8C%E6%83%85%E5%86%B5\"><\/span>1. \u6570\u636e\u5e93\u603b\u4f53\u8fd0\u884c\u60c5\u51b5<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"11_%E6%95%B0%E6%8D%AE%E5%BA%93%E8%BF%90%E8%A1%8C%E6%97%B6%E9%97%B4%E6%9F%A5%E8%AF%A2\"><\/span>1.1. \u6570\u636e\u5e93\u8fd0\u884c\u65f6\u95f4\u67e5\u8be2<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li>\u5355\u5b9e\u4f8b\u6570\u636e\u5e93<\/li>\n<\/ul>\n<pre><code class=\"language-sql\">COL host_name         FORMAT a10 HEADING &quot;Host&quot;                NEWLINE\nCOL instance_name     FORMAT a8  HEADING &quot;Instance&quot;            NEWLINE\nCOL stime             FORMAT a40 HEADING &quot;Database Started At&quot; NEWLINE\nCOL uptime            FORMAT a80 HEADING &quot;Uptime&quot;              NEWLINE\nSET HEADING OFF\n\nSELECT &#039;Hostname      : &#039; || host_name\n      ,&#039;Instance Name : &#039; || instance_name\n      ,&#039;Started At    : &#039; || to_char(startup_time,&#039;DD-MON-YYYY HH24:MI:SS&#039;) stime\n      ,&#039;Uptime        : &#039; || floor(sysdate - startup_time) || &#039; days(s) &#039; ||\n       trunc( 24*((sysdate-startup_time) -\n       trunc(sysdate-startup_time))) || &#039; hour(s) &#039; ||\n       mod(trunc(1440*((sysdate-startup_time) -\n       trunc(sysdate-startup_time))), 60) ||&#039; minute(s) &#039; ||\n       mod(trunc(86400*((sysdate-startup_time) -\n       trunc(sysdate-startup_time))), 60) ||&#039; seconds&#039; uptime\nFROM v$instance;<\/code><\/pre>\n<ul>\n<li>RAC\u6570\u636e\u5e93<\/li>\n<\/ul>\n<pre><code class=\"language-sql\">COL host_name         FORMAT a10 HEADING &quot;Host&quot;                NEWLINE\nCOL instance_name     FORMAT a8  HEADING &quot;Instance&quot;            NEWLINE\nCOL stime             FORMAT a40 HEADING &quot;Database Started At&quot; NEWLINE\nCOL uptime            FORMAT a80 HEADING &quot;Uptime&quot;              NEWLINE\nSET heading off\n\nSELECT &#039;Hostname      : &#039; || host_name\n      ,&#039;Instance Name : &#039; || instance_name\n      ,&#039;Started At    : &#039; || to_char(startup_time,&#039;DD-MON-YYYY HH24:MI:SS&#039;) stime\n      ,&#039;Uptime        : &#039; || floor(sysdate - startup_time) || &#039; days(s) &#039; ||\n       trunc( 24*((sysdate-startup_time) -\n       trunc(sysdate-startup_time))) || &#039; hour(s) &#039; ||\n       mod(trunc(1440*((sysdate-startup_time) -\n       trunc(sysdate-startup_time))), 60) ||&#039; minute(s) &#039; ||\n       mod(trunc(86400*((sysdate-startup_time) -\n       trunc(sysdate-startup_time))), 60) ||&#039; seconds&#039; uptime\nFROM gv$instance;<\/code><\/pre>\n<p><strong><span style='color:red'> \u6570\u636e\u5e93\u5982\u679c HANG \u4f4f\u4e86\uff0c\u6700\u4f18\u5148\u6392\u67e5\u7684\u5c31\u662f\u4f1a\u8bdd\u548c\u7b49\u5f85\u4e8b\u4ef6\uff01\uff01\uff01<\/span><\/strong><\/p>\n<h4><span class=\"ez-toc-section\" id=\"12_%E5%BD%93%E5%89%8D%E6%97%B6%E5%88%BB%E6%B4%BB%E5%8A%A8%E7%9A%84%E4%BC%9A%E8%AF%9D%E6%8C%89%E7%94%A8%E6%88%B7%E7%BB%9F%E8%AE%A1\"><\/span>1.2. \u5f53\u524d\u65f6\u523b\u6d3b\u52a8\u7684\u4f1a\u8bdd(\u6309\u7528\u6237\u7edf\u8ba1)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SET feed off\nSET lines 300 pages 999\ncolumn username format a20\ncolumn machine  format a40\n\nSELECT a.username,a.machine,count(*)\n  FROM gv$session a\n -- WHERE a.status = &#039;ACTIVE&#039;\n GROUP BY a.username,machine\n ORDER BY 3 desc;<\/code><\/pre>\n<ul>\n<li>\u6216\u67e5\u8be2\u8fdb\u7a0b<\/li>\n<\/ul>\n<pre><code class=\"language-sql\">SET feed off\nSET lines 300 pages 999\ncolumn username format a20\ncolumn machine  format a40\n\nSELECT b.username,b.machine,b.program, COUNT(*)\n  FROM v$process a\n  LEFT JOIN v$session b ON a.addr = b.paddr\n GROUP BY b.username,b.machine,b.program\n ORDER BY 4 DESC;<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"13_%E6%9F%A5%E8%AF%A2%E4%BC%9A%E8%AF%9D%E7%9A%84%E7%AD%89%E5%BE%85%E4%BA%8B%E4%BB%B6\"><\/span>1.3. \u67e5\u8be2\u4f1a\u8bdd\u7684\u7b49\u5f85\u4e8b\u4ef6<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SET LINES 300 PAGES 999\nCOLUMN inst_id   HEADING &quot;Inst_ID&quot; FORMAT 999999\nCOLUMN sid       HEADING &quot;Session_ID&quot; FORMAT 9999999999999\nCOLUMN serial#   HEADING &quot;Session_Serial#&quot; FORMAT 9999999999\nCOLUMN sql_id    HEADING &quot;Sql_ID&quot; FORMAT A16\nCOLUMN machine   HEADING &quot;machine&quot; FORMAT A16\nCOLUMN username  HEADING &quot;User_Name&quot; FORMAT A16\nCOLUMN event     HEADING &quot;event&quot; FORMAT A30\nCOLUMN blocking_session HEADING &quot;Blocking_Session&quot; FORMAT 9999999999999\n\nSELECT sid, serial#, inst_id, sql_id, event, p1,p2,p3, machine, username, blocking_session\n  FROM gv$session\n WHERE wait_class# &lt;&gt; 6;<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/03\/wp_editor_md_6b6365989b27c2b95360acfcbbc1ab64.jpg\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/03\/wp_editor_md_6b6365989b27c2b95360acfcbbc1ab64.jpg\" alt=\"\" \/><\/a><\/p>\n<h4><span class=\"ez-toc-section\" id=\"14_%E5%BD%93%E5%89%8D%E6%97%B6%E5%88%BB%E6%B4%BB%E5%8A%A8%E4%BC%9A%E8%AF%9D%E6%AD%A3%E5%9C%A8%E6%89%A7%E8%A1%8C%E7%9A%84SQL\"><\/span>1.4. \u5f53\u524d\u65f6\u523b\u6d3b\u52a8\u4f1a\u8bdd\u6b63\u5728\u6267\u884c\u7684SQL<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SET LINES 300 PAGES 999\nCOL username FOR A12\nCOLUMN inst_id   HEADING &quot;Inst_ID&quot; FORMAT 999999\nCOLUMN sid       HEADING &quot;Session_ID&quot; FORMAT 9999999999999\nCOLUMN serial#   HEADING &quot;Session_Serial#&quot; FORMAT 9999999999\nCOLUMN event     HEADING &quot;Event&quot; FORMAT A20\nCOLUMN wait_class HEADING &quot;wait_class&quot; FORMAT A12\nCOLUMN action HEADING &quot;action&quot; FORMAT A12\nCOL sql_text FOR A50\n\nSELECT s.username,\n       s.sid,\n       s.serial#,\n       s.inst_id,\n       s.event,\n       s.wait_class,\n       to_char(s.sql_exec_start,&#039;yyyy-MM-dd hh24:mi:ss&#039;) AS sql_exec_start,\n       s.seconds_in_wait,\n       s.action,\n       sq.sql_text\n  FROM gv$session s, gv$sqlarea sq\n WHERE s.status = &#039;ACTIVE&#039;\n   AND s.username IS NOT NULL\n   AND s.inst_id = sq.inst_id\n   AND s.sql_id = sq.sql_id\n   AND s.sid &lt;&gt; USERENV(&#039;SID&#039;);<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/03\/wp_editor_md_e3ec601827a0bc44907fd1b0e5b1dbec.jpg\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/03\/wp_editor_md_e3ec601827a0bc44907fd1b0e5b1dbec.jpg\" alt=\"\" \/><\/a><\/p>\n<p>\u6216 \u7ed3\u5408\u672a\u63d0\u4ea4\u7684\u4e8b\u52a1\u8fdb\u884c\u67e5\u8be2\uff1a<\/p>\n<pre><code class=\"language-sql\">WITH transaction_details AS\n (SELECT inst_id,\n         ses_addr,\n         SYSDATE - start_date AS diff\n    FROM gv$transaction)\n  SELECT s.username,\n         TO_CHAR(TRUNC(t.diff)) || &#039; days, &#039; ||\n         TO_CHAR(TRUNC(MOD(t.diff * 24,24))) || &#039; hours, &#039; ||\n         TO_CHAR(TRUNC(MOD(t.diff * 24 * 60,24))) || &#039; minutes, &#039; ||\n         TO_CHAR(TRUNC(MOD(t.diff * 24 * 60 * 60, 60))) || &#039; seconds&#039; AS TRANSACTION_DURATION,\n       s.program,\n       s.terminal,\n       s.status,\n       s.sid,\n       s.serial#\n  FROM gv$session s, transaction_details t\n WHERE s.inst_id = t.inst_id\n   AND s.saddr = t.ses_addr\n ORDER BY t.diff DESC<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"15_%E6%95%B0%E6%8D%AE%E5%BA%93%E9%95%BF%E6%97%B6%E9%97%B4%E6%89%A7%E8%A1%8C%E7%9A%84SQL\"><\/span>1.5. \u6570\u636e\u5e93\u957f\u65f6\u95f4\u6267\u884c\u7684SQL<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li>NON RAC<\/li>\n<\/ul>\n<pre><code class=\"language-sql\">SET LINES 300 PAGES 999\nCOL username FOR A12\nCOLUMN sid       HEADING &quot;Session_ID&quot; FORMAT 9999999999999\nCOLUMN serial#   HEADING &quot;Session_Serial#&quot; FORMAT 9999999999\nCOLUMN opname    HEADING &quot;op_name&quot; FORMAT A20\nCOLUMN progress  HEADING &quot;progress&quot; FORMAT A20\nCOLUMN sql_text HEADING &quot;sql_text&quot; FORMAT A120\n\nSELECT sl.username,\n       sl.sid,\n       sl.serial#,\n       sl.opname,\n       ROUND(sl.sofar * 100 \/ sl.totalwork, 0) || &#039;%&#039; AS progress,\n       sl.time_remaining,\n       sq.sql_text\n  FROM v$session_longops sl, v$sql sq\n WHERE sl.time_remaining &lt;&gt; 0\n   AND sl.sql_address = sq.address\n   AND sl.sql_hash_value = sq.hash_value;<\/code><\/pre>\n<ul>\n<li>RAC<\/li>\n<\/ul>\n<pre><code class=\"language-sql\">SET LINES 300 PAGES 999\nCOL username FOR A12\nCOLUMN inst_id   HEADING &quot;Inst_ID&quot; FORMAT 999999\nCOLUMN sid       HEADING &quot;Session_ID&quot; FORMAT 9999999999999\nCOLUMN serial#   HEADING &quot;Session_Serial#&quot; FORMAT 9999999999\nCOLUMN sql_text HEADING &quot;sql_text&quot; FORMAT A120\n\nSELECT a.inst_id, a.sid, a.serial#, a.username, a.sql_id, c.sql_text -- , c.sql_fulltext, b.*\n  FROM gv$session a, gv$session_longops b, gv$sql c\n WHERE a.sid = b.sid\n   AND a.serial# = b.serial#\n   AND a.inst_id = b.inst_id\n   AND a.inst_id = c.inst_id\n   AND a.sql_id = c.sql_id;<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/07\/image-1673110283302.png\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/07\/image-1673110283302.png\" alt=\"file\" \/><\/a><\/p>\n<p>\u52a8\u6001\u6027\u80fd\u89c6\u56fe <code>v$session_longops<\/code>\u3001<code>gv$session_longops<\/code><br \/>\n\u8be5\u89c6\u56fe\u8bb0\u5f55\u4e86\u6267\u884c\u65f6\u95f4\u957f\u4e8e6\u79d2\u7684\u67d0\u4e2a\u64cd\u4f5c(\u8fd9\u4e9b\u64cd\u4f5c\u53ef\u80fd\u662f\u5907\u4efd\uff0c\u6062\u590d\uff0c\u6536\u96c6\u7edf\u8ba1\u4fe1\u606f\uff0cHash Join,Sort ,Nested loop\uff0cTable Scan, Index Scan \u7b49\u7b49)\uff0c\u8fd9\u4e2a\u89c6\u56fe\u901a\u5e38\u7528\u6765\u5206\u6790SQL\u8fd0\u884c\u7f13\u6162\u7684\u539f\u56e0\uff0c\u914d\u5408 <code>V$SESSION<\/code> \u89c6\u56fe\u3002<br \/>\n1.\u5fc5\u987b\u5c06\u521d\u59cb\u5316\u53c2\u6570 timed_statistics\u8bbe\u7f6e\u4e3atrue\u6216\u8005\u5f00\u542fsql_trace<br \/>\n2.\u5fc5\u987b\u7528ANALYZE\u6216\u8005DBMS_STATS\u5bf9\u5bf9\u8c61\u6536\u96c6\u8fc7\u7edf\u8ba1\u4fe1\u606f<\/p>\n<table>\n<thead>\n<tr>\n<th style=\"text-align: left;\">\u5b57\u6bb5\u540d<\/th>\n<th style=\"text-align: left;\">\u542b\u4e49<\/th>\n<th style=\"text-align: left;\">\u5b57\u6bb5\u540d<\/th>\n<th style=\"text-align: left;\">\u542b\u4e49<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"text-align: left;\">SID<\/td>\n<td style=\"text-align: left;\">Session\u6807\u8bc6<\/td>\n<td style=\"text-align: left;\">TIMESTAMP<\/td>\n<td style=\"text-align: left;\">\u64cd\u4f5c\u7684\u65f6\u95f4\u6233<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">SERIAL#<\/td>\n<td style=\"text-align: left;\">Session\u4e32\u53f7<\/td>\n<td style=\"text-align: left;\">TIME_REMAINING<\/td>\n<td style=\"text-align: left;\">\u9884\u8ba1\u5b8c\u6210\u64cd\u4f5c\u7684\u5269\u4f59\u65f6\u95f4(\u79d2)<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">OPNAME<\/td>\n<td style=\"text-align: left;\">\u64cd\u4f5c\u7b80\u8981\u8bf4\u660e<\/td>\n<td style=\"text-align: left;\">ELAPSED_SECONDS<\/td>\n<td style=\"text-align: left;\">\u4ece\u64cd\u4f5c\u5f00\u59cb\u603b\u82b1\u8d39\u65f6\u95f4(\u79d2)<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">TARGET<\/td>\n<td style=\"text-align: left;\">\u64cd\u4f5c\u8fd0\u884c\u6240\u5728\u7684\u5bf9\u8c61<\/td>\n<td style=\"text-align: left;\">CONTEXT<\/td>\n<td style=\"text-align: left;\">\u524d\u540e\u5173\u7cfb<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">TARGET_DESC<\/td>\n<td style=\"text-align: left;\">\u76ee\u6807\u5bf9\u8c61\u8bf4\u660e<\/td>\n<td style=\"text-align: left;\">MESSAGE<\/td>\n<td style=\"text-align: left;\">\u7edf\u8ba1\u9879\u7684\u5b8c\u6574\u63cf\u8ff0<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">SOFAR<\/td>\n<td style=\"text-align: left;\">\u81f3\u4eca\u4e3a\u6b62\u5b8c\u6210\u7684\u5de5\u4f5c\u91cf<\/td>\n<td style=\"text-align: left;\">USERNAME<\/td>\n<td style=\"text-align: left;\">\u6267\u884c\u64cd\u4f5c\u7684\u7528\u6237ID<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">TOTALWORK<\/td>\n<td style=\"text-align: left;\">\u603b\u5de5\u4f5c\u91cf<\/td>\n<td style=\"text-align: left;\">SQL_ADDRESS<\/td>\n<td style=\"text-align: left;\">\u5173\u8054v$sql<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">UNITS<\/td>\n<td style=\"text-align: left;\">\u5de5\u4f5c\u91cf\u5355\u4f4d<\/td>\n<td style=\"text-align: left;\">SQL_HASH_VALUE<\/td>\n<td style=\"text-align: left;\">\u5173\u8054v$sql<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">START_TIME<\/td>\n<td style=\"text-align: left;\">\u64cd\u4f5c\u5f00\u59cb\u65f6\u95f4<\/td>\n<td style=\"text-align: left;\">SQL_ID<\/td>\n<td style=\"text-align: left;\">\u5173\u8054v$sql<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">LAST_UPDATE_TIME<\/td>\n<td style=\"text-align: left;\">\u7edf\u8ba1\u9879\u6700\u540e\u66f4\u65b0\u65f6\u95f4<\/td>\n<td style=\"text-align: left;\">QCSID<\/td>\n<td style=\"text-align: left;\">\u4e3b\u8981\u662f\u5e76\u884c\u67e5\u8be2\u4e00\u8d77\u4f7f\u7528<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<ul>\n<li>\u67e5\u770b\u6267\u884c\u7684\u8fdb\u5ea6<\/li>\n<\/ul>\n<pre><code class=\"language-sql\">SET LINE 300 PAGESIZE 9999\nCOL USERNAME FORMAT A10\nCOL SESSION_INFO FORMAT A30\nCOL TARGET FORMAT A20\nCOL OPNAME FORMAT A25\nCOL MESSAGE FORMAT A60\nCOL SOFAR_TOTALWORK FORMAT A20\nCOL PROGRESS FORMAT A8\n\nSELECT a.username,\n       (SELECT nb.sid || &#039;,&#039; || nb.serial# || &#039;,&#039; || pr.spid || &#039;,&#039; ||nb.osuser|| &#039;,&#039; ||nb.status|| &#039;,&#039; ||nb.event\n          FROM gv$process pr, gv$session nb\n         WHERE nb.paddr = pr.addr\n           AND nb.sid = a.sid\n           AND nb.serial# = a.serial#\n           AND pr.inst_id = nb.inst_id\n           AND a.inst_id = nb.inst_id) session_info,\n       a.target,\n       a.opname,\n       TO_CHAR(a.start_time, &#039;yyyy-MM-dd hh24:mi:ss&#039;) AS start_time,\n       ROUND(a.sofar * 100 \/ a.totalwork, 2) || &#039;%&#039;   AS progress,\n       (a.sofar || &#039;:&#039; || a.totalwork)                AS sofar_totalwork,\n       a.time_remaining                               AS time_remaining,\n       a.elapsed_seconds                              AS elapsed_seconds,\n       message                                        AS message\n  FROM gv$session_longops a\n WHERE a.time_remaining &lt;&gt; 0\n ORDER BY a.time_remaining desc, a.sql_id, a.sid;<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/07\/image-1673195612424.png\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/07\/image-1673195612424.png\" alt=\"file\" \/><\/a><\/p>\n<h4><span class=\"ez-toc-section\" id=\"16_%E6%9F%A5%E7%9C%8B%E6%95%B0%E6%8D%AE%E5%BA%93%E5%8E%86%E5%8F%B2%E7%9A%84%E8%B4%9F%E8%BD%BD\"><\/span>1.6. \u67e5\u770b\u6570\u636e\u5e93\u5386\u53f2\u7684\u8d1f\u8f7d<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SET LINES 300 PAGES 999\n\nSELECT *\n  FROM (SELECT a.instance_number,\n               a.snap_id,\n               b.begin_interval_time + 0 AS begin_time,\n               b.end_interval_time + 0   AS end_time,\n               ROUND(VALUE - LAG(VALUE, 1 , &#039;0&#039;) OVER(ORDER BY a.instance_number, a.snap_id)) AS &quot;DB TIME&quot;\n          FROM (SELECT b.snap_id,\n                       instance_number,\n                       SUM(VALUE) \/ 1000000 \/ 60  AS VALUE\n                  FROM dba_hist_sys_time_model b\n                 WHERE b.dbid = (SELECT dbid FROM v$database)\n                   AND UPPER(b.stat_name) IN UPPER(&#039;DB TIME&#039;)\n                 GROUP BY b.snap_id, instance_number) a, dba_hist_snapshot b\n         WHERE a.snap_id = b.snap_id\n           AND b.dbid = (SELECT dbid FROM v$database)\n           AND b.instance_number = a.instance_number)\n WHERE TO_CHAR(begin_time, &#039;yyyy-MM-dd&#039;) = TO_CHAR(SYSDATE , &#039;yyyy-MM-dd&#039;)\n ORDER BY begin_time;<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"17_%E6%9F%A5%E8%AF%A2%E6%89%A7%E8%A1%8C%E6%85%A2%E7%9A%84SQL\"><\/span>1.7. \u67e5\u8be2\u6267\u884c\u6162\u7684SQL<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">-- NON RAC\uff0c\u67e5\u8be2\u5b8c\u6574\u7684SQL\u53ef\u4ee5\u6839\u636esql_id\u67e5\u8be2\nSET LINES 300 PAGES 999\nCOL user_name FOR A12\nCOL sql_text FOR A100\n\nSELECT *\n  FROM (SELECT sa.sql_id                                           AS sql_id,\n               sa.executions                                       AS executions,\n               round(sa.elapsed_time \/ 1000000, 2)                 AS sum_elapsed_time,\n               round(sa.elapsed_time \/ 1000000 \/ sa.executions, 2) AS avg_execute_time,\n               sa.command_type                     AS command_type,\n               sa.parsing_user_id                  AS user_id,\n               u.username                          AS user_name,\n               sa.hash_value                       AS hash_value,\n               sa.sql_text                         AS sql_text\n               -- sql_fulltext\n          FROM v$sqlarea sa\n          LEFT JOIN all_users u ON sa.parsing_user_id = u.user_id\n         WHERE sa.executions &gt; 0\n        ORDER BY (sa.elapsed_time \/ sa.executions) desc)\n WHERE rownum &lt;= 50;<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"18_%E6%9F%A5%E8%AF%A2%E6%97%A5%E5%BF%97%E5%88%87%E6%8D%A2%E9%A2%91%E7%8E%87\"><\/span>1.8. \u67e5\u8be2\u65e5\u5fd7\u5207\u6362\u9891\u7387<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u5305\u542bRAC\u6240\u6709\u5b9e\u4f8b<\/p>\n<pre><code class=\"language-sql\">SET LINES 300 PAGES 999\nCOL H00 FOR 9999\nCOL H01 FOR 9999\nCOL H02 FOR 9999\nCOL H03 FOR 9999\nCOL H04 FOR 9999\nCOL H05 FOR 9999\nCOL H06 FOR 9999\nCOL H07 FOR 9999\nCOL H08 FOR 9999\nCOL H09 FOR 9999\nCOL H10 FOR 9999\nCOL H11 FOR 9999\nCOL H12 FOR 9999\nCOL H13 FOR 9999\nCOL H14 FOR 9999\nCOL H15 FOR 9999\nCOL H16 FOR 9999\nCOL H17 FOR 9999\nCOL H18 FOR 9999\nCOL H19 FOR 9999\nCOL H20 FOR 9999\nCOL H21 FOR 9999\nCOL H22 FOR 9999\nCOL H23 FOR 9999\n\nSELECT TO_CHAR(FIRST_TIME, &#039;MM\/DD&#039;) DAY,\n       SUM(DECODE(TO_CHAR(FIRST_TIME, &#039;HH24&#039;), &#039;00&#039;, 1, 0)) H00,\n       SUM(DECODE(TO_CHAR(FIRST_TIME, &#039;HH24&#039;), &#039;01&#039;, 1, 0)) H01,\n       SUM(DECODE(TO_CHAR(FIRST_TIME, &#039;HH24&#039;), &#039;02&#039;, 1, 0)) H02,\n       SUM(DECODE(TO_CHAR(FIRST_TIME, &#039;HH24&#039;), &#039;03&#039;, 1, 0)) H03,\n       SUM(DECODE(TO_CHAR(FIRST_TIME, &#039;HH24&#039;), &#039;04&#039;, 1, 0)) H04,\n       SUM(DECODE(TO_CHAR(FIRST_TIME, &#039;HH24&#039;), &#039;05&#039;, 1, 0)) H05,\n       SUM(DECODE(TO_CHAR(FIRST_TIME, &#039;HH24&#039;), &#039;06&#039;, 1, 0)) H06,\n       SUM(DECODE(TO_CHAR(FIRST_TIME, &#039;HH24&#039;), &#039;07&#039;, 1, 0)) H07,\n       SUM(DECODE(TO_CHAR(FIRST_TIME, &#039;HH24&#039;), &#039;08&#039;, 1, 0)) H08,\n       SUM(DECODE(TO_CHAR(FIRST_TIME, &#039;HH24&#039;), &#039;09&#039;, 1, 0)) H09,\n       SUM(DECODE(TO_CHAR(FIRST_TIME, &#039;HH24&#039;), &#039;10&#039;, 1, 0)) H10,\n       SUM(DECODE(TO_CHAR(FIRST_TIME, &#039;HH24&#039;), &#039;11&#039;, 1, 0)) H11,\n       SUM(DECODE(TO_CHAR(FIRST_TIME, &#039;HH24&#039;), &#039;12&#039;, 1, 0)) H12,\n       SUM(DECODE(TO_CHAR(FIRST_TIME, &#039;HH24&#039;), &#039;13&#039;, 1, 0)) H13,\n       SUM(DECODE(TO_CHAR(FIRST_TIME, &#039;HH24&#039;), &#039;14&#039;, 1, 0)) H14,\n       SUM(DECODE(TO_CHAR(FIRST_TIME, &#039;HH24&#039;), &#039;15&#039;, 1, 0)) H15,\n       SUM(DECODE(TO_CHAR(FIRST_TIME, &#039;HH24&#039;), &#039;16&#039;, 1, 0)) H16,\n       SUM(DECODE(TO_CHAR(FIRST_TIME, &#039;HH24&#039;), &#039;17&#039;, 1, 0)) H17,\n       SUM(DECODE(TO_CHAR(FIRST_TIME, &#039;HH24&#039;), &#039;18&#039;, 1, 0)) H18,\n       SUM(DECODE(TO_CHAR(FIRST_TIME, &#039;HH24&#039;), &#039;19&#039;, 1, 0)) H19,\n       SUM(DECODE(TO_CHAR(FIRST_TIME, &#039;HH24&#039;), &#039;20&#039;, 1, 0)) H20,\n       SUM(DECODE(TO_CHAR(FIRST_TIME, &#039;HH24&#039;), &#039;21&#039;, 1, 0)) H21,\n       SUM(DECODE(TO_CHAR(FIRST_TIME, &#039;HH24&#039;), &#039;22&#039;, 1, 0)) H22,\n       SUM(DECODE(TO_CHAR(FIRST_TIME, &#039;HH24&#039;), &#039;23&#039;, 1, 0)) H23,\n       COUNT(*) AS TOTAL\n  FROM (SELECT rownum rn, first_time\n          FROM gv$log_history\n         WHERE first_time &gt; SYSDATE - 18\n           AND first_time &gt; ADD_MONTHS(SYSDATE, -1)\n         ORDER BY first_time)\n GROUP BY TO_CHAR(first_time, &#039;MM\/DD&#039;)\n ORDER BY MIN(RN);<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"19_%E6%9F%A5%E7%9C%8B%E9%97%AA%E5%9B%9E%E5%8C%BA%E7%9A%84%E4%BD%BF%E7%94%A8%E7%8E%87\"><\/span>1.9. \u67e5\u770b\u95ea\u56de\u533a\u7684\u4f7f\u7528\u7387<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SET LINES 300 PAGES 999\nCOL name FOR A40\nCOL limit_gb FOR 99999999999999999\nCOL used_gb  FOR 99999999999999999\nCOL space_reclaimable FOR 99999999999999999\nSELECT name,\n       space_limit \/ 1024 \/ 1024 \/ 1024 AS limit_gb,\n       space_used \/ 1024 \/ 1024 \/ 1024  AS used_gb,\n       space_reclaimable \/ 1024 \/ 1024 \/ 1024 AS space_reclaimable,\n       number_of_files,\n       con_id\n  FROM v$recovery_file_dest;<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"110_%E5%AE%B9%E5%99%A8%E6%95%B0%E6%8D%AE%E5%BA%93%E5%AD%97%E7%AC%A6%E9%9B%86\"><\/span>1.10. \u5bb9\u5668\u6570\u636e\u5e93\u5b57\u7b26\u96c6<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SET LINES 300 PAGES 999 FEED OFF\nCOLUMN value HEADING &quot;Parameter|Value&quot;    FORMAT a30\n\nSELECT value\n  FROM nls_database_parameters\n WHERE parameter = &#039;NLS_CHARACTERSET&#039;;<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/09\/wp_editor_md_35a4fb644a535396828c5412cd1552bd.jpg\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/09\/wp_editor_md_35a4fb644a535396828c5412cd1552bd.jpg\" alt=\"\" \/><\/a><\/p>\n<h4><span class=\"ez-toc-section\" id=\"111_%E6%9F%A5%E7%9C%8B%E6%95%B0%E6%8D%AE%E5%BA%93%E5%AE%89%E8%A3%85%E7%9A%84%E7%BB%84%E4%BB%B6\"><\/span>1.11. \u67e5\u770b\u6570\u636e\u5e93\u5b89\u88c5\u7684\u7ec4\u4ef6<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SET LINES 300 PAGES 999 FEED OFF\nCOL COMP_ID FOR A10\nCOL COMP_NAME FOR A60\nCOL VERSION FOR A20\nCOL STATUS FOR A20\n\nSELECT comp_id, comp_name, version, status\n  FROM dba_registry\n ORDER BY 1;<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/09\/wp_editor_md_9abac99c0a726ab907997313ff965c81.jpg\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/09\/wp_editor_md_9abac99c0a726ab907997313ff965c81.jpg\" alt=\"\" \/><\/a><\/p>\n<h4><span class=\"ez-toc-section\" id=\"112_%E6%9F%A5%E7%9C%8B%E6%95%B0%E6%8D%AE%E5%BA%93%E7%89%88%E6%9C%AC%E5%8F%B7\"><\/span>1.12. \u67e5\u770b\u6570\u636e\u5e93\u7248\u672c\u53f7<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SET LINES 300 PAGES 999 FEED OFF\nCOL product FORMAT A42\nCOL version FORMAT A20\nCOL status  FORMAT A30\nSELECT product, version, status\n  FROM product_component_version;<\/code><\/pre>\n<p>\u6216\uff1a<\/p>\n<pre><code class=\"language-sql\">SET LINES 120 PAGES 999 HEADING OFF\nCOL con_id            FORMAT 999   HEADING &quot;ContainerID&quot;    NEWLINE\nCOL banner            FORMAT a120  HEADING &quot;Banner&quot;         NEWLINE\nCOL banner_full       FORMAT a120  HEADING &quot;Banner Full&quot;    NEWLINE\nCOL banner_legacy     FORMAT a20   HEADING &quot;Banner Legacy&quot;  NEWLINE\n\nSELECT &#039;ContainerID :  &#039;  || con_id,\n       &#039;Banner      :  &#039;  || banner,\n       &#039;Banner Full :  &#039;  || banner_full,\n       &#039;Banner Legacy: &#039;  || banner_legacy\n  FROM v$version;<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/04\/wp_editor_md_fb5c0d310464979c5e21682afcc01360.jpg\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/04\/wp_editor_md_fb5c0d310464979c5e21682afcc01360.jpg\" alt=\"\" \/><\/a><\/p>\n<p>\u5b57\u6bb5 <code>banner<\/code> \u7684\u542b\u4e49\uff1a\u7ec4\u4ef6\u540d\u79f0\u548c\u7248\u672c\u53f7<br \/>\n\u5b57\u6bb5 <code>banner_full<\/code> \u7684\u542b\u4e49\uff1a Oracle Database 18c \u4e2d\u5f15\u5165\u7684\u65b0\u7684 2 \u884c\u6a2a\u5e45\u683c\u5f0f\u3002 \u6a2a\u5e45\u663e\u793a\u6570\u636e\u5e93\u7248\u672c\u548c\u7248\u672c\u53f7\u3002<br \/>\n\u5b57\u6bb5 <code>banner_legacy<\/code> \u7684\u542b\u4e49\uff1a Oracle Database 18c \u4e4b\u524d\u4f7f\u7528\u7684\u65e7\u7248 1 \u884c\u6a2a\u5e45\u3002 \u6b64\u5217\u663e\u793a\u4e0e BANNER \u5217\u76f8\u540c\u7684\u503c\u3002<br \/>\n\u5b57\u6bb5 <code>con_id<\/code> \u7684\u542b\u4e49\uff1a \u6570\u636e\u6240\u5c5e\u5bb9\u5668\u7684 ID\u3002 \u53ef\u80fd\u7684\u503c\u5305\u62ec\uff1a0\uff1a\u6b64\u503c\u7528\u4e8e\u5305\u542b\u4e0e\u6574\u4e2a CDB \u76f8\u5173\u7684\u6570\u636e\u7684\u884c\u3002 \u6b64\u503c\u4e5f\u7528\u4e8e\u975e CDB \u4e2d\u7684\u884c\u30021\uff1a\u6b64\u503c\u7528\u4e8e\u5305\u542b\u4ec5\u4e0e\u6839\u76f8\u5173\u7684\u6570\u636e\u7684\u884c\uff0cn\uff1a\u5176\u4e2d n \u662f\u5305\u542b\u6570\u636e\u7684\u884c\u7684\u9002\u7528\u5bb9\u5668 ID\u3002<\/p>\n<p><strong>Oracle\u7248\u672c\u53f7\u542b\u4e49\u8bf4\u660e\uff1a<\/strong><\/p>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/04\/wp_editor_md_baef02bdc029a8723aafaf6b6aed05dd.jpg\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/04\/wp_editor_md_baef02bdc029a8723aafaf6b6aed05dd.jpg\" alt=\"\" \/><\/a><\/p>\n<ol>\n<li>\n<p>Major Database Release Number<br \/>\n\u7b2c\u4e00\u4e2a\u6570\u5b57\u4f4d\uff0c\u5b83\u4ee3\u8868\u7684\u662f\u4e00\u4e2a\u65b0\u7248\u672c\u8f6f\u4ef6\uff0c\u4e5f\u6807\u5fd7\u7740\u4e00\u4e9b\u65b0\u7684\u529f\u80fd\u3002\u598211g\uff0c10g\u3002<\/p>\n<\/li>\n<li>\n<p>Database Maintenance Release Number<br \/>\n\u7b2c\u4e8c\u4e2a\u6570\u5b57\u4f4d\uff0c\u4ee3\u8868\u4e00\u4e2amaintenance release \u7ea7\u522b\uff0c\u4e5f\u53ef\u80fd\u5305\u542b\u4e00\u4e9b\u65b0\u7684\u7279\u6027\u3002<\/p>\n<\/li>\n<li>\n<p>Fusion Middleware Release Number<br \/>\n\u7b2c\u4e09\u4e2a\u6570\u5b57\u4f4d\uff0c\u53cd\u5e94Oracle \u4e2d\u95f4\u4ef6\uff08Oracle Fusion Middleware\uff09\u7684\u7248\u672c\u53f7\u3002<\/p>\n<\/li>\n<li>\n<p>Component-Specific Release Number<br \/>\n\u7b2c\u56db\u4e2a\u6570\u5b57\u4f4d\uff0c\u4e3b\u8981\u662f\u9488\u5bf9\u7ec4\u4ef6\u7684\u53d1\u5e03\u7ea7\u522b\u3002\u4e0d\u540c\u7684\u7ec4\u4ef6\u5177\u6709\u4e0d\u540c\u7684\u53f7\u7801\u3002 \u6bd4\u5982Oracle \u7684patch\u5305\u3002<\/p>\n<\/li>\n<li>\n<p>Platform-Specific Release Number<br \/>\n\u7b2c\u4e94\u4e2a\u6570\u5b57\u4f4d\uff0c\u8fd9\u4e2a\u6570\u5b57\u4f4d\u6807\u8bc6\u4e00\u4e2a\u5e73\u53f0\u7684\u7248\u672c\u3002 \u901a\u5e38\u8868\u793apatch \u53f7\u3002<\/p>\n<\/li>\n<\/ol>\n<h4><span class=\"ez-toc-section\" id=\"113_%E6%9F%A5%E7%9C%8B%E6%95%B0%E6%8D%AE%E5%BA%93%E8%A1%A5%E4%B8%81\"><\/span>1.13. \u67e5\u770b\u6570\u636e\u5e93\u8865\u4e01<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<h3><span class=\"ez-toc-section\" id=\"2_%E5%BD%93%E5%89%8D%E4%BC%9A%E8%AF%9D\"><\/span>2. \u5f53\u524d\u4f1a\u8bdd<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"21_%E6%9F%A5%E7%9C%8B%E5%BD%93%E5%89%8D%E7%94%A8%E6%88%B7%E7%9A%84sid%E5%92%8Cserial\"><\/span>2.1. \u67e5\u770b\u5f53\u524d\u7528\u6237\u7684sid\u548cserial<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SET LINES 300 PAGES 999\nCOLUMN inst_id   HEADING &quot;Inst_ID&quot; FORMAT 999999\nCOLUMN sid       HEADING &quot;Session_ID&quot; FORMAT 9999999999999\nCOLUMN serial#   HEADING &quot;Session_Serial#&quot; FORMAT 9999999999\nCOLUMN status    HEADING &quot;Status&quot; FORMAT A20\n\nSELECT inst_id,\n       sid,\n       serial#,\n       status\n  FROM gv$session\n WHERE audsid = sys_context(&#039;USERENV&#039;, &#039;SESSIONID&#039;)\n   AND inst_id = sys_context(&#039;USERENV&#039;, &#039;INSTANCE&#039;);<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"22_%E6%9F%A5%E7%9C%8B%E5%BD%93%E5%89%8D%E4%BC%9A%E8%AF%9D%E7%9A%84spid_%E4%B8%8E_trace_file%E8%B7%AF%E5%BE%84\"><\/span>2.2. \u67e5\u770b\u5f53\u524d\u4f1a\u8bdd\u7684spid \u4e0e trace file\u8def\u5f84<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SET LINES 300 PAGES 999\nCOLUMN inst_id   HEADING &quot;Inst_ID&quot; FORMAT 999999\nCOLUMN sid       HEADING &quot;Session_ID&quot; FORMAT 9999999999999\nCOLUMN serial#   HEADING &quot;Session_Serial#&quot; FORMAT 9999999999\nCOLUMN spid      HEADING &quot;Process_ID&quot; FORMAT A10\nCOLUMN status    HEADING &quot;Status&quot; FORMAT A20\nCOLUMN tracefile HEADING &quot;Trace_Fie&quot; FORMAT A120\n\nSELECT p.inst_id,\n       s.sid,\n       s.serial#,\n       p.spid,\n       s.status,\n       p.tracefile\n  FROM gv$process p, gv$session s\n WHERE p.addr = s.paddr\n   AND s.audsid = userenv(&#039;sessionid&#039;)\n   AND s.inst_id = userenv(&#039;instance&#039;);<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"23_%E6%A0%B9%E6%8D%AEsession%E7%9B%B8%E5%85%B3%E4%BF%A1%E6%81%AF%E6%9F%A5%E8%AF%A2%E6%93%8D%E4%BD%9C%E7%B3%BB%E7%BB%9F%E8%BF%9B%E7%A8%8B%E5%8F%B7\"><\/span>2.3. \u6839\u636esession\u76f8\u5173\u4fe1\u606f\u67e5\u8be2\u64cd\u4f5c\u7cfb\u7edf\u8fdb\u7a0b\u53f7<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SET LINES 300 PAGES 999\nCOL username FORMAT A12\nCOL machine  FORMAT A30\nCOL program  FORMAT A30\nSELECT a.inst_id,\n       a.sid,\n       a.username,\n       a.status,\n       a.process,\n       a.machine,\n       a.program,\n       b.spid\n  FROM gv$session a, gv$process b\n WHERE a.inst_id = b.inst_id\n   AND a.paddr = b.addr\n   AND a.osuser = &#039;&amp;osuser&#039;;<\/code><\/pre>\n<p><strong><span style='color:red'>\u6839\u636e inst_id \u4e0e spid\uff0c\u5728\u64cd\u4f5c\u7cfb\u7edf\u5c42\u9762\u4f7f\u7528 netstat \u547d\u4ee4\u67e5\u8be2\u5230\u4e0e\u6570\u636e\u5e93\u8fde\u63a5\u7684\u5bf9\u7aefIP\u5730\u5740\uff01<\/span><\/strong><\/p>\n<h4><span class=\"ez-toc-section\" id=\"24_%E5%B7%B2%E7%9F%A5spid%EF%BC%8C%E6%9F%A5%E7%9C%8B%E5%BD%93%E5%89%8D%E6%AD%A3%E5%9C%A8%E6%89%A7%E8%A1%8C%E6%88%96%E6%9C%80%E8%BF%91%E4%B8%80%E6%AC%A1%E6%89%A7%E8%A1%8C%E7%9A%84%E8%AF%AD%E5%8F%A5\"><\/span>2.4. \u5df2\u77e5spid\uff0c\u67e5\u770b\u5f53\u524d\u6b63\u5728\u6267\u884c\u6216\u6700\u8fd1\u4e00\u6b21\u6267\u884c\u7684\u8bed\u53e5<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">-- NON RAC\nSET LINES 300 PAGES 999\nCOLUMN sql_id FORMAT A20\nCOLUMN sql_text FORMAT A120\n\nSELECT \/*+ ordered *\/ sql_text, sql_id\n  FROM v$sqltext sql\n WHERE (sql.hash_value, sql.address) IN (SELECT decode(sql_hash_value, 0, prev_hash_value, sql_hash_value),\n                                                decode(sql_hash_value, 0, prev_sql_addr, sql_address)\n                                           FROM v$session s\n                                          WHERE s.paddr = (SELECT addr\n                                                             FROM v$process p\n                                                            WHERE p.spid = to_number(&#039;&amp;spid&#039;)))\n ORDER BY piece ASC;<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"25_%E6%9F%A5%E8%AF%A2%E4%BC%9A%E8%AF%9D%E6%89%93%E5%BC%80%E7%9A%84%E6%B8%B8%E6%A0%87%E6%95%B0\"><\/span>2.5. \u67e5\u8be2\u4f1a\u8bdd\u6253\u5f00\u7684\u6e38\u6807\u6570<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SET LINES 300 PAGES 999\ncol MACHINE format a50\ncol OSUSER format a50\n\nSELECT s.username,\n       o.sid,\n       osuser,\n       machine,\n       count(*) AS num_curs\n  FROM v$open_cursor o, v$session s\n WHERE o.sid = s.sid\n   AND s.sid = &#039;&amp;sid&#039;\n   AND s.serial# = &#039;&amp;serial&#039;\n GROUP BY s.username, o.sid, osuser, machine\n ORDER BY num_curs desc;<\/code><\/pre>\n<h3><span class=\"ez-toc-section\" id=\"3_%E9%98%BB%E5%A1%9E%E4%B8%8E%E9%94%81\"><\/span>3. \u963b\u585e\u4e0e\u9501<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"31_%E6%9F%A5%E7%9C%8B%E5%BD%93%E5%89%8D%E9%98%BB%E5%A1%9E%E4%B8%8E%E8%A2%AB%E9%98%BB%E5%A1%9E%E7%9A%84%E4%BC%9A%E8%AF%9D\"><\/span>3.1. \u67e5\u770b\u5f53\u524d\u963b\u585e\u4e0e\u88ab\u963b\u585e\u7684\u4f1a\u8bdd<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SET LINES 300 PAGES 999\nCOLUMN blocking_session   HEADING &quot;Blocking_Session&quot; FORMAT A60\nCOLUMN blocked_session   HEADING &quot;Blocked_Session&quot; FORMAT A60\nCOLUMN script            HEADING &quot;Kill_Session_SQL&quot; FORMAT 40\nCOLUMN blocked_cnt       HEADING &#039;Blocked_cnt&#039; FORMAT 9999\n\nSELECT blocking_session,blocked_session,script,blocked_cnt\n  FROM (SELECT DISTINCT\n               s1.username || &#039;@&#039; || s1.machine || &#039; ( INST=&#039; || s1.inst_id || &#039; SID=&#039; || s1.sid || &#039; ET=&#039; || s1.last_call_et || &#039;sn. STATUS=&#039; || s1.status || &#039; EVENT=&#039; || s1.event || &#039; ACTION= &#039; || s1.action || &#039; PROGRAM=&#039; || s1.program || &#039; MODULE=&#039; || s1.module || &#039;)&#039; blocking_session,\n               s2.username || &#039;@&#039; || s2.machine || &#039; ( INST=&#039; || s2.inst_id || &#039; SID=&#039; || s2.sid || &#039; ET=&#039; || s2.last_call_et || &#039;sn. STATUS=&#039; || s2.status || &#039; EVENT=&#039; || s2.event || &#039; ACTION= &#039; || s2.action || &#039; PROGRAM=&#039; || s2.program || &#039; MODULE=&#039; || s2.module || &#039;)&#039; blocked_session,\n               decode(s1.type,&#039;USER&#039;,&#039;alter system kill session &#039;&#039;&#039; || s1.sid || &#039;,&#039; || s1.serial# || &#039;,@&#039; || s1.inst_id || &#039;&#039;&#039; immediate;&#039; ,null)\n               script ,\n               COUNT(*) OVER(PARTITION BY s1.inst_id,s1.sid) blocked_cnt\n          FROM gv$lock l1, gv$session s1, gv$lock l2, gv$session s2\n         WHERE s1.sid=l1.sid\n           AND s2.sid=l2.sid\n           AND s1.inst_id=l1.inst_id\n           AND s2.inst_id=l2.inst_id\n           AND l1.block &gt; 0\n           AND l2.request &gt; 0\n           AND l1.id1 = l2.id1 and l1.id2 = l2.id2)\n ORDER BY blocked_cnt DESC;<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"32_%E6%9F%A5%E8%AF%A2%E9%94%81%E7%9A%84%E6%BA%90%E5%A4%B4SID\"><\/span>3.2. \u67e5\u8be2\u9501\u7684\u6e90\u5934SID<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SELECT a.*,\n       row_number() over(partition by blocking_source order by &quot;LEVEL&quot; asc) as rn\n  FROM (SELECT *\n          FROM (SELECT inst_id,\n                       lpad(&#039; &#039;, (level - 1) * 2, &#039; &#039;) || sid AS sid,\n                       serial#,\n                       sql_id,\n                       paddr,\n                       username,\n                       event,\n                       machine,\n                       program,\n                      SUBSTR(numtodsinterval(seconds_in_wait, &#039;second&#039;),\n                              12,\n                              8) as wait_time,\n                       wait_class,\n                       state,\n                       level,\n                       blocking_session,\n                       (PRIOR sid) AS blocking_sid,\n                       (PRIOR serial#) AS blocking_serial#,\n                       (PRIOR sql_id) AS blocking_sql_id,\n                       sys_connect_by_path(sid, &#039;-&gt;&#039;) as blocking_path,\n                       connect_by_root(sid) AS blocking_source\n                  FROM gv$session\n                 start with blocking_session is NULL\n                connect by (prior sid) = blocking_session)\n         WHERE &quot;LEVEL&quot; &gt; 1\n         UNION\n        SELECT inst_id,\n               to_char(sid) as sid,\n               serial#,\n               sql_id,\n               paddr,\n               username,\n               event,\n               machine,\n               program,\n               SUBSTR(NUMTODSINTERVAL(seconds_in_wait, &#039;second&#039;), 12, 8) as wait_time,\n               wait_class,\n               state,\n               1,\n               null,\n               null,\n               null,\n               null,\n               null,\n               sid\n          FROM gv$session\n         WHERE sid IN (SELECT blocking_source\n                         FROM (SELECT wait_class#,\n                                      username,\n                                      level,\n                                      connect_by_root(sid) as blocking_source\n                                 FROM gv$session\n                                START WITH blocking_session IS NULL\n                               CONNECT BY (PRIOR sid) = blocking_session)\n                        WHERE &quot;LEVEL&quot; &gt; 1)) a;<\/code><\/pre>\n<p>\u6216<\/p>\n<pre><code class=\"language-sql\">--\u4f7f\u7528v$session\u6765\u67e5\u770bRAC\u6570\u636e\u5e93\u548c\u5355\u5b9e\u4f8b\u963b\u585esession\u4fe1\u606f\n\nSELECT\n         LPAD(&#039; &#039;,5*(LEVEL-1))||S.&quot;USERNAME&quot; ,\n         LPAD(&#039; &#039;,5*(LEVEL-1))||S.&quot;INST_ID&quot;||&#039;,&#039;||S.&quot;SID&quot; ,\n         S.&quot;SERIAL#&quot; ,\n         S.&quot;SQL_ID&quot;,\n         S.&quot;ROW_WAIT_OBJ#&quot;,\n         S.&quot;WAIT_CLASS&quot;,\n         S.&quot;EVENT&quot;,\n         S.&quot;P1&quot;,\n         S.&quot;P2&quot;,\n         S.&quot;P3&quot;,\n         S.&quot;SECONDS_IN_WAIT&quot;,\n         s.&quot;BLOCKING_INSTANCE&quot;||&#039;,&#039;||s.&quot;BLOCKING_SESSION&quot;\n  FROM   GV$SESSION S\n WHERE   S.&quot;BLOCKING_SESSION&quot; IS NOT NULL\n    OR  (S.&quot;INST_ID&quot;||&#039;,&#039;||S.&quot;SID&quot;) IN(SELECT DISTINCT BLOCKING_INSTANCE||&#039;,&#039;||BLOCKING_SESSION FROM GV$SESSION)\nSTART WITH  (s.&quot;BLOCKING_INSTANCE&quot;||&#039;,&#039;||s.&quot;BLOCKING_SESSION&quot;) = &#039;,&#039;\nCONNECT BY PRIOR (S.&quot;INST_ID&quot;||&#039;,&#039;||S.&quot;SID&quot;) = (s.&quot;BLOCKING_INSTANCE&quot;||&#039;,&#039;||s.&quot;BLOCKING_SESSION&quot;);<\/code><\/pre>\n<p>\u6216\uff1a<\/p>\n<pre><code class=\"language-sql\"> SELECT r.root_sid,\n        s.serial#,\n        r.blocked_num,\n        TRUNC( r.avg_wait_seconds) AS avg_wait_seconds,\n        s.username,s.status,\n        s.event,s.MACHINE,\n        s.PROGRAM,\n        s.sql_id,\n        s.prev_sql_id \n   FROM (SELECT root_sid, \n                AVG(seconds_in_wait) AS avg_wait_seconds,\n                COUNT(*) - 1 AS blocked_num\n          FROM (SELECT CONNECT_BY_ROOT sid AS root_sid,\n                       seconds_in_wait\n                  FROM v$session\n                 START WITH blocking_session IS NULL\n               CONNECT BY PRIOR SID = blocking_session)\n                 GROUP BY root_sid HAVING COUNT(*) &gt; 1\n         ) r, v$session s\n   WHERE r.root_sid = s.sid;<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"33_%E6%9F%A5%E8%AF%A2%E6%95%B0%E6%8D%AE%E5%BA%93%E4%B8%AD%E8%A2%AB%E9%94%81%E7%9A%84%E5%AF%B9%E8%B1%A1\"><\/span>3.3. \u67e5\u8be2\u6570\u636e\u5e93\u4e2d\u88ab\u9501\u7684\u5bf9\u8c61<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li>\u5bb9\u5668\u6570\u636e\u5e93<\/li>\n<\/ul>\n<pre><code class=\"language-sql\">SET LINES 300 PAGES 999\nCOL pdb_name FORMAT A20\nCOL oracle_username FORMAT A15\nCOL os_user_name FORMAT A20\nCOL object_name FORMAT A30\nCOL machine  FORMAT A20\nCOL terminal FORMAT A20\nCOL program FORMAT A15\nSELECT lo.inst_id,\n       cp.pdb_name,\n       s.sid,\n       s.serial#,\n       lo.oracle_username,\n       lo.os_user_name,\n       ao.object_name,\n       lo.locked_mode,\n       s.machine,\n       s.terminal,\n       s.program\n  FROM gv$locked_object lo, cdb_objects ao, gv$session s, cdb_pdbs cp\n WHERE ao.object_id = lo.object_id\n   AND lo.session_id = s.sid\n   AND lo.inst_id = s.inst_id\n   AND lo.con_id = cp.pdb_id;<\/code><\/pre>\n<ul>\n<li>\u975e\u5bb9\u5668\u6570\u636e\u5e93<\/li>\n<\/ul>\n<pre><code class=\"language-sql\">SET LINES 300 PAGES 999\nCOL oracle_username FORMAT A15\nCOL os_user_name FORMAT A20\nCOL object_name FORMAT A30\nCOL machine  FORMAT A20\nCOL terminal FORMAT A20\nCOL program FORMAT A15\nSELECT lo.inst_id,\n       s.sid,\n       s.serial#,\n       lo.oracle_username,\n       lo.os_user_name,\n       ao.object_name,\n       lo.locked_mode,\n       s.machine,\n       s.terminal,\n       s.program\n  FROM gv$locked_object lo, dba_objects ao, gv$session s\n WHERE ao.object_id = lo.object_id\n   AND lo.session_id = s.sid\n   AND lo.inst_id = s.inst_id;<\/code><\/pre>\n<h3><span class=\"ez-toc-section\" id=\"4_%E8%A1%A8%E7%A9%BA%E9%97%B4%E4%B8%8E%E6%95%B0%E6%8D%AE%E5%BA%93%E6%96%87%E4%BB%B6\"><\/span>4. \u8868\u7a7a\u95f4\u4e0e\u6570\u636e\u5e93\u6587\u4ef6<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"41_%E6%9F%A5%E7%9C%8B%E6%95%B0%E6%8D%AE%E5%BA%93%E8%A1%A8%E7%A9%BA%E9%97%B4\"><\/span>4.1. \u67e5\u770b\u6570\u636e\u5e93\u8868\u7a7a\u95f4<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li>\u5bb9\u5668\u6570\u636e\u5e93<\/li>\n<\/ul>\n<pre><code class=\"language-sql\">SET LINES 300 PAGES 999\nCOL pdb_name FORMAT A30\nCOL tablespace_name FORMAT A20\nSELECT b.con_id,\n       a.pdb_id,\n       a.pdb_name,\n       b.tablespace_name,\n       b.contents,\n       b.status,\n       b.bigfile\n  FROM dba_pdbs a\n  FULL OUTER JOIN cdb_tablespaces b ON a.pdb_id = b.con_id\n ORDER BY b.con_id, b.tablespace_name;<\/code><\/pre>\n<ul>\n<li>\u975e\u5bb9\u5668\u6570\u636e\u5e93<\/li>\n<\/ul>\n<pre><code class=\"language-sql\">SET LINES 300 PAGES 999\nCOL tablespace_name FORMAT A20\nSELECT b.tablespace_name,\n       b.contents,\n       b.status,\n       b.bigfile\n  FROM dba_tablespaces b\n ORDER BY b.tablespace_name;<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"42_%E6%9F%A5%E7%9C%8B%E6%95%B0%E6%8D%AE%E5%BA%93undo%E8%A1%A8%E7%A9%BA%E9%97%B4%E6%89%80%E5%AF%B9%E5%BA%94%E7%9A%84%E6%95%B0%E6%8D%AE%E6%96%87%E4%BB%B6\"><\/span>4.2. \u67e5\u770b\u6570\u636e\u5e93<code>undo\u8868\u7a7a\u95f4<\/code>\u6240\u5bf9\u5e94\u7684\u6570\u636e\u6587\u4ef6<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li>\u5bb9\u5668\u6570\u636e\u5e93<\/li>\n<\/ul>\n<pre><code class=\"language-sql\">SET LINES 300 PAGES 999\nCOL pdb_name FORMAT A20\nCOL file_name FORMAT A90\nCOL tablespace_name FORMAT A20\nSELECT a.con_id,\n       c.pdb_name,\n       b.tablespace_name,\n       a.retention,\n       b.file_id,\n       b.file_name,\n       b.autoextensible,\n       a.bigfile,\n       round(b.bytes \/ 1024 \/ 1024,2) AS undo_size_mb\n  FROM cdb_tablespaces a, cdb_data_files b, cdb_pdbs c\n WHERE a.con_id = b.con_id\n   AND a.con_id = c.pdb_id\n   AND a.tablespace_name = b.tablespace_name\n   AND a.contents = &#039;UNDO&#039;\n ORDER BY a.con_id, b.tablespace_name, b.file_id;<\/code><\/pre>\n<ul>\n<li>\u975e\u5bb9\u5668\u6570\u636e\u5e93<\/li>\n<\/ul>\n<pre><code class=\"language-sql\">SET LINES 300 PAGES 999\nCOL file_name FORMAT A90\nCOL tablespace_name FORMAT A20\nSELECT b.tablespace_name,\n       a.retention,\n       b.file_id,\n       b.file_name,\n       b.autoextensible,\n       a.bigfile,\n       round(b.bytes \/ 1024 \/ 1024,2) AS undo_size_mb\n  FROM dba_tablespaces a, dba_data_files b\n WHERE a.tablespace_name = b.tablespace_name\n   AND a.contents = &#039;UNDO&#039;\n ORDER BY b.tablespace_name, b.file_id;<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"43_%E6%9F%A5%E7%9C%8B%E6%95%B0%E6%8D%AE%E5%BA%93%E6%B0%B8%E4%B9%85%E8%A1%A8%E7%A9%BA%E9%97%B4%E6%89%80%E5%AF%B9%E5%BA%94%E7%9A%84%E6%95%B0%E6%8D%AE%E6%96%87%E4%BB%B6\"><\/span>4.3. \u67e5\u770b\u6570\u636e\u5e93<code>\u6c38\u4e45\u8868\u7a7a\u95f4<\/code>\u6240\u5bf9\u5e94\u7684\u6570\u636e\u6587\u4ef6<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li>\u5bb9\u5668\u6570\u636e\u5e93<br \/>\n<span style='color:red'>\u6ce8\u610f\uff1a\u5bb9\u5668\u6570\u636e\u5e93(\u5373PDB)\u5e94\u5904\u4e8e<code>READ WRITE<\/code>\u72b6\u6001\uff0c\u540c\u65f6\u67e5\u8be2\u7ed3\u679c\u5e76\u4e0d\u5305\u542b <code>PDB$SEED<\/code> \u4ee5\u53ca <code>cdb$root<\/code> \u6240\u521b\u5efa\u7684\u6570\u636e\u6587\u4ef6\u3002<\/span><\/li>\n<\/ul>\n<pre><code class=\"language-sql\">SET LINES 300 PAGES 999\nCOL pdb_name FORMAT A20\nCOL file_name FORMAT A90\nCOL tablespace_name FORMAT A20\nSELECT a.con_id,\n       c.pdb_name,\n       b.tablespace_name,\n       a.retention,\n       b.file_id,\n       b.file_name,\n       b.autoextensible,\n       a.bigfile,\n       round(b.bytes \/ 1024 \/ 1024,2) AS permanent_size_mb\n  FROM cdb_tablespaces a, cdb_data_files b, cdb_pdbs c\n WHERE a.con_id = b.con_id\n   AND a.con_id = c.pdb_id\n   AND a.tablespace_name = b.tablespace_name\n   AND a.contents = &#039;PERMANENT&#039;\n ORDER BY a.con_id, b.tablespace_name, b.file_id;<\/code><\/pre>\n<ul>\n<li>\u975e\u5bb9\u5668\u6570\u636e\u5e93<\/li>\n<\/ul>\n<pre><code class=\"language-sql\">SET LINES 300 PAGES 999\nCOL file_name FORMAT A90\nCOL tablespace_name FORMAT A20\nSELECT b.tablespace_name,\n       a.retention,\n       b.file_id,\n       b.file_name,\n       b.autoextensible,\n       a.bigfile,\n       round(b.bytes \/ 1024 \/ 1024,2) AS permanent_size_mb\n  FROM dba_tablespaces a, dba_data_files b\n WHERE a.tablespace_name = b.tablespace_name\n   AND a.contents = &#039;PERMANENT&#039;\n ORDER BY b.tablespace_name, b.file_id;<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"44_%E6%9F%A5%E7%9C%8B%E6%95%B0%E6%8D%AE%E5%BA%93%E4%B8%B4%E6%97%B6%E8%A1%A8%E7%A9%BA%E9%97%B4%E6%89%80%E5%AF%B9%E5%BA%94%E7%9A%84%E6%95%B0%E6%8D%AE%E6%96%87%E4%BB%B6\"><\/span>4.4. \u67e5\u770b\u6570\u636e\u5e93<code>\u4e34\u65f6\u8868\u7a7a\u95f4<\/code>\u6240\u5bf9\u5e94\u7684\u6570\u636e\u6587\u4ef6<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li>\u5bb9\u5668\u6570\u636e\u5e93<\/li>\n<\/ul>\n<pre><code class=\"language-sql\">SET LINES 300 PAGES 999\nCOL pdb_name FORMAT A20\nCOL file_name FORMAT A90\nCOL tablespace_name FORMAT A20\nSELECT a.con_id,\n       c.pdb_name,\n       b.tablespace_name,\n       a.retention,\n       b.file_id,\n       b.file_name,\n       b.autoextensible,\n       a.bigfile,\n       round(b.bytes \/ 1024 \/ 1024,2) AS temp_size_mb\n  FROM cdb_tablespaces a, cdb_temp_files b, cdb_pdbs c\n WHERE a.con_id = b.con_id\n   AND a.con_id = c.pdb_id\n   AND a.tablespace_name = b.tablespace_name\n   AND a.contents = &#039;TEMPORARY&#039;\n ORDER BY a.con_id, b.tablespace_name, b.file_id;<\/code><\/pre>\n<ul>\n<li>\u975e\u5bb9\u5668\u6570\u636e\u5e93<\/li>\n<\/ul>\n<pre><code class=\"language-sql\">SET LINES 300 PAGES 999\nCOL file_name FORMAT A90\nCOL tablespace_name FORMAT A20\nSELECT b.tablespace_name,\n       a.retention,\n       b.file_id,\n       b.file_name,\n       b.autoextensible,\n       a.bigfile,\n       round(b.bytes \/ 1024 \/ 1024,2) AS temp_size_mb\n  FROM dba_tablespaces a, dba_temp_files b\n WHERE a.tablespace_name = b.tablespace_name\n   AND a.contents = &#039;TEMPORARY&#039;\n ORDER BY b.tablespace_name, b.file_id;<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"45_%E6%9F%A5%E7%9C%8B%E6%95%B0%E6%8D%AE%E5%BA%93%E8%81%94%E6%9C%BA%E9%87%8D%E5%81%9A%E6%97%A5%E5%BF%97%E6%96%87%E4%BB%B6%E6%89%80%E5%AF%B9%E5%BA%94%E7%9A%84%E6%95%B0%E6%8D%AE%E6%96%87%E4%BB%B6\"><\/span>4.5. \u67e5\u770b\u6570\u636e\u5e93<code>\u8054\u673a\u91cd\u505a\u65e5\u5fd7\u6587\u4ef6<\/code>\u6240\u5bf9\u5e94\u7684\u6570\u636e\u6587\u4ef6<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SET LINES 300 PAGES 999\nCOLUMN member FORMAT A50\nCOLUMN first_change# FORMAT 99999999999999999999\nCOLUMN next_change# FORMAT 99999999999999999999\n\nSELECT l.thread#,\n       lf.group#,\n       lf.member,\n       TRUNC(l.bytes\/1024\/1024) AS size_mb,\n       l.status,\n       l.archived,\n       lf.type,\n       lf.is_recovery_dest_file AS rdf,\n       l.sequence#,\n       l.first_change#,\n       l.next_change#\nFROM   v$logfile lf\n       JOIN v$log l ON l.group# = lf.group#\nORDER BY l.thread#,lf.group#, lf.member;<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"46_%E6%9F%A5%E7%9C%8B%E6%95%B0%E6%8D%AE%E5%BA%93%E5%BD%92%E6%A1%A3%E6%97%A5%E5%BF%97%E6%96%87%E4%BB%B6%E6%89%80%E5%AF%B9%E5%BA%94%E7%9A%84%E6%95%B0%E6%8D%AE%E6%96%87%E4%BB%B6\"><\/span>4.6. \u67e5\u770b\u6570\u636e\u5e93<code>\u5f52\u6863\u65e5\u5fd7\u6587\u4ef6<\/code>\u6240\u5bf9\u5e94\u7684\u6570\u636e\u6587\u4ef6<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SET LINES 300 PAGES 999\nCOL NAME FORMAT A80\nSELECT con_id,\n       inst_id,\n       name,\n       dest_id,\n       thread#,\n       sequence#,\n       standby_dest,\n       applied,\n       deleted,\n       status,\n       registrar,\n       completion_time,\n       block_size\n  FROM gv$archived_log\n WHERE completion_time &gt;= SYSDATE - 7;<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"47_%E6%9F%A5%E8%AF%A2%E8%A1%A8%E7%A9%BA%E9%97%B4%E4%BD%BF%E7%94%A8%E5%A4%A7%E5%B0%8F%E4%B8%8E%E5%89%A9%E4%BD%99%E5%AE%B9%E9%87%8F\"><\/span>4.7. \u67e5\u8be2\u8868\u7a7a\u95f4\u4f7f\u7528\u5927\u5c0f\u4e0e\u5269\u4f59\u5bb9\u91cf<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li>\u5bb9\u5668\u6570\u636e\u5e93<\/li>\n<\/ul>\n<pre><code class=\"language-sql\">set feed off  lines 300 pages 999\ncolumn &quot;TablespaceName&quot; heading &quot;\u8868\u7a7a\u95f4\u540d\u79f0&quot; format a20\ncolumn &quot;FileCount&quot; heading &quot;\u6587\u4ef6\u4e2a\u6570&quot; format 999999\ncolumn &quot;UsedFileSize&quot; heading &quot;\u5df2\u4f7f\u7528\u7684|\u6587\u4ef6\u5927\u5c0f(MB)&quot; format 999,999,999.99\ncolumn &quot;MaxFileSize&quot;  heading &quot;\u6700\u5927|\u6587\u4ef6\u5927\u5c0f(MB)&quot; format 999,999,999\ncolumn &quot;UsedDiskSize&quot; heading &quot;\u5df2\u4f7f\u7528\u7684|\u78c1\u76d8\u7a7a\u95f4\u5927\u5c0f(MB)&quot; format 999,999,999.99\ncolumn &quot;UnusedDiskSize&quot; heading &quot;\u672a\u4f7f\u7528\u7684|\u78c1\u76d8\u7a7a\u95f4\u5927\u5c0f(MB)&quot; format 999,999,999.99\ncolumn &quot;TotalAvailableDiskSize&quot; heading &quot;\u53ef\u4f7f\u7528\u7684|\u5168\u90e8\u78c1\u76d8\u7a7a\u95f4\u5927\u5c0f(MB)&quot; format 999,999,999.99\n\nSELECT ts.tablespace_name AS TablespaceName,\n       df.FileCount AS FileCount,\n       TRUNC(df.UsedFileSize, 2)    AS UsedFileSize,\n       df.MaxFileSize               AS MaxFileSize,\n       TRUNC(df.UsedFileSize - fr.FreeDiskSize, 2)  AS UsedDiskSize,\n       TRUNC(fr.FreeDiskSize, 2)   AS UnusedDiskSize,\n       df.MaxFileSize - TRUNC(df.UsedFileSize - fr.FreeDiskSize, 2)  AS  TotalAvailableDiskSize\n  FROM (SELECT tablespace_name, SUM(bytes) \/ (1024 * 1024) AS FreeDiskSize\n          FROM cdb_free_space\n         GROUP BY tablespace_name) fr,\n       (SELECT tablespace_name,\n               TRUNC(SUM(bytes) \/ (1024 * 1024),2) AS UsedFileSize,\n               COUNT(*)  AS FileCount,\n               TRUNC(SUM(maxbytes) \/ (1024 * 1024),2) AS MaxFileSize\n          FROM cdb_data_files\n         GROUP BY tablespace_name) df,\n       (SELECT tablespace_name FROM cdb_tablespaces) ts\n WHERE fr.tablespace_name = df.tablespace_name(+)\n   AND fr.tablespace_name = ts.tablespace_name(+)\n ORDER BY 7;<\/code><\/pre>\n<ul>\n<li>\u975e\u5bb9\u5668\u6570\u636e\u5e93<\/li>\n<\/ul>\n<pre><code class=\"language-sql\">set feed off  lines 300 pages 999\ncolumn &quot;TablespaceName&quot; heading &quot;\u8868\u7a7a\u95f4\u540d\u79f0&quot; format a20\ncolumn &quot;FileCount&quot; heading &quot;\u6587\u4ef6\u4e2a\u6570&quot; format 999999\ncolumn &quot;UsedFileSize&quot; heading &quot;\u5df2\u4f7f\u7528\u7684|\u6587\u4ef6\u5927\u5c0f(MB)&quot; format 999,999,999.99\ncolumn &quot;MaxFileSize&quot;  heading &quot;\u6700\u5927|\u6587\u4ef6\u5927\u5c0f(MB)&quot; format 999,999,999\ncolumn &quot;UsedDiskSize&quot; heading &quot;\u5df2\u4f7f\u7528\u7684|\u78c1\u76d8\u7a7a\u95f4\u5927\u5c0f(MB)&quot; format 999,999,999.99\ncolumn &quot;UnusedDiskSize&quot; heading &quot;\u672a\u4f7f\u7528\u7684|\u78c1\u76d8\u7a7a\u95f4\u5927\u5c0f(MB)&quot; format 999,999,999.99\ncolumn &quot;TotalAvailableDiskSize&quot; heading &quot;\u53ef\u4f7f\u7528\u7684|\u5168\u90e8\u78c1\u76d8\u7a7a\u95f4\u5927\u5c0f(MB)&quot; format 999,999,999.99\n\nSELECT ts.tablespace_name AS TablespaceName,\n       df.FileCount AS FileCount,\n       TRUNC(df.UsedFileSize, 2)    AS UsedFileSize,\n       df.MaxFileSize               AS MaxFileSize,\n       TRUNC(df.UsedFileSize - fr.FreeDiskSize, 2)  AS UsedDiskSize,\n       TRUNC(fr.FreeDiskSize, 2)   AS UnusedDiskSize,\n       df.MaxFileSize - TRUNC(df.UsedFileSize - fr.FreeDiskSize, 2)  AS  TotalAvailableDiskSize\n  FROM (SELECT tablespace_name, SUM(bytes) \/ (1024 * 1024) AS FreeDiskSize\n          FROM dba_free_space\n         GROUP BY tablespace_name) fr,\n       (SELECT tablespace_name,\n               TRUNC(SUM(bytes) \/ (1024 * 1024),2) AS UsedFileSize,\n               COUNT(*)  AS FileCount,\n               TRUNC(SUM(maxbytes) \/ (1024 * 1024),2) AS MaxFileSize\n          FROM dba_data_files\n         GROUP BY tablespace_name) df,\n       (SELECT tablespace_name FROM dba_tablespaces) ts\n WHERE fr.tablespace_name = df.tablespace_name(+)\n   AND fr.tablespace_name = ts.tablespace_name(+)\n ORDER BY 7;<\/code><\/pre>\n<p>\u4ee5\u4e0b\u66f4\u51c6\u786e\uff1a<\/p>\n<pre><code class=\"language-sql\">SELECT d.tablespace_name AS TablespaceName,\n       a.FileCount AS FileCount,\n       d.status AS TablespaceStatus,\n       to_char(NVL(a.bytes \/ 1024 \/ 1024, 0),&#039;99G999G990D900&#039;) AS UsedFileSize,\n       to_char(NVL(a.max_bytes \/ 1024 \/ 1024, 0),&#039;99G999G990D900&#039;) AS MaxFileSize,\n       to_char(NVL(a.bytes - NVL(f.bytes,0), 0) \/ 1024 \/ 1024, &#039;99G999G990D900&#039;) AS UsedDiskSizeMb,\n       to_char(NVL(a.max_bytes - NVL(a.bytes - NVL(f.bytes,0), 0), 0) \/ 1024 \/ 1024, &#039;99G999G990D900&#039;) AS TotalAvailableDiskSizeMb,\n       to_char(NVL((a.bytes - NVL(f.bytes,0)) \/ a.max_bytes * 100, 0), &#039;990D00&#039;) AS UsedDiskPercent\n  FROM sys.dba_tablespaces d,\n       (SELECT tablespace_name,\n               COUNT(file_id) AS filecount,\n               SUM(bytes) bytes,\n               SUM(CASE WHEN autoextensible = &#039;NO&#039; THEN bytes \n                        WHEN autoextensible = &#039;YES&#039; THEN maxbytes END) AS max_bytes\n          FROM dba_data_files\n         GROUP BY tablespace_name\n         UNION ALL\n        SELECT tablespace_name,\n               COUNT(file_id) AS filecount,\n               SUM(bytes) bytes,\n               SUM(CASE WHEN autoextensible = &#039;NO&#039; THEN bytes\n                        WHEN autoextensible = &#039;YES&#039; THEN maxbytes END) AS max_bytes\n          FROM dba_temp_files\n         GROUP BY tablespace_name ) a,\n       (SELECT tablespace_name, SUM(bytes) bytes\n          FROM dba_free_space\n         GROUP BY tablespace_name) f\n WHERE d.tablespace_name = f.tablespace_name(+)\n   AND d.tablespace_name = a.tablespace_name(+)\n ORDER BY 7;<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"48_%E6%9F%A5%E8%AF%A2%E6%AD%A3%E5%9C%A8%E4%BD%BF%E7%94%A8%E5%9B%9E%E6%BB%9A%E6%AE%B5UNDO%E7%9A%84%E4%BC%9A%E8%AF%9D%E5%8D%95%E5%AE%9E%E4%BE%8B\"><\/span>4.8. \u67e5\u8be2\u6b63\u5728\u4f7f\u7528\u56de\u6eda\u6bb5(UNDO)\u7684\u4f1a\u8bdd(\u5355\u5b9e\u4f8b)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SELECT s.sid,\n       s.serial#,\n       s.sql_id,\n       v.usn,\n       r.segment_name,\n       r.status,\n       v.rssize\/1024\/1024 mb\n  FROM dba_rollback_segs r, v$rollstat v, v$transaction t, v$session s\n WHERE r.segment_id = v.usn\n   AND v.usn = t.xidusn\n   AND t.addr = s.taddr\n ORDER BY r.segment_name;<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/12\/wp_editor_md_5061566f4baa9db830b7b65ce17164d3.jpg\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/12\/wp_editor_md_5061566f4baa9db830b7b65ce17164d3.jpg\" alt=\"\" \/><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"5_%E6%95%B0%E6%8D%AE%E5%BA%93CPU%E4%B8%8E%E5%86%85%E5%AD%98\"><\/span>5. \u6570\u636e\u5e93CPU\u4e0e\u5185\u5b58<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"51_%E6%9F%A5%E7%9C%8B%E6%95%B0%E6%8D%AE%E5%BA%93%E5%86%85%E5%AD%98%E5%88%86%E9%85%8D%E6%A8%A1%E5%BC%8F\"><\/span>5.1. \u67e5\u770b\u6570\u636e\u5e93\u5185\u5b58\u5206\u914d\u6a21\u5f0f<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>ASMM\uff08Automatic Shared Memory Management\uff0c<strong><span style='color:red'>\u81ea\u52a8\u5171\u4eab\u5185\u5b58\u7ba1\u7406 <\/span><\/strong>\uff09\u662fOracle 10g\u5f15\u5165\u7684\u6982\u5ff5\u3002\u5373\u8ba9\u8bbe\u7f6e\u4e00\u4e2aSGA\u7684\u76ee\u6807\u503c\u4ee5\u53caSGA\u7684\u6700\u5927\u503c\uff0c\u6570\u636e\u5e93\u6765\u52a8\u6001\u8c03\u6574\u5176\u4e2d\u7684\u5404\u4e2a\u7ec4\u4ef6\uff0c\u5982Database buffer cache\u3001Shared pool\u7b49\u7b49\u3002<br \/>\nAMM\uff1aautomatic memory management  <strong><span style='color:red'>\u81ea\u52a8\u5185\u5b58\u7ba1\u7406 <\/span><\/strong>\uff0811.1\u624d\u6709\u7684\u7279\u6027\uff09 \u5373\u8ba9\u6570\u636e\u5e93\u5b8c\u5168\u7ba1\u7406SGA\u3001PGA\u7684\u5927\u5c0f\uff0c\u800c\u5bf9\u4e8e\u7ba1\u7406\u5458\u53ea\u9700\u8981\u8bbe\u7f6e\u4e00\u4e2a\u603b\u7684\u5927\u5c0f\uff08memory_target\uff09\uff0c\u6570\u636e\u5e93\u4f1a\u52a8\u6001\u7684\u8c03\u6574SGA\u3001PGA\u7684\u5927\u5c0f\u4ee5\u53ca\u5176\u4e2d\u5305\u542b\u7684\u5404\u4e2a\u7ec4\u4ef6\u5927\u5c0f\uff0c\u5982Database buffer cache\u3001Shared pool\u7b49\u7b49\u3002<br \/>\nORACLE 11g AMM \u7684\u5f15\u5165\uff0c\u7ec4\u5408\u51fa\u6765\u6709 5 \u79cd\u5185\u5b58\u7ba1\u7406\u5f62\u5f0f.<\/p>\n<table>\n<thead>\n<tr>\n<th style=\"text-align: left;\">\u5185\u5b58\u7ba1\u7406\u6a21\u5f0f<\/th>\n<th style=\"text-align: left;\">\u8bbe\u7f6e\u89c4\u5219<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"text-align: left;\">\u81ea\u52a8\u5185\u5b58\u7ba1\u7406\uff08AMM\uff09<\/td>\n<td style=\"text-align: left;\">memory_target = \u975e0\uff0c\u662f\u81ea\u52a8\u5185\u5b58\u7ba1\u7406\uff0c\u5982\u679c\u521d\u59cb\u5316\u53c2\u6570 LOCK_SGA=TRUE\uff0c\u5219 AMM \u662f\u4e0d\u53ef\u7528\u7684.<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">\u81ea\u52a8\u5171\u4eab\u5185\u5b58\u7ba1\u7406(ASMM)<\/td>\n<td style=\"text-align: left;\">memory_target = 0 and sga_target\u4e3a\u975e0\u7684\u60c5\u5f62\u4e0b\u662f\u81ea\u52a8\u5185\u5b58\u7ba1\u7406.<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">\u624b\u5de5\u5171\u4eab\u5185\u5b58\u7ba1\u7406<\/td>\n<td style=\"text-align: left;\">memory_target = 0 and sga_target = 0  \u6307\u5b9a share_pool_size \u3001db_cache_size \u7b49 sga \u53c2\u6570.<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">\u81ea\u52a8 PGA \u7ba1\u7406<\/td>\n<td style=\"text-align: left;\">memory_target = 0 and workarea_size_policy=auto and PGA_AGGREGATE_TARGET=\u503c.<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">\u624b\u52a8 PGA \u7ba1\u7406<\/td>\n<td style=\"text-align: left;\">memory_target = 0 and workarea_size_policy=manal  \u7136\u540e\u6307\u5b9a SORT_AREA_SIZE \u7b49 PGA \u53c2\u6570\uff0c\u4e00\u822c\u4e0d\u4f7f\u7528\u624b\u52a8\u7ba1\u7406PGA.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/12\/wp_editor_md_003aa238249b72783f5032430f3df046.jpg\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/12\/wp_editor_md_003aa238249b72783f5032430f3df046.jpg\" alt=\"\" \/><\/a><\/p>\n<pre><code class=\"language-sql\">show parameter target;\nshow parameter memory_target;\nshow parameter sga_target;\nshow parameter pga_aggregate_target;<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/12\/wp_editor_md_cf7ad65efc41a2debb9035627fe8cbe9.jpg\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/12\/wp_editor_md_cf7ad65efc41a2debb9035627fe8cbe9.jpg\" alt=\"\" \/><\/a><\/p>\n<ul>\n<li>\u5982\u679cMemory_target \u8bbe\u7f6e\u4e3a\u975e0 \u503c<\/li>\n<\/ul>\n<pre><code>1\u3001sga_target \u548c pga_aggregate_target \u5df2\u7ecf\u8bbe\u7f6e\u5927\u5c0f\nMemory_Target = SGA_TARGET + PGA_AGGREGATE_TARGET\uff0c\u5176\u5927\u5c0f\u4e0d\u80fd\u8d85\u8fc7memory_max_size\u3002\n\n2\u3001sga_target \u8bbe\u7f6e\u5927\u5c0f\uff0c pga_aggregate_target \u6ca1\u6709\u8bbe\u7f6e\u5927\u5c0f\npga_aggregate_target\u7684\u521d\u59cb\u5316\u503c = memory_target - sga_target\n\n3\u3001sga_target \u6ca1\u6709\u8bbe\u7f6e\u5927\u5c0f\uff0c pga_aggregate_target \u8bbe\u7f6e\u5927\u5c0f\nsga_target\u7684\u521d\u59cb\u5316\u503c = memory_target - pga_aggregate_target\n\n4\u3001sga_target \u548c pga_aggregate_target \u90fd\u6ca1\u6709\u8bbe\u7f6e\u5927\u5c0f\n\u4e24\u4e2a\u503c\u6ca1\u6709\u6700\u5c0f\u503c\u548c\u9ed8\u8ba4\u503c\uff0cOracle \u5c06\u6839\u636e\u6570\u636e\u5e93\u8fd0\u884c\u72b6\u51b5\u8fdb\u884c\u5206\u914d\u5927\u5c0f\uff0c\u4f46\u5728\u6570\u636e\u5e93\u542f\u52a8\u662f\u4f1a\u6709\u4e00\u4e2a\u56fa\u5b9a\u6bd4\u4f8b\u6765\u5206\u914d\uff1a\nsga_target = memory_target * 60%\npga_aggregate_target = memory_target * 40%<\/code><\/pre>\n<ul>\n<li>\u5982\u679cMemory_target \u8bbe\u7f6e\u4e3a0<br \/>\n11g \u4e2d\u9ed8\u8ba4\u4e3a0 \u5219\u521d\u59cb\u72b6\u6001\u4e0b\u53d6\u6d88\u4e86 Memory_target \u7684\u4f5c\u7528\uff0c\u5b8c\u5168\u548c10g \u5728\u5185\u5b58\u7ba1\u7406\u4e0a\u4e00\u81f4\uff0c\u5b8c\u5168\u5411\u4e0b\u517c\u5bb9\u3002<\/li>\n<\/ul>\n<pre><code>1\u3001SGA_TARGET\u8bbe\u7f6e\u503c\n\u81ea\u52a8\u8c03\u8282SGA \u4e2d\u7684shared pool,buffer cache,redo log buffer,java pool,larger pool\u7b49\u5185\u5b58\u7a7a\u95f4\u7684\u5927\u5c0f\u3002PGA \u5219\u4f9d\u8d56pga_aggregate_target \u7684\u5927\u5c0f\u3002\n\n2\u3001SGA_target \u548cPGA_AGGREGATE_TARGET \u90fd\u6ca1\u6709\u8bbe\u7f6e\nSGA \u4e2d\u7684\u5404\u7ec4\u4ef6\u5927\u5c0f\u90fd\u8981\u660e\u786e\u8bbe\u5b9a\uff0c\u4e0d\u80fd\u81ea\u52a8\u8c03\u6574\u5404\u7ec4\u4ef6\u5927\u5c0f\u3002PGA\u4e0d\u80fd\u81ea\u52a8\u589e\u957f\u548c\u6536\u7f29\n\n3\u3001MEMORY_MAX_TARGET \u8bbe\u7f6e\u800c MEMORY_TARGET = 0  \u8fd9\u79cd\u60c5\u51b5\u5148\u548c10g \u4e00\u6837\u3002<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"52_%E6%9F%A5%E7%9C%8B%E6%95%B0%E6%8D%AE%E5%BA%93%E5%86%85%E5%AD%98%E4%BD%BF%E7%94%A8%E7%8E%87\"><\/span>5.2. \u67e5\u770b\u6570\u636e\u5e93\u5185\u5b58\u4f7f\u7528\u7387<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SET LINES 300 PAGES 999\nCOL NAME FORMAT A10\nSELECT name,\n       ROUND(total,2)                  AS total_size_mb,\n       ROUND(total-free,2)             AS used_size_mb,\n       ROUND(free,2)                   AS free_size_mb,\n       ROUND((total-free)\/total*100,2) AS pctused\n  FROM (SELECT &#039;SGA&#039; AS name,\n               (SELECT sum(value\/1024\/1024) FROM v$sga)  AS total,\n               (SELECT sum(bytes\/1024\/1024) FROM v$sgastat WHERE name = &#039;free memory&#039;) AS free\n          FROM dual)\n UNION\nSELECT name,\n       ROUND(total,2)          AS total_size_mb,\n       ROUND(used,2)           AS used_size_mb,\n       ROUND(total-used,2)     AS free_size_mb,\n       ROUND(used\/total*100,2) AS pctused\n FROM (SELECT &#039;PGA&#039; name,\n              (SELECT value\/1024\/1024 total FROM v$pgastat WHERE name = &#039;aggregate PGA target parameter&#039;) AS total,\n              (SELECT value\/1024\/1024 used FROM v$pgastat WHERE name = &#039;total PGA allocated&#039;) AS used\n        FROM dual);<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/12\/wp_editor_md_99a0b0305a750d0e769d29dd9338c3b5.jpg\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/12\/wp_editor_md_99a0b0305a750d0e769d29dd9338c3b5.jpg\" alt=\"\" \/><\/a><\/p>\n<h4><span class=\"ez-toc-section\" id=\"53_19c_%E6%95%B0%E6%8D%AE%E5%BA%93%E5%90%AF%E7%94%A8_IN-Memory%E7%89%B9%E6%80%A7\"><\/span>5.3. 19c \u6570\u636e\u5e93\u542f\u7528 IN-Memory\u7279\u6027<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u542f\u7528IMO\u975e\u5e38\u7b80\u5355,12.1.0.2\u53ca\u4e4b\u540e\u7248\u672c\u4e0b\uff0c\u8bbe\u7f6eINMEMORY_SIZE \u4e3a\u975e0\u503c\u4fbf\u53ef\u542f\u7528IM column store\u7279\u6027\u3002<br \/>\n<strong>INMEMORY_SIZE \u662f\u4e2a\u5b9e\u4f8b\u7ea7\u53c2\u6570\uff0c\u9ed8\u8ba4\u4e3a0\uff0c\u8bbe\u7f6e\u4e00\u4e2a\u975e0\u503c\u65f6\uff0c\u6700\u5c0f\u503c\u4e3a100M\u3002\u4ece 12.2 \u5f00\u59cb\uff0c\u53ef\u4ee5\u52a8\u6001\u589e\u52a0 In-Memory \u533a\u57df\u7684\u5927\u5c0f\uff0c\u4e3a\u6b64\uff0c\u53ea\u9700 \u901a\u8fc7 ALTER SYSTEM \u547d\u4ee4\u589e\u52a0 INMEMORY_SIZE \u53c2\u6570\u503c\u5373\u53ef\u3002\u5b83\u4e5f\u4e0d\u4f1a\u53d7\u5230\u81ea\u52a8\u5185\u5b58\u7ba1\u7406 (AMM) \u7684\u5f71\u54cd\u6216\u63a7\u5236\u3002<\/strong><\/p>\n<p><strong><span style='color:red'> \u6211\u4eec\u8fd8\u53ef\u4ee5\u5728 CDB \u548c PDB \u7ea7\u522b\u8bbe\u7f6e inmemory_size \u53c2\u6570\u3002\u5982\u679c\u60a8\u5728 PDB \u7ea7\u522b\u8bbe\u7f6e\u6b64\u53c2\u6570\uff0c\u5219\u65e0\u9700\u91cd\u65b0\u542f\u52a8\u5b9e\u4f8b\u6216 PDB\u3002\u6240\u6709 PDB \u503c\u7684\u603b\u548c\u5c0f\u4e8e\u6216\u7b49\u4e8e CDB \u503c\u3002<\/span><\/strong><\/p>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/12\/wp_editor_md_c22cdf2f89cf8e8e8ff26aef51d76c22.jpg\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/12\/wp_editor_md_c22cdf2f89cf8e8e8ff26aef51d76c22.jpg\" alt=\"\" \/><\/a><\/p>\n<ul>\n<li>\u67e5\u8be2\u662f\u5426\u5f00\u542f\u4e86inmemory<\/li>\n<\/ul>\n<pre><code class=\"language-sql\">show parameter inmemory;\nalter system set inmemory_size=10g scope=spfile sid=&#039;*&#039;;<\/code><\/pre>\n<ul>\n<li>\u5728grid\u7528\u6237\u4e0b\u91cd\u542f\u6240\u6709\u6570\u636e\u5e93\u5b9e\u4f8b<\/li>\n<\/ul>\n<pre><code class=\"language-shell\">su - grid\nsrvctl status database -d racdb\nsrvctl stop   database -d racdb\nsrvctl start  database -d racdb<\/code><\/pre>\n<ul>\n<li>\n<p>\u8868\u7a7a\u95f4\u3001\u8868\u3001\uff08\u5b50\uff09\u5206\u533a\u548c\u5b9e\u4f8b\u5316\u89c6\u56fe\u4e2d\u542f\u7528 INMEMORY \u5c5e\u6027\u3002<br \/>\n\u5982\u679c\u5728\u8868\u7a7a\u95f4\u7ea7\u522b\u542f\u7528\u6b64\u5c5e\u6027\uff0c\u5219\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5c06\u4e3a IMCOLUMN \u5b58\u50a8\u542f\u7528\u8868\u7a7a\u95f4\u4e2d\u7684\u6240\u6709\u8868\u548c\u5b9e\u4f8b\u5316\u89c6\u56fe\u3002<\/p>\n<pre><code class=\"language-sql\">alter table test inmemory;<\/code><\/pre>\n<\/li>\n<li>\n<p>\u76d1\u63a7 inmemory \u4e2d\u7684\u5bf9\u8c61<\/p>\n<\/li>\n<\/ul>\n<pre><code class=\"language-sql\">SET LINES 300 PAGES 999\nCOL pdb_name     FORMAT A10\nCOL owner        FORMAT A12\nCOL segment_name FORMAT A60\nSELECT a.con_id,\n       b.pdb_name,\n       a.owner,\n       a.segment_name,\n       ROUND(SUM(a.bytes)\/1024\/1024,2) &quot;DATA MB&quot;,\n       ROUND(SUM(a.inmemory_size)\/1024\/1024,2) &quot;IN-MEM MB&quot;,\n       ROUND(SUM(a.bytes - a.bytes_not_populated) * 100 \/ SUM(a.bytes),2) &quot;% IN_MEM&quot;,\n       ROUND(SUM(a.bytes - a.bytes_not_populated) \/ SUM(a.inmemory_size),2) &quot;COMP RATIO&quot;\n  FROM v$im_segments a, cdb_pdbs b\n WHERE a.con_id = b.pdb_id\nGROUP BY a.con_id, b.pdb_name, a.owner, a.segment_name\nORDER BY a.con_id, SUM(a.bytes) desc;<\/code><\/pre>\n<h3><span class=\"ez-toc-section\" id=\"6_%E5%85%B6%E4%BB%96\"><\/span>6. \u5176\u4ed6<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"61_%E5%9C%A8RAC%E7%8E%AF%E5%A2%83%E4%B8%8B%E6%9F%A5%E7%9C%8BSCANIP\"><\/span>6.1. \u5728RAC\u73af\u5883\u4e0b\u67e5\u770bSCANIP<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>oracle11gR2 RAC\u5f00\u59cb\u5f15\u5165scan\u6982\u5ff5\uff0cSCAN\u76d1\u542c\u5668\u53ef\u4ee5\u76d1\u542c\u5230\u96c6\u7fa4\u4e2d\u8fd0\u884c\u7684\u6240\u6709\u6570\u636e\u5e93\uff0c\u5b83\u662f\u5b9e\u73b0SCAN\u8d1f\u8f7d\u5747\u8861\u7684\u539f\u7406\u6240\u5728\u3002 \u4e00\u4e2aRAC \u652f\u63011~3\u4e2aSCAN \u914d\u7f6e\uff0c\u53ef\u4ee5\u914d\u7f6e\u57df\u540d\u4e5f\u53ef\u4ee5\u914d\u7f6eIP\u5730\u5740\uff0c\u5982\u679c\u4f7f\u7528IP\u5730\u5740\uff0c\u6709\u51e0\u4e2aIP \u914d\u7f6e\u5c31\u96c6\u7fa4\u5c31\u4f1a\u542f\u52a8\u51e0\u4e2aSCAN listener\u3002 \u4e00\u822c\u901a\u8fc7dns\u670d\u52a1\u5668\u6216gns\u670d\u52a1\u5668\u89e3\u6790scan\uff0c\u4e5f\u53ef\u4ee5\u4f7f\u7528\/etc\/hosts\u6587\u4ef6\u89e3\u6790scan\uff0c\u53ea\u4e0d\u8fc7oracle\u5b98\u65b9\u4e0d\u5efa\u8bae\u8fd9\u6837\u505a\u3002<\/p>\n<p>\u56e0\u4e3a\u57df\u540d\u53ef\u914d\u7f6e\u4e3a\u8f6e\u8be2\u8bbf\u95eeIP\uff0c\u4e09\u4e2aIP\u8f6e\u6d41\u4f7f\u7528\u3002\u5047\u5982\u6211\u4eec\u914d\u7f6e\u4e863\u4e2aip\u4f9bSCAN \u4f7f\u7528\uff0c\u540c\u65f6\u914d\u7f6e\u4e86DNS \u89e3\u6790\uff0c\u76d1\u542c\u914d\u7f6e\u4e2dHOST\u7684\u503c\u662f\u57df\u540d\u3002 \u5f53\u5176\u4e2d\u4e00\u4e2aIP\u6545\u969c\u4e0d\u80fd\u4f7f\u7528\u65f6\uff0cdns \u4f1a\u81ea\u52a8\u89e3\u6790\u4e0b\u4e00\u4e2aIP \u5730\u5740\u3002\u800c\u4e14\u53ea\u6709\u4e00\u4e2ascan listener.<\/p>\n<p>\u5982\u679c\u6211\u4eec\u901a\u8fc7 \/etc\/hosts \uff0c\u914d\u7f6e3\u4e2aIP\u5730\u5740,\u5e76\u4e3a\u6bcf\u4e2aIP\u914d\u7f6e\u4e00\u4e2a\u522b\u540d,\u96c6\u7fa4\u542f\u52a8\u540e\u5c31\u4f1a\u6709\u4e09\u4e2a scan \u76d1\u542c\uff0c\u5f53\u5176\u5b9e\u4e00\u4e2aIP\u51fa\u73b0\u95ee\u9898\uff0c\u65e0\u6cd5\u4f7f\u7528\u65f6\uff0c\u5bf9\u5e94\u7684\u76d1\u542c\u5c06\u5931\u53bb\u5b58\u5728\u7684\u610f\u4e49 \u3002\u90a3\u4e48\u600e\u4e48\u89e3\u51b3\u8fd9\u4e2a\u95ee\u9898\u5462: \u4f7f\u7528\u5ba2\u6237\u7aefTAF\u914d\u7f6e\uff0c\u6765\u5b9e\u73b0\u7c7b\u4f3c\u4e8eDNS\u8f6e\u8be2\u529f\u80fd\u3002<\/p>\n<p>\u5207\u6362\u5230 <code>grid<\/code> \u7528\u6237\u4e0b\uff0c\u5728SHEll\u547d\u4ee4\u4e2d\u6267\u884c\u3002<\/p>\n<ul>\n<li>1\u4e2ascanip\u60c5\u5f62<\/li>\n<\/ul>\n<pre><code class=\"language-shell\"># \u67e5\u770bscan\u7684\u914d\u7f6e\u4fe1\u606f\n~] srvctl config scan\n\nSCAN name: rac-scan1, Network: 1\nSubnet IPv4: 192.168.37.0\/255.255.255.0\/bondeth0, static\nSubnet IPv6:\nSCAN 1 IPv4 VIP: 192.168.37.7\nSCAN VIP is enabled.\n\n# \u67e5\u770bscan\u7684\u72b6\u6001\u4ee5\u53cascan ip\u6240\u5904\u8282\u70b9\n~] srvctl status scan\n\nSCAN VIP scan1 is enabled\nSCAN VIP scan1 is running on node racdb01   &lt;-- \u8bf4\u660escan\u5728\u8282\u70b91\u4e0a\n\n# \u67e5\u770bscan listener\n~] srvctl config scan_listener\n\nSCAN Listeners for network 1:\nRegistration invited nodes:\nRegistration invited subnets:\nEndpoints: TCP:1521\nSCAN Listener LISTENER_SCAN1 exists\nSCAN Listener is enabled.<\/code><\/pre>\n<ul>\n<li>3\u4e2a scanip \u60c5\u5f62<\/li>\n<\/ul>\n<pre><code class=\"language-shell\"># \u67e5\u770bscan\u7684\u914d\u7f6e\u4fe1\u606f\n~] srvctl config scan\n\nSubnet IPv4: 192.168.21.128\/255.255.255.128\/bond0, static\nSubnet IPv6:\nSCAN 1 IPv4 VIP: 192.168.21.135\nSCAN VIP is enabled.\nSCAN VIP is individually enabled on nodes:\nSCAN VIP is individually disabled on nodes:\nSCAN 2 IPv4 VIP: 192.168.21.134\nSCAN VIP is enabled.\nSCAN VIP is individually enabled on nodes:\nSCAN VIP is individually disabled on nodes:\nSCAN 3 IPv4 VIP: 192.168.21.136\nSCAN VIP is enabled.\nSCAN VIP is individually enabled on nodes:\nSCAN VIP is individually disabled on nodes:\n\n# \u67e5\u770bscan\u7684\u72b6\u6001\u4ee5\u53cascan ip\u6240\u5904\u8282\u70b9\n~] srvctl status scan\n\nSCAN VIP scan1 is enabled\nSCAN VIP scan1 is running on node dbcenter1\nSCAN VIP scan2 is enabled\nSCAN VIP scan2 is running on node dbcenter2\nSCAN VIP scan3 is enabled\nSCAN VIP scan3 is running on node dbcenter2\n\n# \u67e5\u770bscan listener\n~] srvctl config scan_listener\n\nSCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521,30011\nRegistration invited nodes:\nRegistration invited subnets:\nSCAN Listener is enabled.\nSCAN Listener is individually enabled on nodes:\nSCAN Listener is individually disabled on nodes:\nSCAN Listener LISTENER_SCAN2 exists. Port: TCP:1521,30011\nRegistration invited nodes:\nRegistration invited subnets:\nSCAN Listener is enabled.\nSCAN Listener is individually enabled on nodes:\nSCAN Listener is individually disabled on nodes:\nSCAN Listener LISTENER_SCAN3 exists. Port: TCP:1521,30011\nRegistration invited nodes:\nRegistration invited subnets:\nSCAN Listener is enabled.\nSCAN Listener is individually enabled on nodes:\nSCAN Listener is individually disabled on nodes:<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"63_%E6%9F%A5%E8%AF%A2%E5%AE%B9%E5%99%A8%E6%95%B0%E6%8D%AE%E5%BA%93%E4%B8%AD%E6%89%80%E6%9C%89%E7%8A%B6%E6%80%81%E4%B8%BAOPEN%E7%9A%84%E7%94%A8%E6%88%B7\"><\/span>6.3. \u67e5\u8be2\u5bb9\u5668\u6570\u636e\u5e93\u4e2d\u6240\u6709\u72b6\u6001\u4e3aOPEN\u7684\u7528\u6237<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SET LINES 300 PAGES 999\nCOL pdb_name FORMAT A20\nCOL default_tablespace FORMAT A20\nCOL temporary_tablespace FORMAT A20\nCOL username FORMAT A20\nSELECT a.con_id,\n       b.pdb_name,\n       a.username,\n       a.account_status,\n       a.default_tablespace,\n       a.temporary_tablespace,\n       to_char(a.last_login,&#039;yyyy-MM-dd hh24:mi:ss&#039;) AS last_login\n  FROM cdb_users a, cdb_pdbs b\n WHERE a.con_id = b.pdb_id\n   AND a.account_status = &#039;OPEN&#039;\n ORDER BY b.pdb_name,a.username;<\/code><\/pre>\n<h3><span class=\"ez-toc-section\" id=\"7_RMAN%E5%A4%87%E4%BB%BD%E7%9B%B8%E5%85%B3\"><\/span>7. RMAN\u5907\u4efd\u76f8\u5173<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"71_%E6%9F%A5%E8%AF%A2RMAN%E5%A4%87%E4%BB%BD%E6%97%B6%E5%88%86%E9%85%8D%E4%BF%A1%E9%81%93%E5%AF%B9%E5%BA%94%E7%9A%84%E6%93%8D%E4%BD%9C%E7%B3%BB%E7%BB%9F%E8%BF%9B%E7%A8%8B%E5%8F%B7\"><\/span>7.1. \u67e5\u8be2RMAN\u5907\u4efd\u65f6\u5206\u914d\u4fe1\u9053\u5bf9\u5e94\u7684\u64cd\u4f5c\u7cfb\u7edf\u8fdb\u7a0b\u53f7<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SET LINES 300 PAGES 999\nCOLUMN EVENT FORMAT a60\nCOLUMN SECONDS_IN_WAIT FORMAT 999\nCOLUMN STATE FORMAT a20\nCOLUMN CLIENT_INFO FORMAT a30\n\nSELECT p.spid,\n       sw.event,\n       sw.seconds_in_wait,\n       sw.state,\n       s.client_info\n  FROM v$session_wait sw, v$session s, v$process p\n WHERE s.client_info LIKE &#039;%rman%&#039;\n   AND s.sid = sw.sid\n   AND s.paddr = p.addr;<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"72_%E6%9F%A5%E8%AF%A2_RMAN_%E5%A4%87%E4%BB%BD%E8%BF%9B%E5%BA%A6\"><\/span>7.2. \u67e5\u8be2 RMAN \u5907\u4efd\u8fdb\u5ea6<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SET LINES 300 PAGES 999\nCOL opname     FOR a35\nCOL start_time FOR a19\n\nSELECT inst_id,\n       sid,\n       serial#,opname,\n       to_char(start_time,&#039;yyyy-mm-dd hh24:mi:ss&#039;) AS start_time,\n       sofar,\n       totalwork,\n       round(sofar\/totalwork*100,2) AS &quot;%complete&quot;,\n       ceil(elapsed_seconds\/60)     AS elapsed_mi\n  FROM gv$session_longops\n WHERE opname LIKE &#039;RMAN%&#039;\n   AND totalwork &lt;&gt; 0\n ORDER BY start_time ASC;<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/12\/wp_editor_md_cb4757b8dd908720c07701e820410198.jpg\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/12\/wp_editor_md_cb4757b8dd908720c07701e820410198.jpg\" alt=\"\" \/><\/a><\/p>\n<h4><span class=\"ez-toc-section\" id=\"73_%E6%9F%A5%E7%9C%8B%E6%AF%8F%E5%A4%A9RMAN%E5%A4%87%E4%BB%BD%E5%A4%A7%E5%B0%8F\"><\/span>7.3. \u67e5\u770b\u6bcf\u5929RMAN\u5907\u4efd\u5927\u5c0f<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SET LINES 300 PAGES 999\nSELECT TO_CHAR(start_time, &#039;yyyy-mm-dd&#039;)                 AS start_time,\n       TO_CHAR(start_time, &#039;day&#039;)                        AS week_day,\n       ROUND(SUM(output_bytes) \/ 1024 \/ 1024 \/ 1024, 2)  AS size_gb\n  FROM v$backup_set_details\n GROUP BY TO_CHAR(start_time, &#039;yyyy-mm-dd&#039;),TO_CHAR(start_time, &#039;day&#039;)\n ORDER BY start_time DESC;<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"74_%E6%9F%A5%E7%9C%8B%E6%95%B0%E6%8D%AE%E5%BA%93%E6%98%AF%E5%90%A6%E5%BC%80%E5%90%AF%E4%BA%86%E5%9D%97%E6%94%B9%E5%8F%98%E8%B7%9F%E8%B8%AA\"><\/span>7.4. \u67e5\u770b\u6570\u636e\u5e93\u662f\u5426\u5f00\u542f\u4e86\u5757\u6539\u53d8\u8ddf\u8e2a<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SET LINES 300 PAGES 999\nCOL FILENAME FOR A60\nSELECT * FROM v$block_change_tracking;<\/code><\/pre>\n<ul>\n<li>RAC\u73af\u5883\u4e2d\u5f00\u542f\u5757\u6539\u53d8\u8ddf\u8e2a<\/li>\n<\/ul>\n<pre><code class=\"language-sql\">ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE &#039;+ARCHDG\/etdb\/block_change_tracking.log&#039;;<\/code><\/pre>\n<ul>\n<li>\u5355\u5b9e\u4f8b\u73af\u5883<\/li>\n<\/ul>\n<pre><code class=\"language-sql\">alter database enable block change tracking using file &#039;\/dbData\/OracleBack\/rman_change_track.f&#039; reuse;<\/code><\/pre>\n<ul>\n<li>\u5173\u95ed\u5757\u6539\u53d8\u8ddf\u8e2a<\/li>\n<\/ul>\n<pre><code class=\"language-sql\">ALTER DATABASE DISABLE BLOCK CHANGE TRACKING;<\/code><\/pre>\n<ul>\n<li>\u67e5\u770b  block change tracking \u6587\u4ef6\u7684\u4f4d\u7f6e\u53ca\u5927\u5c0f<\/li>\n<\/ul>\n<pre><code class=\"language-sql\">SET LINES 300 PAGES 999\nCOLUMN filename FORMAT a60;\n\nSELECT * FROM v$block_change_tracking;<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/05\/image-1652746712478.png\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/05\/image-1652746712478.png\" alt=\"file\" \/><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"8_%E5%85%83%E6%95%B0%E6%8D%AE%E7%9B%B8%E5%85%B3\"><\/span>8. \u5143\u6570\u636e\u76f8\u5173<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"81_%E6%9F%A5%E8%AF%A2%E6%9F%90%E4%B8%AA%E7%94%A8%E6%88%B7%E4%B8%8B%E8%A1%A8%E7%9A%84%E5%B1%9E%E6%80%A7\"><\/span>8.1. \u67e5\u8be2\u67d0\u4e2a\u7528\u6237\u4e0b\u8868\u7684\u5c5e\u6027<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<h4><span class=\"ez-toc-section\" id=\"82_%E6%9F%A5%E8%AF%A2%E6%9F%90%E4%B8%AA%E7%94%A8%E6%88%B7%E4%B8%8B%E5%AD%97%E6%AE%B5%E7%9A%84%E5%B1%9E%E6%80%A7\"><\/span>8.2. \u67e5\u8be2\u67d0\u4e2a\u7528\u6237\u4e0b\u5b57\u6bb5\u7684\u5c5e\u6027<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<h4><span class=\"ez-toc-section\" id=\"83_%E8%8E%B7%E5%8F%96%E6%9F%90%E4%B8%AA%E7%94%A8%E6%88%B7%E4%B8%8B%E4%B8%BB%E9%94%AE%E3%80%81%E5%94%AF%E4%B8%80%E6%80%A7%E7%BA%A6%E6%9D%9F%E5%92%8C%E6%A3%80%E6%9F%A5%E7%BA%A6%E6%9D%9F%E7%9A%84%E5%88%9B%E5%BB%BA%E8%AF%AD%E5%8F%A5\"><\/span>8.3. \u83b7\u53d6\u67d0\u4e2a\u7528\u6237\u4e0b\u4e3b\u952e\u3001\u552f\u4e00\u6027\u7ea6\u675f\u548c\u68c0\u67e5\u7ea6\u675f\u7684\u521b\u5efa\u8bed\u53e5<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SELECT dbms_metadata.GET_DEPENDENT_DDL(&#039;CONSTRAINT&#039;,table_name,owner)\n  FROM dba_constraints a\n WHERE a.owner = UPPER(&#039;&amp;\u8bf7\u8f93\u5165\u7528\u6237\u540d&#039;)\n   AND a.constraint_type NOT IN (&#039;R&#039;,&#039;?&#039;,&#039;O&#039;)\n GROUP BY a.owner,a.table_name;<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"84_%E6%9F%A5%E7%9C%8B%E8%A1%A8%E4%B8%8E%E7%B4%A2%E5%BC%95%E7%9A%84%E5%88%9B%E5%BB%BA%E8%AF%AD%E5%8F%A5\"><\/span>8.4. \u67e5\u770b\u8868\u4e0e\u7d22\u5f15\u7684\u521b\u5efa\u8bed\u53e5<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SET heading off\nSET echo off\nSET pages 999\nSET long 90000\n\nspool get_TABLE_ddl.sql\nSELECT dbms_metadata.get_ddl(&#039;TABLE&#039;,&#039;TABLE_NAME&#039;[,&#039;SCHEMA_NAME&#039;]) FROM dual;\nSELECT dbms_metadata.get_ddl(&#039;INDEX&#039;,&#039;INDEX_NAME&#039;[,&#039;SCHEMA_NAME&#039;]) FROM dual;\nspool off;<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/07\/image-1673111637936.png\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/07\/image-1673111637936.png\" alt=\"file\" \/><\/a><\/p>\n<h4><span class=\"ez-toc-section\" id=\"85_%E6%9F%A5%E7%9C%8B%E7%B4%A2%E5%BC%95%E5%8D%A0%E7%94%A8%E7%9A%84%E5%AD%98%E5%82%A8%E5%A4%A7%E5%B0%8F\"><\/span>8.5. \u67e5\u770b\u7d22\u5f15\u5360\u7528\u7684\u5b58\u50a8\u5927\u5c0f<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SET LINES 300 PAGES 999\nCOL tablespace_name FORMAT a12\nCOL owner FORMAT a12\nCOL segment_name FORMAT a30\nCOL partition_count FORMAT 99999999\nCOL segment_size FORMAT 999999999999.99\n\nSELECT tablespace_name              AS tablespace_name,\n       owner                        AS owner,\n       segment_name                 AS segment_name,\n       NVL(COUNT(partition_name),0) AS partition_count,\n       sum(bytes)\/1024\/1024         AS segment_size \n  FROM dba_segments\n WHERE tablespace_name = UPPER(&#039;&amp;TablespaceName&#039;)\n GROUP BY Tablespace_name,owner,segment_name\n ORDER BY 2,3;<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/07\/image-1673265929296.png\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/07\/image-1673265929296.png\" alt=\"file\" \/><\/a><\/p>\n<h4><span class=\"ez-toc-section\" id=\"86_%E8%8E%B7%E5%8F%96%E6%9F%90%E4%B8%AA%E7%94%A8%E6%88%B7%E4%B8%8B%E5%A4%96%E9%94%AE%E7%BA%A6%E6%9D%9F%E7%9A%84%E5%88%9B%E5%BB%BA%E8%AF%AD%E5%8F%A5\"><\/span>8.6. \u83b7\u53d6\u67d0\u4e2a\u7528\u6237\u4e0b\u5916\u952e\u7ea6\u675f\u7684\u521b\u5efa\u8bed\u53e5<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SELECT dbms_metadata.GET_DEPENDENT_DDL(&#039;REF_CONSTRAINT&#039;,table_name,owner)\n  FROM dba_constraints a\n WHERE a.owner = UPPER(&#039;&amp;\u8bf7\u8f93\u5165\u7528\u6237\u540d&#039;)\n   AND a.constraint_type = &#039;R&#039;\n GROUP BY a.owner, a.table_name;<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"87_%E5%90%AF%E7%94%A8%E7%A6%81%E7%94%A8%E6%9F%90%E4%B8%AA%E7%94%A8%E6%88%B7%E4%B8%8B%E5%A4%96%E9%94%AE%E7%BA%A6%E6%9D%9F%E7%9A%84%E8%AF%AD%E5%8F%A5\"><\/span>8.7. \u542f\u7528\/\u7981\u7528\u67d0\u4e2a\u7528\u6237\u4e0b\u5916\u952e\u7ea6\u675f\u7684\u8bed\u53e5<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">-- \u542f\u7528\u5916\u952e\u7ea6\u675f\nSELECT &#039;ALTER TABLE &#039; || table_name || &#039; ENABLE CONSTRAINT &#039;|| constraint_name || &#039;;&#039;\n  FROM dba_constraints\n WHERE owner = UPPER(&#039;&amp;\u8bf7\u8f93\u5165\u7528\u6237\u540d&#039;)\n   AND constraint_type = &#039;R&#039;;\n-- \u7981\u7528\u5916\u952e\u7ea6\u675f\nSELECT &#039;ALTER TABLE &#039; || table_name || &#039; DISABLE CONSTRAINT &#039; || constraint_name ||&#039;;&#039;\n  FROM dba_constraints\n WHERE owner = UPPER(&#039;&amp;\u8bf7\u8f93\u5165\u7528\u6237\u540d&#039;)\n   AND constraint_type = &#039;R&#039;;<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"88_%E9%80%9A%E8%BF%87%E9%93%BE%E6%8E%A5%E6%95%B0%E6%8D%AE%E5%BA%93%E8%8E%B7%E5%8F%96%E6%8F%92%E5%85%A5%E8%A1%A8%E7%9A%84SQL\"><\/span>8.8. \u901a\u8fc7\u94fe\u63a5\u6570\u636e\u5e93\u83b7\u53d6\u63d2\u5165\u8868\u7684SQL<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">WITH t\n  AS (SELECT x.table_name AS table_name,\n             listagg(x.column_name,&#039;,&#039;) WITHIN GROUP(ORDER BY x.table_name,x.column_id)  AS table_column_set\n        FROM user_tab_columns x\n       GROUP BY x.table_name)\nSELECT &#039;insert into &#039; || t.table_name || &#039;(&#039; ||  t.table_column_set || &#039;)&#039; ||\n       &#039; select &#039; || t.table_column_set ||\n       &#039;   from &#039; || t.table_name || &#039;@to_qdu;&#039;\n  FROM t;<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"023_%E6%9F%A5%E8%AF%A2%E6%95%B0%E6%8D%AE%E5%BA%93%E7%9A%84%E5%AF%86%E7%A0%81%E7%94%9F%E5%91%BD%E5%90%8C%E6%9C%9F\"><\/span>023. \u67e5\u8be2\u6570\u636e\u5e93\u7684\u5bc6\u7801\u751f\u547d\u540c\u671f<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SET LINES 300 PAGES 999\nCOL profile       FOR a30\nCOL resource_name FOR a40\nCOL limit         FOR a40\nSELECT *\n  FROM dba_profiles\n WHERE resource_name LIKE &#039;%PASSWORD%&#039;;<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"025_%E6%9F%A5%E8%AF%A2%E8%A7%92%E8%89%B2%E5%8F%8A%E7%B3%BB%E7%BB%9F%E6%9D%83%E9%99%90\"><\/span>025. \u67e5\u8be2\u89d2\u8272\u53ca\u7cfb\u7edf\u6743\u9650<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">-- \u67e5\u8be2\u7cfb\u7edf\u4e2d\u7684\u89d2\u8272\nSELECT *\n  FROM dba_roles a\n WHERE a.role = UPPER(&#039;execute_catalog_role&#039;);\n\n-- \u67e5\u8be2\u67d0\u4e2a\u7528\u6237\u6216\u89d2\u8272\u62e5\u6709\u7684\u89d2\u8272(\u6216\u62e5\u6709\u67d0\u4e2a\u89d2\u8272\u7684\u7528\u6237\u6216\u89d2\u8272)\nSELECT *\n  FROM dba_role_privs a\n WHERE a.granted_role = UPPER(&#039;connect&#039;)\n    OR a.grantee = &#039;DBA&#039;;\n\n-- \u67e5\u8be2\u5f53\u524d\u767b\u9646\u7528\u6237\u62e5\u6709\u7684\u89d2\u8272\u6743\u9650\nSELECT *\n  FROM user_role_privs a;\n\n-- \u67e5\u8be2\u67d0\u4e2a\u7528\u6237\u6216\u89d2\u8272\u62e5\u6709\u7684\u7cfb\u7edf\u6743\u9650\nSET LINES 300 PAGES 999\nCOL GRANTEE FOR A30\nSELECT *\n  FROM dba_sys_privs a\n WHERE a.grantee = UPPER(&#039;connect&#039;);\n\n-- \u67e5\u8be2\u5f53\u524d\u767b\u9646\u7528\u6237\u62e5\u6709\u7684\u7cfb\u7edf\u6743\u9650\nSELECT *\n  FROM user_sys_privs a;<\/code><\/pre>\n<p><span style='color:red'> \u89d2\u8272\u4e0d\u4e00\u5b9a\u5305\u542b\u7cfb\u7edf\u6743\u9650\uff0c\u6bd4\u5982  EXECUTE_CATALOG_ROLE \u89d2\u8272\u3002<\/span><\/p>\n<p>\u9884\u5b9a\u4e49\u6570\u636e\u5e93\u89d2\u8272\uff08\u5e38\u89c1\u76845\u4e2a\uff09\uff1a<\/p>\n<table>\n<thead>\n<tr>\n<th style=\"text-align: left;\">\u89d2\u8272\u540d\u79f0<\/th>\n<th style=\"text-align: left;\">\u89d2\u8272\u7528\u9014<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"text-align: left;\">CONNECT<\/td>\n<td style=\"text-align: left;\">\u57fa\u672c\u7684\u7528\u6237\u89d2\u8272\uff0c\u5141\u8bb8\u6388\u6743\u8005\u94fe\u63a5\u5230\u6570\u636e\u5e93\uff0c\u7136\u540e\u5728\u76f8\u5173\u7684\u6a21\u5f0f\u4e2d\u521b\u5efa\u8868\u3001\u89c6\u56fe\u3001\u540c\u4e49\u8bcd\u3001\u5e8f\u5217\u548c\u4e00\u4e9b\u5176\u4ed6\u7684\u5bf9\u8c61\u7c7b\u578b\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">RESOURCE<\/td>\n<td style=\"text-align: left;\">\u5efa\u8bae\u7528\u4e8e\u5178\u578b\u7684\u5e94\u7528\u5f00\u53d1\u4eba\u5458\u3002\u8be5\u89d2\u8272\u5141\u8bb8\u6388\u6743\u8005\u5728\u76f8\u5173\u7684\u6a21\u5f0f\u4e2d\u521b\u5efa\u8868\u3001\u5e8f\u5217\u3001\u6570\u636e\u7c07\u3001\u8fc7\u7a0b\u3001\u51fd\u6570\u3001\u5305\u3001\u89e6\u53d1\u5668\u3001\u5bf9\u8c61\u7c7b\u578b\u3001\u57fa\u4e8e\u51fd\u6570\u7684\u7d22\u5f15\u548c\u7528\u6237\u81ea\u5b9a\u4e49\u7684\u64cd\u4f5c\u7b26\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">DBA<\/td>\n<td style=\"text-align: left;\">\u5efa\u8bae\u7528\u6237\u7ba1\u7406\u5458\u3002\u8be5\u89d2\u8272\u5141\u8bb8\u6388\u6743\u8005\u6267\u884c\u4efb\u4f55\u6570\u636e\u5e93\u529f\u80fd\uff0c\u56e0\u4e3a\u5b83\u5305\u542b\u4e86\u8bf4\u6709\u7684\u7cfb\u7edf\u6743\u9650\u3002\u6b64\u5916\uff0c\u6539DBA\u89d2\u8272\u7684\u6388\u6743\u8005,\u53ef\u4ee5\u5411\u4efb\u4f55\u5176\u4ed6\u6570\u636e\u5e93\u7528\u6237\u6216\u89d2\u8272\u6388\u4e88\u4efb\u4f55\u7cfb\u7edf\u6743\u9650\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">SELECT_CATALOG_ROLE<\/td>\n<td style=\"text-align: left;\">\u8be5\u89d2\u8272\u5141\u8bb8\u6388\u6743\u8005\u67e5\u8be2\u7ba1\u7406\u5458(DBA)\u6570\u636e\u5b57\u5178\u89c6\u56fe\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">EXECUTE_CATALOG_ROLE<\/td>\n<td style=\"text-align: left;\">\u8be5\u89d2\u8272\u5141\u8bb8\u6388\u6743\u8005\u8fd0\u884c\u9884\u5236\u7684DBMS\u5de5\u5177\u5305\u3002<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u53c2\u89c1\uff1a <a target=\"_blank\" href=\"https:\/\/oracle-base.com\/dba\/scripts\">https:\/\/oracle-base.com\/dba\/scripts<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Oralce Database Reference&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":true,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23,2],"tags":[16,125],"class_list":{"0":"post-932","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"hentry","6":"category-oracle","8":"tag-oracle","9":"tag-125"},"_links":{"self":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts\/932","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=932"}],"version-history":[{"count":135,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts\/932\/revisions"}],"predecessor-version":[{"id":3103,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts\/932\/revisions\/3103"}],"wp:attachment":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=932"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=932"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=932"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}