{"id":1752,"date":"2024-05-09T16:21:09","date_gmt":"2024-05-09T08:21:09","guid":{"rendered":"http:\/\/oneai.eu.org\/?p=1752"},"modified":"2024-05-09T16:21:09","modified_gmt":"2024-05-09T08:21:09","slug":"%e5%b8%b8%e7%94%a8sql%e8%af%ad%e5%8f%a5%e6%8b%bc%e5%86%99%e4%bc%98%e5%8c%96","status":"publish","type":"post","link":"https:\/\/oneai.eu.org\/?p=1752","title":{"rendered":"\u5e38\u7528sql\u8bed\u53e5\u62fc\u5199\u4f18\u5316"},"content":{"rendered":"<div class=\"RichText ztext Post-RichText css-jflero\" options=\"[object Object]\">\n<p data-first-child=\"\" data-pid=\"j5IabK13\">Oracle\u5728\u6027\u80fd\u8c03\u4f18\u4e2d\u63d0\u4f9b\u4e86\u4e30\u5bcc\u7684\u5de5\u5177\u548c\u62a5\u8868\u652f\u6301\uff0c\u5982\u4f55\u4ece\u4f17\u591a\u6307\u6807\u83b7\u53d6\u6709\u4ef7\u503c\u7684\u8c03\u4f18\u4fe1\u606f\u5219\u9700\u8981\u5f00\u53d1\u6d4b\u8bd5\u4eba\u5458\u5177\u6709\u4e00\u5b9a\u7684\u57fa\u7840\u548c\u7ecf\u9a8c\u3002\u672c\u6587\u4e3b\u8981\u5bf9\u8fd1\u51e0\u5e74\u78b0\u5230\u9891\u7387\u8f83\u9ad8\u7684\u51e0\u7c7b\u6027\u80fd\u95ee\u9898\u8fdb\u884c\u7ecf\u9a8c\u603b\u7ed3\uff0c\u5e2e\u52a9\u5f00\u53d1\u3001\u6d4b\u8bd5\u4eba\u5458\u5728\u8c03\u4f18\u8fc7\u7a0b\u4e2d\u5c11\u8d70\u5f2f\u8def\uff0c\u5c3d\u5feb\u5b9a\u4f4d\u3001\u89e3\u51b3\u6027\u80fd\u95ee\u9898\u3002<\/p>\n<p data-pid=\"UyF6XYTJ\">\u9664\u53bb\u786c\u4ef6\u6545\u969c\u548c\u4ea7\u54c1\u672c\u8eabbug\u5916\uff0c\u672c\u6587\u5206\u4e3a\u914d\u7f6e\u7c7b\uff0csql\u6548\u7387\u7c7b\u3001\u5e94\u7528\u7a0b\u5e8f\u903b\u8f91\u4e09\u5927\u7c7b\u8fdb\u884c\u5f52\u7eb3\u4ecb\u7ecd\u3002<\/p>\n<figure data-size=\"normal\"><noscript><img decoding=\"async\" src=\"https:\/\/pic4.zhimg.com\/v2-fe8d851d28cd69171fed3a9e389fd15f_b.jpg\" data-caption=\"\" data-size=\"normal\" data-rawwidth=\"1267\" data-rawheight=\"760\" class=\"origin_image zh-lightbox-thumb\" width=\"1267\" data-original=\"https:\/\/pic4.zhimg.com\/v2-fe8d851d28cd69171fed3a9e389fd15f_r.jpg\"\/><\/noscript><\/p>\n<div><img fetchpriority=\"high\" decoding=\"async\" src=\"https:\/\/pic4.zhimg.com\/80\/v2-fe8d851d28cd69171fed3a9e389fd15f_720w.webp\" data-caption=\"\" data-size=\"normal\" data-rawwidth=\"1267\" data-rawheight=\"760\" class=\"origin_image zh-lightbox-thumb lazy\" width=\"1267\" data-original=\"https:\/\/pic4.zhimg.com\/v2-fe8d851d28cd69171fed3a9e389fd15f_r.jpg\" data-actualsrc=\"https:\/\/pic4.zhimg.com\/v2-fe8d851d28cd69171fed3a9e389fd15f_b.jpg\" data-original-token=\"v2-fe8d851d28cd69171fed3a9e389fd15f\" height=\"760\" data-lazy-status=\"ok\"><\/div>\n<\/figure>\n<p data-pid=\"qvbOzHOp\"><b>1.\u914d\u7f6e\u7c7b<\/b><\/p>\n<p data-pid=\"cO3yuTIr\"><b>1.1\u7ed1\u5b9a\u53d8\u91cf<\/b><\/p>\n<p data-pid=\"t9ruUTWv\">\u5728\u8054\u673a\u4ea4\u6613\u7cfb\u7edf\u4e2d\uff0c\u5bf9\u4e8e\u9891\u7e41\u6267\u884c\u7684SQL\u8bed\u53e5\uff0c\u5982\u679c\u6240\u67e5\u6570\u636e\u5206\u5e03\u8f83\u5747\u5300\u3001\u5206\u533a\u8f83\u5747\u8861\uff0c\u5efa\u8bae\u4f7f\u7528\u7ed1\u5b9a\u53d8\u91cf\u4ee3\u66ff\u5e38\u91cf\uff0c\u4ee5\u907f\u514d\u591a\u6b21\u91cd\u590d\u786c\u89e3\u6790(Hard Parse)\uff0c\u8282\u7701\u65f6\u95f4\u3001\u8d44\u6e90\u6210\u672c\u3002<\/p>\n<p data-pid=\"ygqBrayX\">\u53cd\u4f8b\uff1a<\/p>\n<p data-pid=\"sdl4Kk7a\">\u3000\u3000select * from user where  userid=1;<\/p>\n<p data-pid=\"fXinGrSB\">\u3000\u3000select * from user where   userid=2;<\/p>\n<p data-pid=\"WTKUt7x9\">\u3000\u3000\u6b63\u4f8b\uff1a<\/p>\n<p data-pid=\"2zIcT0aL\">\u3000\u3000b1=1;<\/p>\n<p data-pid=\"ijOPiFN0\">\u3000\u3000select * from user where  userid= :b1;<\/p>\n<p data-pid=\"AL5Zh18n\">\u3000\u3000b1=2;<\/p>\n<p data-pid=\"rx3CP6s2\">\u3000\u3000select * from user where  userid= :b1;<\/p>\n<p data-pid=\"0Vk4a7LW\">\u786c\u89e3\u6790\u6307\u6807\u53c2\u8003AWR\u62a5\u544a\u4e2dLoad Profile--&gt;Hard Parse\/Sec\uff08\u53c2\u8003\u503c\uff1a&lt; 2 or 10\uff09\uff0c\u7b14\u8005\u4e00\u822c\u4f1a\u5728\u5927\u4e8e1\u65f6\u7528\u4ee5\u4e0b\u811a\u672c\u67e5\u627e\u53ef\u80fd\u9700\u4f7f\u7528\u7ed1\u5b9a\u53d8\u91cf\u4f18\u5316\u7684SQL\u3002<\/p>\n<p data-pid=\"FcNkdJPi\">1\u3001\u5229\u7528force_matching_signature\u67e5\u8be2\u53ef\u80fd\u53ef\u4ee5\u4f7f\u7528\u7ed1\u5b9a\u53d8\u91cf\u7684\u8bed\u53e5\u6570\u91cf<\/p>\n<p data-pid=\"flb7f3Bz\">\u3000\u3000select v.force_matching_signature ,count(*) from v$sql v where FORCE_MATCHING_SIGNATURE &lt;&gt; EXACT_MATCHING_SIGNATURE and PARSING_SCHEMA_NAME &lt;&gt; 'SYS' group  by v.force_matching_signature having count(*)&gt;&amp;a order by  2;<\/p>\n<p data-pid=\"g7O-WQAN\">2\u3001\u67e5\u51fa\u7591\u4f3c\u53ef\u4f7f\u7528\u7ed1\u5b9a\u53d8\u91cf\u7684SQL\u8bed\u53e5<\/p>\n<p data-pid=\"kmHJm0gn\">\u3000\u3000select PARSING_SCHEMA_NAME,sql_text,sql_id from v$sql where  force_matching_signature='force_matching_signature_IDinStep1';<\/p>\n<ol>\n<li data-pid=\"eoD6qYzC\">\u6839\u636e\u67e5\u8be2\u7ed3\u679c\u4e0e\u5f00\u53d1\u4eba\u5458\u6c9f\u901a\uff0c\u786e\u8ba4\u662f\u5426\u53ef\u7528\u7ed1\u5b9a\u53d8\u91cf\u7684\u65b9\u5f0f\u5bf9SQL\u8bed\u53e5\u8fdb\u884c\u4f18\u5316\u3002<\/li>\n<\/ol>\n<p data-pid=\"5Ki4QI_M\">1\uff09\u5229\u7528force_matching_signature\u67e5\u8be2\u53ef\u80fd\u53ef\u4ee5\u4f7f\u7528\u7ed1\u5b9a\u53d8\u91cf\u7684\u8bed\u53e5\u6570\u91cf<\/p>\n<p data-pid=\"jRfeT92a\">\u3000\u3000select v.force_matching_signature ,count(*) from v$sql v where FORCE_MATCHING_SIGNATURE &lt;&gt; EXACT_MATCHING_SIGNATURE and PARSING_SCHEMA_NAME &lt;&gt; 'SYS' group  by v.force_matching_signature having count(*)&gt;&amp;a order by  2;<\/p>\n<p data-pid=\"72LqWUDI\">2\uff09\u67e5\u51fa\u7591\u4f3c\u53ef\u4f7f\u7528\u7ed1\u5b9a\u53d8\u91cf\u7684SQL\u8bed\u53e5<\/p>\n<p data-pid=\"h0J6G_4u\">\u3000\u3000select PARSING_SCHEMA_NAME,sql_text,sql_id from v$sql where  force_matching_signature='force_matching_signature_IDinStep1';<\/p>\n<p data-pid=\"XlHNok2A\">3\uff09\u6839\u636e\u67e5\u8be2\u7ed3\u679c\u4e0e\u5f00\u53d1\u4eba\u5458\u6c9f\u901a\uff0c\u786e\u8ba4\u662f\u5426\u53ef\u7528\u7ed1\u5b9a\u53d8\u91cf\u7684\u65b9\u5f0f\u5bf9SQL\u8bed\u53e5\u8fdb\u884c\u4f18\u5316\u3002<\/p>\n<p data-pid=\"t4HDZSQD\">\u7ed1\u5b9a\u53d8\u91cf\u4e00\u5b9a\u80fd\u4f18\u5316\u6027\u80fd\u5417\uff1f<\/p>\n<p data-pid=\"wGXzwYft\">--\u5c0f\u5fc3\u201c\u7ed1\u5b9a\u5077\u7aa5\u201d\uff01\uff01\uff01<\/p>\n<p data-pid=\"VHMjCEFA\">   T1\u8868\u5305\u542b100\u4e07\u6761\u8bb0\u5f55\uff0cstatus\u5b57\u6bb5\u542b\u2018A\u2019\uff0c\u2018C\u2019\u4e24\u79cd\u4e0d\u540c\u53d6\u503c\uff0c\u5176\u4e2d\uff1a<\/p>\n<p data-pid=\"cZPN29Bx\">\u3000\u3000status=\u2018A\u2019 99\u4e079990\u6761<\/p>\n<p data-pid=\"zp_COSff\">\u3000\u3000status=\u2018C\u2019 10\u6761<\/p>\n<p data-pid=\"TtDmRuFN\">\u3000\u3000SQL1\uff1aSelect * from T1 where status=:b1<\/p>\n<p data-pid=\"NMPTxgaR\">\u3000\u3000:b1 =\u2018A\u2019\uff0c\u5219\u5355\u8868\u8bbf\u95ee\u8def\u5f84\u8d70\u5168\u8868\u626b\u63cf<\/p>\n<p data-pid=\"K-FOnM4l\">\u3000\u3000SQL2\uff1aSelect * from T1 where status=:b1<\/p>\n<p data-pid=\"V0C4jtMu\">\u3000\u3000:b1 =\u2018C\u2019\uff0c\u5219\u5355\u8868\u8bbf\u95ee\u8def\u5f84\u8d70\u7d22\u5f15\u8303\u56f4\u626b\u63cf<\/p>\n<p data-pid=\"hgGqnN0v\">\u7406\u60f3\u60c5\u51b5\u4e0b\uff0c\u4f20\u5165\u4e0d\u540c\u53d8\u91cf\u7684\u503c\uff0c\u5e94\u8be5\u8d70\u4e0d\u4e00\u6837\u7684\u5355\u8868\u8bbf\u95ee\u8def\u5f84\uff0c\u4f46Oracle\u4f18\u5316\u5668\u8fd8\u4e0d\u591f\u667a\u80fd\u3002Oracle\u5728\u7b2c\u4e00\u6b21\u505a\u786c\u89e3\u6790\uff08\u5185\u5b58\u4e2d\u6ca1\u6709\u7f13\u5b58\u6267\u884c\u8ba1\u5212\uff09\u7684\u65f6\u5019\uff0c\u4f1a\u5148\u201c\u5077\u7aa5\u201d\u4e00\u773c\uff0c\u53d8\u91cf\u7684\u503c\u4f20\u5165\u7684\u662f\u4ec0\u4e48\uff0c\u5982\u679c\u4f20\u5165\u7684\u662f\u201cA\u201d,\u5219\u8d70\u5168\u8868\u626b\u63cf\uff1b\u5e76\u4e14\u628a\u6267\u884c\u8ba1\u5212\u7f13\u5b58\u3002<\/p>\n<p data-pid=\"6CGKgRHG\">\u4e0b\u4e00\u6b21\u6267\u884c\u7684\u65f6\u5019\uff0c\u7531\u4e8e\u6267\u884c\u8ba1\u5212\u5df2\u7ecf\u7f13\u5b58\uff0c\u5c31\u4e0d\u518d\u201c\u5077\u7aa5\u201d\u53d8\u91cf\u7684\u503c\u4e86\uff0c\u800c\u662f\u76f4\u63a5\u6cbf\u7528\u5168\u8868\u626b\u63cf\u7684\u6267\u884c\u8ba1\u5212\u3002\u8fd9\u4e2a\u65f6\u5019\u5373\u4f7f\u4f20\u5165\u7684status\u53d8\u91cf\u4e3aC\uff0c\u4e5f\u8d70\u4e0d\u4e0a\u7d22\u5f15\u4e86\u3002<\/p>\n<p data-pid=\"wq8K780B\">\u8fd9\u4e2a\u73b0\u8c61\u79f0\u4e3a\u201c\u7ed1\u5b9a\u53d8\u91cf\u5077\u7aa5\u73b0\u8c61\u201d\u3002\u4e00\u6761SQL\u8bed\u53e5\u9002\u5408\u91c7\u7528\u4f55\u79cd\u89e3\u6790\u65b9\u5f0f\u9700\u8981\u8861\u91cf\u786c\u89e3\u6790\u5e26\u6765\u7684\u8d44\u6e90\u5f00\u9500\u548c\u67e5\u8be2\u8ba1\u5212\u4e0d\u51c6\u5e26\u6765\u7684\u8d44\u6e90\u5f00\u9500\uff0c\u4ece\u800c\u786e\u5b9a\u662f\u5426\u91c7\u7528\u7ed1\u5b9a\u53d8\u91cf\u3002\u4e24\u79cd\u89e3\u6790\u9002\u7528\u573a\u666f\u603b\u7ed3\u5982\u4e0b\uff1a<\/p>\n<figure data-size=\"normal\"><noscript><img decoding=\"async\" src=\"https:\/\/pic2.zhimg.com\/v2-911fcf29f7685c1057f97c9512f472ed_b.jpg\" data-caption=\"\" data-size=\"normal\" data-rawwidth=\"585\" data-rawheight=\"145\" class=\"origin_image zh-lightbox-thumb\" width=\"585\" data-original=\"https:\/\/pic2.zhimg.com\/v2-911fcf29f7685c1057f97c9512f472ed_r.jpg\"\/><\/noscript><\/p>\n<div><img decoding=\"async\" src=\"https:\/\/pic2.zhimg.com\/80\/v2-911fcf29f7685c1057f97c9512f472ed_720w.webp\" data-caption=\"\" data-size=\"normal\" data-rawwidth=\"585\" data-rawheight=\"145\" class=\"origin_image zh-lightbox-thumb lazy\" width=\"585\" data-original=\"https:\/\/pic2.zhimg.com\/v2-911fcf29f7685c1057f97c9512f472ed_r.jpg\" data-actualsrc=\"https:\/\/pic2.zhimg.com\/v2-911fcf29f7685c1057f97c9512f472ed_b.jpg\" data-original-token=\"v2-911fcf29f7685c1057f97c9512f472ed\" height=\"145\" data-lazy-status=\"ok\"><\/div>\n<\/figure>\n<p data-pid=\"Csr-TiKy\">1.2\u8fde\u63a5\u6c60<\/p>\n<p data-pid=\"E0R5l3Aq\">\u7ecf\u5e38\u6536\u5230\u4e00\u4e9b\u201c\u600e\u4e48\u67e5\u770b\u5e94\u7528\u5230Oracle\u8fde\u63a5\u6c60\u662f\u5426\u591f\u7528\u201d\uff0c\u201c\u7cfb\u7edftps\u5f88\u4f4e\uff0cSQL\u4e5f\u7b80\u5355\uff0c\u4e3a\u5565\u6570\u636e\u5e93\u670d\u52a1\u5668cpu&gt;10%\uff1f\u201d<\/p>\n<p data-pid=\"E2v78qUg\">\u9664\u4e86\u6839\u636e\u670d\u52a1\u5668\u8fde\u63a5\u6570\u6216\u5229\u7528\u7b2c\u4e09\u65b9\u5de5\u5177\uff0c\u53ef\u4ece\u4ee5\u4e0b4\u4e2a\u65b9\u9762\u95f4\u63a5\u5224\u65ad\u8fde\u63a5\u6c60\u662f\u5426\u591f\u7528\uff1a<\/p>\n<p data-pid=\"hZbvKMVf\">1. \u53c2\u8003AWR\u62a5\u544a\u4e2dLoad Profile--&gt;Logons \/Sec\uff0c\u53c2\u8003\u503c\uff1a&lt; 2 or 10\u3002<\/p>\n<p data-pid=\"SC8RzFoW\">2. \u53c2\u8003ADDM\u4e2d\u51fa\u73b0Session Connect and Disconnect--&gt; Percent of Activity &gt; 10\u3002<\/p>\n<p data-pid=\"iAYLEsXE\">3. top\u547d\u4ee4\u4e2dcpu\u6d88\u8017\u6392\u5728\u524d10\u4f4d\u8fdb\u7a0b\u4e2d\u542btnslsnr\uff0c\u6216\u8be5\u8fdb\u7a0b\u6d88\u8017cpu &gt; 10%\u3002<\/p>\n<p data-pid=\"rF2MDr6X\">4. alert.log\u4e2d\u51fa\u73b0\u8fde\u63a5\u9891\u7e41\u5efa\u7acb\u6216\u65ad\u5f00\u7684\u544a\u8b66\u3002<\/p>\n<p data-pid=\"yye3hHUb\">\u82e5\u51fa\u73b0\u4e0a\u8ff0\u73b0\u8c61\uff0c\u5e94\u8003\u8651\u9002\u5f53\u589e\u52a0\u8fde\u63a5\u6c60\u6216\u68c0\u67e5\u5e94\u7528\u662f\u5426\u7528\u5230\u8fde\u63a5\u6c60\u3002<\/p>\n<p data-pid=\"8BNr5fUx\">1.3\u5e76\u884c\u6a21\u5f0fPARALLEL<\/p>\n<p data-pid=\"WY5694gD\">\u5e76\u884c\u6a21\u5f0f\u9002\u7528\u4e8e\u9488\u5bf9\u5927\u6570\u636e\u91cf\u7684\u64cd\u4f5c\uff0c\u5e94\u7528\u5f97\u5f53\u80fd\u5927\u5927\u7f29\u77ed\u8ba1\u7b97\u65f6\u95f4\u3002\u4f46\u5176\u52a3\u52bf\u5728\u4e8e\uff1a\u8d44\u6e90\u8c03\u5ea6\u3001\u5408\u5e76\u7ed3\u679c\u96c6\u7b49\u6bd4\u8f83\u6d88\u8017\u8d44\u6e90\uff0c\u4e0d\u5efa\u8bae\u5728\u7cfb\u7edf\u8d85\u8d1f\u8377\u8fd0\u884c\u7684\u60c5\u51b5\u4e0b\u4f7f\u7528\u3002\u5e76\u884c\u6a21\u5f0f\u4f7f\u7528\u5e94\u6ce8\u610f\u4ee5\u4e0b\u51e0\u9879\uff1a<\/p>\n<p data-pid=\"Raig93J6\">1.\u8054\u673a\u4ea4\u6613\u5f80\u5f80\u5e76\u53d1\u8f83\u9ad8\uff0c\u5e94\u907f\u514d\u4f7f\u7528\u5e76\u884c\u3002<\/p>\n<p data-pid=\"z7RYrMiC\">2.\u8054\u673a\u4ea4\u6613\u9ad8\u5cf0\u65f6\u6bb5\uff0c\u907f\u514d\u6279\u91cf\u6216\u62a5\u8868\u4f7f\u7528\u5e76\u884c\u3002<\/p>\n<p data-pid=\"j4isLyYt\">3.\u5e76\u884c\u67e5\u8be2\u7684\u4f18\u5148\u7ea7\u4e3a\u8bed\u53e5\u63d0\u793a(hint)\u3001\u8868\u7ea7\u5b9a\u4e49\u3001\u6570\u636e\u5e93\u521d\u59cb\u5316\u53c2\u6570\u3002\u540e\u4e24\u8005\u6613\u9020\u6210\u54cd\u5e94\u65f6\u95f4\u6162\u3001\u8868\u626b\u63cf\u3001\u4f1a\u8bdd\u963b\u585e\u7b49\u5f02\u5e38\uff0c\u4e0d\u5efa\u8bae\u5728\u5e94\u7528\u8fd0\u884c\u65f6\u4f7f\u7528\u3002<\/p>\n<p data-pid=\"Zpe01z2j\">4.\u5bf9\u4e8e\u8f83\u5927\u7684\u6570\u636e\u91cf\u7684\u67e5\u8be2\uff0c\u53ef\u4ee5\u4f7f\u7528\u63d0\u793a(hint)\u6765\u5f3a\u5236Oracle\u4f7f\u7528\u5e76\u884c\u67e5\u8be2\u3002<\/p>\n<p data-pid=\"gnCHVZEI\">5.\u5efa\u8868\u3001\u7d22\u5f15\u65f6\u5982\u9700\u4f7f\u7528PARALLEL\uff0c\u5b8c\u6210\u540e\u5207\u8bb0\u5173\u95ed\u5e76\u884c\u5ea6\uff0c\u5426\u5219\u4f1a\u9020\u6210\u540e\u7eed\u4f7f\u7528\u8be5\u8868\u3001\u7d22\u5f15\u7684SQL\u542f\u7528\u4e86\u5e76\u884c,\u5360\u7528\u8fc7\u591a\u8d44\u6e90\uff0c\u5bfc\u81f4\u5176\u5b83\u4f1a\u8bdd\u7b49\u5f85\uff0c\u5f71\u54cd\u7cfb\u7edf\u6574\u4f53\u6027\u80fd\u3002<\/p>\n<p data-pid=\"Gpq6r13B\">6.\u4efb\u52a1\u5e76\u884c\u5ea6\u4e0d\u5e94\u5927\u4e8e\u670d\u52a1\u5668CPU\u6570\uff0c\u5efa\u8bae\u5355\u4e2a\u4efb\u52a1\u5e76\u884c\u5ea6\u5e94\u5c0f\u4e8eCPU\u6570\/2\u3002<\/p>\n<p data-pid=\"asAe7VVP\">1.4\u7edf\u8ba1\u4fe1\u606f\u7f3a\u4e4f\u6216\u9648\u65e7<\/p>\n<p data-pid=\"ttxUr9Tl\">\u5f00\u53d1\u6d4b\u8bd5\u73af\u5883\u5f80\u5f80\u7f3a\u4e4f\u7edf\u8ba1\u4fe1\u606f\u66f4\u65b0\u673a\u5236\uff0c\u7edf\u8ba1\u4fe1\u606f\u9648\u65e7\u53ef\u80fd\u9020\u6210SQL\u67e5\u8be2\u8ba1\u5212\u6709\u8bef\uff0c\u67e5\u8be2\u6548\u7387\u4f4e\u4e0b\u3002\u5927\u91cf\u7684\u6570\u636e\u52a0\u8f7d\u6216\u66f4\u65b0\u540e\u5e94\u53ca\u65f6\u6536\u96c6\u7edf\u8ba1\u4fe1\u606f\u3002<\/p>\n<p data-pid=\"rfWAxnfq\">1.5\u7269\u5316\u89c6\u56fe<\/p>\n<p data-pid=\"teGjLdde\">\u7269\u5316\u89c6\u56fe\u662f\u4e00\u79cd\u7279\u6b8a\u7684\u7269\u7406\u8868\uff0c\u5360\u7528\u5b9e\u9645\u7684\u5b58\u50a8\u7a7a\u95f4\uff0c\u53ef\u7528\u4e8e\u8bfb\u5199\u5206\u79bb\uff0c\u6216\u8005\u9884\u5148\u8ba1\u7b97\u5e76\u4fdd\u5b58\u8868\u8fde\u63a5\u3001\u5d4c\u5957\u6216\u805a\u96c6\u7b49\u8017\u65f6\u8f83\u591a\u7684\u64cd\u4f5c\u7ed3\u679c\uff0c\u5728\u6267\u884c\u67e5\u8be2\u65f6\u80fd\u907f\u514d\u8fd9\u4e9b\u8017\u65f6\u64cd\u4f5c\uff0c\u4ece\u800c\u5feb\u901f\u5f97\u5230\u7ed3\u679c\u3002\u7269\u5316\u89c6\u56fe\u4e3b\u8981\u7528\u4e8e\u6570\u636e\u4ed3\u5e93\u548c\u51b3\u7b56\u652f\u6301\u7cfb\u7edf\uff0c\u4f7f\u7528\u7269\u5316\u89c6\u56fe\u9700\u6ce8\u610f\uff1a<\/p>\n<p data-pid=\"L61K83Tb\">1.\u5bf9\u4e8e\u9ad8\u5e76\u53d1\u7684\u8054\u673a\u7cfb\u7edf\u3001\u57fa\u8868\u6570\u636e\u9891\u7e41\u66f4\u65b0\u4e14\u5bf9\u6570\u636e\u5b9e\u65f6\u6027\u8981\u6c42\u9ad8\u7684\u4ea4\u6613\u907f\u514d\u8bbf\u95ee\u7269\u5316\u89c6\u56fe\u3002<\/p>\n<p data-pid=\"G97Yi3dl\">2.\u57fa\u8868\u6570\u636e\u53d8\u66f4\u9891\u7e41\uff0c\u4e00\u822c\u4e0d\u5efa\u8bae\u4f7f\u7528ON COMMIT\u6570\u636e\u5237\u65b0\u6a21\u5f0f\uff0c\u63a8\u8350\u4f7f\u7528\u9ed8\u8ba4\u7684ON DEMAND\u624b\u5de5\u6a21\u5f0f\u3002<\/p>\n<p data-pid=\"k8k3RCrv\">3. ON DEMAND\u6a21\u5f0f\u4e0b\u7528\u5230FAST\u589e\u91cf\u5237\u65b0\u65f6\uff0c\u5fc5\u987b\u5728\u521b\u5efa\u6709\u7269\u5316\u89c6\u56fe\u65e5\u5fd7\u7684\u60c5\u51b5\u4e0b\u624d\u80fd\u4f7f\u7528\u3002<\/p>\n<p data-pid=\"4Q3AVAjb\">4.\u7269\u5316\u89c6\u56fe\u65e5\u5fd7\u7684\u5927\u5c0f\u76f4\u63a5\u4f1a\u5f71\u54cd\u5237\u65b0\u901f\u5ea6\u3002\u7269\u5316\u89c6\u56fe\u957f\u65f6\u95f4\u4e0d\u5237\u65b0\uff0c\u6216\u8005\u57fa\u8868\u7684\u4e00\u6b21\u6279\u91cf\u6570\u636e\u53d8\u66f4\u5747\u4f1a\u5bfc\u81f4\u7269\u5316\u89c6\u56fe\u65e5\u5fd7\u53d8\u5f97\u5f88\u5927\u3002<\/p>\n<p data-pid=\"XHsfizWD\">5.\u7269\u5316\u89c6\u56fe\u65e5\u5fd7\u7684\u9ad8\u6c34\u4f4d\u8fbe\u5230\u8f83\u9ad8\u4f4d\u7f6e\uff0c\u5373\u4f7f\u7269\u5316\u89c6\u56fe\u65e5\u5fd7\u4e2d\u8bb0\u5f55\u5f88\u5c11\u751a\u81f3\u6ca1\u6709\uff0c\u4ecd\u7136\u4f1a\u5f71\u54cd\u7269\u5316\u89c6\u56fe\u7684\u5237\u65b0\u901f\u5ea6\u3002<\/p>\n<p data-pid=\"gZxvQvq8\"><b>2. SQL\u6548\u7387\u7c7b<\/b><\/p>\n<p data-pid=\"nOamYQB-\">\u4e0d\u5408\u7406\u7684\u6570\u636e\u7ed3\u6784\u8bbe\u8ba1\uff0cSQL\u4e66\u5199\u4e0d\u89c4\u8303\u4f1a\u5bfc\u81f4\u7b1b\u5361\u5c14\u79ef\u64cd\u4f5c\u3001\u5168\u8868\u626b\u63cf\u3001\u7d22\u5f15\u8df3\u626b\u3001\u7d22\u5f15\u5168\u626b\u3001filter\u4f4e\u6548\u8fc7\u6ee4\u7b49\u4f4e\u6548\u64cd\u4f5c\uff0c\u4ece\u800c\u5bfc\u81f4SQL\u6548\u7387\u751a\u81f3\u5e94\u7528\u6027\u80fd\u5927\u6253\u6298\u6263\u3002\u672c\u7ae0\u8282\u5217\u51fa\u4e86\u5e38\u89c1\u7684\u5bfc\u81f4SQL\u4f4e\u6548\u7684\u6761\u4f8b\uff0c\u5b9e\u9645\u5f00\u53d1\u6d4b\u8bd5\u8fc7\u7a0b\u4e2d\u53ef\u80fd\u9700\u8981\u7ed3\u5408\u67e5\u8be2\u8ba1\u5212\u3001\u7edf\u8ba1\u4fe1\u606f\u3001V$_*\u7b49\u8fdb\u884c\u8c03\u4f18\u9a8c\u8bc1\u3002<\/p>\n<p data-pid=\"7DIZ2I8F\">2.1\u8868\u7ed3\u6784\u4e0d\u5408\u7406<\/p>\n<p data-pid=\"v5h6o6kl\">\u8868\u7ed3\u6784\u4e0d\u5408\u7406\u4e00\u822c\u8868\u73b0\u5728\uff1a\u7f3a\u5c11\u4e3b\u952e\u3001\u7d22\u5f15\u6216\u7d22\u5f15\u8bbe\u8ba1\u4e0d\u5f53\uff0c\u5c24\u5176\u662f\u590d\u5408\u7d22\u5f15\u7684\u9009\u62e9\u548c\u6392\u5e8f\u4e0a\u3002\u8868\u8fde\u63a5\u7684\u65f6\u5019\u6070\u5f53\u4f7f\u7528\u7d22\u5f15\u53ef\u4ee5\u907f\u514d\u8868\u626b\u548c\u6392\u5e8f\u7684\u53d1\u751f\u3002<\/p>\n<figure data-size=\"normal\"><noscript><img decoding=\"async\" src=\"https:\/\/pic3.zhimg.com\/v2-a26758ea37706d2f3b6c1e2c026ffea2_b.jpg\" data-caption=\"\" data-size=\"normal\" data-rawwidth=\"526\" data-rawheight=\"348\" class=\"origin_image zh-lightbox-thumb\" width=\"526\" data-original=\"https:\/\/pic3.zhimg.com\/v2-a26758ea37706d2f3b6c1e2c026ffea2_r.jpg\"\/><\/noscript><\/p>\n<div><img decoding=\"async\" src=\"https:\/\/pic3.zhimg.com\/80\/v2-a26758ea37706d2f3b6c1e2c026ffea2_720w.webp\" data-caption=\"\" data-size=\"normal\" data-rawwidth=\"526\" data-rawheight=\"348\" class=\"origin_image zh-lightbox-thumb lazy\" width=\"526\" data-original=\"https:\/\/pic3.zhimg.com\/v2-a26758ea37706d2f3b6c1e2c026ffea2_r.jpg\" data-actualsrc=\"https:\/\/pic3.zhimg.com\/v2-a26758ea37706d2f3b6c1e2c026ffea2_b.jpg\" data-original-token=\"v2-a26758ea37706d2f3b6c1e2c026ffea2\" height=\"348\" data-lazy-status=\"ok\"><\/div>\n<\/figure>\n<p data-pid=\"XLjH12MM\">2.2 SQL\u4e66\u5199\u8f83\u5dee<\/p>\n<figure data-size=\"normal\"><noscript><img decoding=\"async\" src=\"https:\/\/pic4.zhimg.com\/v2-fb47a5631375bdd99df3fbb2b2f5d7db_b.jpg\" data-caption=\"\" data-size=\"normal\" data-rawwidth=\"528\" data-rawheight=\"436\" class=\"origin_image zh-lightbox-thumb\" width=\"528\" data-original=\"https:\/\/pic4.zhimg.com\/v2-fb47a5631375bdd99df3fbb2b2f5d7db_r.jpg\"\/><\/noscript><\/p>\n<div><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/pic4.zhimg.com\/80\/v2-fb47a5631375bdd99df3fbb2b2f5d7db_720w.webp\" data-caption=\"\" data-size=\"normal\" data-rawwidth=\"528\" data-rawheight=\"436\" class=\"origin_image zh-lightbox-thumb lazy\" width=\"528\" data-original=\"https:\/\/pic4.zhimg.com\/v2-fb47a5631375bdd99df3fbb2b2f5d7db_r.jpg\" data-actualsrc=\"https:\/\/pic4.zhimg.com\/v2-fb47a5631375bdd99df3fbb2b2f5d7db_b.jpg\" data-original-token=\"v2-fb47a5631375bdd99df3fbb2b2f5d7db\" height=\"436\" data-lazy-status=\"ok\"><\/div>\n<\/figure>\n<p data-pid=\"QAKSnWMY\"><b>3. \u5e94\u7528\u7a0b\u5e8f\u903b\u8f91<\/b><\/p>\n<p data-pid=\"Ws6bgmQL\">\u5728\u6027\u80fd\u6d4b\u8bd5\u6d4b\u8bd5\u4e2d\u66fe\u9047\u89c1\u56e0\u5e94\u7528\u8bbe\u8ba1\u5bfc\u81f4\u6570\u636e\u5e93\u670d\u52a1\u5668\u74f6\u9888\uff0c\u5e38\u89c1\u7c7b\u578b\u6709\uff1a<\/p>\n<p data-pid=\"tnoEt_a6\">1.\u9ad8\u9891\u7684SQL\u8fd0\u884c\u5bfc\u81f4CPU\u7e41\u5fd9\u3002SQL\u8bed\u53e5\u5e73\u5747\u6267\u884c\u65f6\u95f4\u5f88\u5feb\uff0c\u4f46\u901a\u8fc7\u5bf9\u5355\u7b14\u4ea4\u6613\u8fd0\u884c\u7684sql\u8bed\u53e5\u53d1\u73b0\u5355\u7b14\u4ea4\u6613\u8fd0\u884c\u76f8\u540cSQL\u8fbe100\u904d\u4ee5\u4e0a\uff0c\u9700\u8981\u7ed3\u5408\u4e1a\u52a1\u903b\u8f91\u8003\u8651SQL\u8bbe\u8ba1\u7684\u5408\u7406\u6027\u3002<\/p>\n<p data-pid=\"qMCA72uc\">2.\u9ad8\u9891\u7684\u8bb0\u65e5\u5fd7\u5bfc\u81f4IO\u7b49\u5f85\u3002\u4f8b\u5982\u5355\u7b14\u666e\u901a\u67e5\u8be2\u4ea4\u6613\u6309\u7167\u52a8\u8d26\u7c7b\u91d1\u878d\u4ea4\u6613\u4e25\u683c\u8bb0\u5f55\u65e5\u5fd7\uff0c\u67e5\u8be2\u4ea4\u6613\u541e\u5410\u91cf\u8f83\u9ad8\u65f6\u589e\u52a0\u6570\u636e\u5e93\u670d\u52a1\u5668IO\u74f6\u9888\u3002<\/p>\n<p data-pid=\"EpAPb3xt\">3.\u5b57\u6bb5\u957f\u5ea6\u4e0d\u6ee1\u8db3\u4e1a\u52a1\u589e\u957f\u9700\u6c42\uff0c\u5bfc\u81f4\u952e\u503c\u51b2\u7a81\u7b49\u5f02\u5e38\u3002<\/p>\n<p data-pid=\"cn4vZgrp\">4.\u672a\u5bf9\u7528\u6237\u53cd\u590d\u63d0\u4ea4\u67e5\u8be2\u4f5c\u51fa\u9650\u5236\u3002\u5c24\u5176\u5bf9\u4e8e\u54cd\u5e94\u65f6\u95f4\u8f83\u957f\u7684SQL\u4ee5\u53ca\u7ed3\u679c\u96c6\u53ef\u80fd\u6bd4\u8f83\u5927\u7684SQL\uff0c\u5982\u672a\u9632\u6b62\u7528\u6237\u53cd\u590d\u70b9\u51fb\u4f1a\u5bf9\u6570\u636e\u5e93\u4ea7\u751f\u7684\u4e25\u91cd\u5f71\u54cd\u3002<\/p>\n<p data-pid=\"7roLTBNN\">5.\u5ba2\u6237\u5f80\u5f80\u53ea\u5173\u6ce8\u7684\u67e5\u8be2\u6392\u5e8f\u540e\u7684\u90e8\u5206\u7ed3\u679c\u96c6\uff0c\u4e3a\u4e86\u63a7\u5236\u8f93\u51fa\u7ed3\u679c\u96c6\u5927\u5c0f\uff0c\u51cf\u5c11\u7cfb\u7edf\u4e2dIO\uff0c\u5c06\u7ed3\u679c\u5c3d\u5feb\u5730\u8fd4\u56de\u7ed9\u5ba2\u6237\u7aef\uff0c\u5f00\u53d1\u4e0a\u7ecf\u5e38\u91c7\u7528\u5206\u9875\u67e5\u8be2\u3002<\/p>\n<p data-pid=\"RIzFAET6\"><b>\u672c\u6587\u6765\u6e90\uff1a\u4eca\u65e5\u5934\u6761\uff08Atstudy\u7f51\u6821\uff09\uff0c\u8f6c\u8f7d\u9700\u6ce8\u660e\u51fa\u5904\uff01<\/b><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Oracle\u5728\u6027\u80fd\u8c03\u4f18\u4e2d\u63d0\u4f9b\u4e86\u4e30\u5bcc\u7684\u5de5\u5177\u548c\u62a5\u8868\u652f\u6301\uff0c\u5982\u4f55\u4ece\u4f17\u591a\u6307\u6807\u83b7\u53d6\u6709\u4ef7\u503c\u7684\u8c03\u4f18\u4fe1\u606f\u5219\u9700\u8981\u5f00\u53d1\u6d4b\u8bd5\u4eba\u5458\u5177\u6709\u4e00\u5b9a\u7684\u57fa\u7840\u548c\u7ecf\u9a8c\u3002\u672c\u6587\u4e3b\u8981\u5bf9\u8fd1\u51e0\u5e74\u78b0\u5230\u9891\u7387\u8f83\u9ad8\u7684\u51e0\u7c7b\u6027\u80fd\u95ee\u9898\u8fdb\u884c\u7ecf\u9a8c\u603b\u7ed3\uff0c\u5e2e\u52a9\u5f00\u53d1\u3001\u6d4b\u8bd5\u4eba\u5458\u5728\u8c03\u4f18\u8fc7\u7a0b\u4e2d\u5c11\u8d70\u5f2f\u8def\uff0c\u5c3d\u5feb\u5b9a\u4f4d\u3001\u89e3\u51b3\u6027\u80fd\u95ee\u9898\u3002 \u9664\u53bb\u786c\u4ef6\u6545\u969c\u548c\u4ea7\u54c1\u672c\u8eabbug\u5916\uff0c\u672c\u6587\u5206\u4e3a\u914d\u7f6e\u7c7b\uff0csql\u6548\u7387\u7c7b\u3001\u5e94\u7528\u7a0b\u5e8f\u903b\u8f91\u4e09\u5927\u7c7b\u8fdb\u884c\u5f52\u7eb3\u4ecb\u7ecd\u3002 1.\u914d\u7f6e\u7c7b 1.1\u7ed1\u5b9a\u53d8\u91cf \u5728\u8054\u673a\u4ea4\u6613\u7cfb\u7edf\u4e2d\uff0c\u5bf9\u4e8e\u9891\u7e41\u6267\u884c\u7684SQL\u8bed\u53e5\uff0c\u5982\u679c\u6240\u67e5\u6570\u636e\u5206\u5e03\u8f83\u5747\u5300\u3001\u5206\u533a\u8f83\u5747\u8861\uff0c\u5efa\u8bae\u4f7f\u7528\u7ed1\u5b9a\u53d8\u91cf\u4ee3\u66ff\u5e38\u91cf\uff0c\u4ee5\u907f\u514d\u591a\u6b21\u91cd\u590d\u786c\u89e3\u6790(Hard Parse)\uff0c\u8282\u7701\u65f6\u95f4\u3001\u8d44\u6e90\u6210\u672c\u3002 \u53cd\u4f8b\uff1a \u3000\u3000select * from user where userid=1; \u3000\u3000select * from user where userid=2; \u3000\u3000\u6b63\u4f8b\uff1a \u3000\u3000b1=1; \u3000\u3000select * from user where userid= :b1; \u3000\u3000b1=2; \u3000\u3000select * from user where userid= :b1; \u786c\u89e3\u6790\u6307\u6807\u53c2\u8003AWR\u62a5\u544a\u4e2dLoad Profile&#8211;&gt;Hard Parse\/Sec\uff08\u53c2\u8003\u503c\uff1a&lt; 2 or 10\uff09\uff0c\u7b14\u8005\u4e00\u822c\u4f1a\u5728\u5927\u4e8e1\u65f6\u7528\u4ee5\u4e0b\u811a\u672c\u67e5\u627e\u53ef\u80fd\u9700\u4f7f\u7528\u7ed1\u5b9a\u53d8\u91cf\u4f18\u5316\u7684SQL\u3002 1\u3001\u5229\u7528force_matching_signature\u67e5\u8be2\u53ef\u80fd\u53ef\u4ee5\u4f7f\u7528\u7ed1\u5b9a\u53d8\u91cf\u7684\u8bed\u53e5\u6570\u91cf \u3000\u3000select v.force_matching_signature ,count(*) from v$sql v where FORCE_MATCHING_SIGNATURE &lt;&gt; EXACT_MATCHING_SIGNATURE and PARSING_SCHEMA_NAME &lt;&gt; &#8216;SYS&#8217; group by v.force_matching_signature having count(*)&gt;&amp;a order by 2; 2\u3001\u67e5\u51fa\u7591\u4f3c\u53ef\u4f7f\u7528\u7ed1\u5b9a\u53d8\u91cf\u7684SQL\u8bed\u53e5 \u3000\u3000select PARSING_SCHEMA_NAME,sql_text,sql_id from v$sql where force_matching_signature=&#8217;force_matching_signature_IDinStep1&#8242;; \u6839\u636e\u67e5\u8be2\u7ed3\u679c\u4e0e\u5f00\u53d1\u4eba\u5458\u6c9f\u901a\uff0c\u786e\u8ba4\u662f\u5426\u53ef\u7528\u7ed1\u5b9a\u53d8\u91cf\u7684\u65b9\u5f0f\u5bf9SQL\u8bed\u53e5\u8fdb\u884c\u4f18\u5316\u3002 1\uff09\u5229\u7528force_matching_signature\u67e5\u8be2\u53ef\u80fd\u53ef\u4ee5\u4f7f\u7528\u7ed1\u5b9a\u53d8\u91cf\u7684\u8bed\u53e5\u6570\u91cf \u3000\u3000select v.force_matching_signature ,count(*) from v$sql v where FORCE_MATCHING_SIGNATURE &lt;&gt; EXACT_MATCHING_SIGNATURE and PARSING_SCHEMA_NAME &lt;&gt; &#8216;SYS&#8217; group by v.force_matching_signature having count(*)&gt;&amp;a order by 2; 2\uff09\u67e5\u51fa\u7591\u4f3c\u53ef\u4f7f\u7528\u7ed1\u5b9a\u53d8\u91cf\u7684SQL\u8bed\u53e5 \u3000\u3000select PARSING_SCHEMA_NAME,sql_text,sql_id from v$sql where force_matching_signature=&#8217;force_matching_signature_IDinStep1&#8242;; 3\uff09\u6839\u636e\u67e5\u8be2\u7ed3\u679c\u4e0e\u5f00\u53d1\u4eba\u5458\u6c9f\u901a\uff0c\u786e\u8ba4\u662f\u5426\u53ef\u7528\u7ed1\u5b9a\u53d8\u91cf\u7684\u65b9\u5f0f\u5bf9SQL\u8bed\u53e5\u8fdb\u884c\u4f18\u5316\u3002 \u7ed1\u5b9a\u53d8\u91cf\u4e00\u5b9a\u80fd\u4f18\u5316\u6027\u80fd\u5417\uff1f &#8211;\u5c0f\u5fc3\u201c\u7ed1\u5b9a\u5077\u7aa5\u201d\uff01\uff01\uff01 T1\u8868\u5305\u542b100\u4e07\u6761\u8bb0\u5f55\uff0cstatus\u5b57\u6bb5\u542b\u2018A\u2019\uff0c\u2018C\u2019\u4e24\u79cd\u4e0d\u540c\u53d6\u503c\uff0c\u5176\u4e2d\uff1a \u3000\u3000status=\u2018A\u2019 99\u4e079990\u6761 \u3000\u3000status=\u2018C\u2019 10\u6761 \u3000\u3000SQL1\uff1aSelect * from T1 where status=:b1 \u3000\u3000:b1 =\u2018A\u2019\uff0c\u5219\u5355\u8868\u8bbf\u95ee\u8def\u5f84\u8d70\u5168\u8868\u626b\u63cf \u3000\u3000SQL2\uff1aSelect * from T1 where status=:b1 \u3000\u3000:b1 =\u2018C\u2019\uff0c\u5219\u5355\u8868\u8bbf\u95ee\u8def\u5f84\u8d70\u7d22\u5f15\u8303\u56f4\u626b\u63cf \u7406\u60f3\u60c5\u51b5\u4e0b\uff0c\u4f20\u5165\u4e0d\u540c\u53d8\u91cf\u7684\u503c\uff0c\u5e94\u8be5\u8d70\u4e0d\u4e00\u6837\u7684\u5355\u8868\u8bbf\u95ee\u8def\u5f84\uff0c\u4f46Oracle\u4f18\u5316\u5668\u8fd8\u4e0d\u591f\u667a\u80fd\u3002Oracle\u5728\u7b2c\u4e00\u6b21\u505a\u786c\u89e3\u6790\uff08\u5185\u5b58\u4e2d\u6ca1\u6709\u7f13\u5b58\u6267\u884c\u8ba1\u5212\uff09\u7684\u65f6\u5019\uff0c\u4f1a\u5148\u201c\u5077\u7aa5\u201d\u4e00\u773c\uff0c\u53d8\u91cf\u7684\u503c\u4f20\u5165\u7684\u662f\u4ec0\u4e48\uff0c\u5982\u679c\u4f20\u5165\u7684\u662f\u201cA\u201d,\u5219\u8d70\u5168\u8868\u626b\u63cf\uff1b\u5e76\u4e14\u628a\u6267\u884c\u8ba1\u5212\u7f13\u5b58\u3002 \u4e0b\u4e00\u6b21\u6267\u884c\u7684\u65f6\u5019\uff0c\u7531\u4e8e\u6267\u884c\u8ba1\u5212\u5df2\u7ecf\u7f13\u5b58\uff0c\u5c31\u4e0d\u518d\u201c\u5077\u7aa5\u201d\u53d8\u91cf\u7684\u503c\u4e86\uff0c\u800c\u662f\u76f4\u63a5\u6cbf\u7528\u5168\u8868\u626b\u63cf\u7684\u6267\u884c\u8ba1\u5212\u3002\u8fd9\u4e2a\u65f6\u5019\u5373\u4f7f\u4f20\u5165\u7684status\u53d8\u91cf\u4e3aC\uff0c\u4e5f\u8d70\u4e0d\u4e0a\u7d22\u5f15\u4e86\u3002 \u8fd9\u4e2a\u73b0\u8c61\u79f0\u4e3a\u201c\u7ed1\u5b9a\u53d8\u91cf\u5077\u7aa5\u73b0\u8c61\u201d\u3002\u4e00\u6761SQL\u8bed\u53e5\u9002\u5408\u91c7\u7528\u4f55\u79cd\u89e3\u6790\u65b9\u5f0f\u9700\u8981\u8861\u91cf\u786c\u89e3\u6790\u5e26\u6765\u7684\u8d44\u6e90\u5f00\u9500\u548c\u67e5\u8be2\u8ba1\u5212\u4e0d\u51c6\u5e26\u6765\u7684\u8d44\u6e90\u5f00\u9500\uff0c\u4ece\u800c\u786e\u5b9a\u662f\u5426\u91c7\u7528\u7ed1&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","footnotes":""},"categories":[88,100],"tags":[],"class_list":["post-1752","post","type-post","status-publish","format-standard","hentry","category-oracle","category-100"],"_links":{"self":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1752","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1752"}],"version-history":[{"count":1,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1752\/revisions"}],"predecessor-version":[{"id":1753,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1752\/revisions\/1753"}],"wp:attachment":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1752"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1752"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1752"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}