数据库版本,sql*plus版本都是10.2.0.4.0 SQL> CREATE TABLE ZSJ_OBJS AS SELECT * FROM DBA_OBJECTS WHERE OBJECT_ID IS NOT NULL; SQL> UPDATE ZSJ_OBJS SET OWNER='SYS' where owner not in('SYS','SCOTT'); SQL> CREATE INDEX IND1_ZSJ_OBJS ON ZSJ_OBJS(OWNER); SQL> EXEC DBMS_STATS.GATHER_TABLE_STATS(USER,'ZSJ_OBJS',CASCADE=>TRUE,estimate_percent => 100,method_opt => 'FOR COLUMNS SIZE 254 OWNER'); SQL> SELECT COUNT(1) FROM ZSJ_OBJS; COUNT(1) ---------- 51126 SQL> select owner,count(1) from zsj_objs group by owner; OWNER COUNT(1) ------------------------------ ---------- SCOTT 6 SYS 51120 SQL> SELECT NUM_ROWS FROM USER_TABLES WHERE TABLE_NAME='ZSJ_OBJS'; NUM_ROWS ---------- 51126 SQL> SELECT COLUMN_NAME,NUM_NULLS,NUM_DISTINCT,LOW_VALUE,HIGH_VALUE,NUM_BUCKETS,HISTOGRAM FROM USER_TAB_COLUMNS WHERE TABLE_NAME='ZSJ_OBJS'; COLUMN_NAME NUM_NULLS NUM_DISTINCT NUM_BUCKETS HISTOGRAM --------------------- ---------- ------------ ----------- --------------- OWNER 0 2 2 FREQUENCY OBJECT_NAME NONE SUBOBJECT_NAME NONE OBJECT_ID NONE DATA_OBJECT_ID NONE OBJECT_TYPE NONE CREATED NONE LAST_DDL_TIME NONE TIMESTAMP NONE STATUS NONE TEMPORARY NONE GENERATED NONE SECONDARY NONE SQL> desc zsj_objs; Name Null? Type -------------------------------- -------- ------------------------ OWNER VARCHAR2(30) OBJECT_NAME VARCHAR2(128) SUBOBJECT_NAME VARCHAR2(30) OBJECT_ID NUMBER DATA_OBJECT_ID NUMBER OBJECT_TYPE VARCHAR2(19) CREATED DATE LAST_DDL_TIME DATE TIMESTAMP VARCHAR2(19) STATUS VARCHAR2(7) TEMPORARY VARCHAR2(1) GENERATED VARCHAR2(1) SECONDARY VARCHAR2(1) SQL> set autotrace on; SQL> select /*+ full(t)*/count(1) from zsj_objs t; SQL> / COUNT(1) ---------- 51126 Execution Plan ---------------------------------------------------------- Plan hash value: 4024628057 ----------------------------------------------------------------------- | Id | Operation | Name | Rows | Cost (%CPU)| Time | ----------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 1 | 160 (1)| 00:00:02 | | 1 | SORT AGGREGATE | | 1 | | | | 2 | TABLE ACCESS FULL| ZSJ_OBJS | 51126 | 160 (1)| 00:00:02 | ----------------------------------------------------------------------- Statistics ---------------------------------------------------------- 0 recursive calls 0 db block gets 707 consistent gets 1 rows processed 全表扫描的话,逻辑IO是700多. SQL> VARIABLE V_OWNER VARCHAR2(20); SQL> EXEC :V_OWNER:='SCOTT'; SQL> EXPLAIN PLAN FOR SELECT /*+ ZHAOSJ*/COUNT(STATUS) FROM ZSJ_OBJS WHERE OWNER=:V_OWNER; SQL> SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY()); PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------- Plan hash value: 4024628057 ------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | ------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 1 | 10 | 160 (1)| 00:00:02 | | 1 | SORT AGGREGATE | | 1 | 10 | | | |* 2 | TABLE ACCESS FULL| ZSJ_OBJS | 25563 | 249K| 160 (1)| 00:00:02 | ------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 2 - filter("OWNER"=:V_OWNER) SQL> set autotrace traceonly; SQL> SELECT /*+ ZHAOSJ*/COUNT(OBJECT_NAME) FROM ZSJ_OBJS WHERE OWNER=:V_OWNER; Execution Plan ---------------------------------------------------------- Plan hash value: 4024628057 ------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | ------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 1 | 71 | 160 (1)| 00:00:02 | | 1 | SORT AGGREGATE | | 1 | 71 | | | |* 2 | TABLE ACCESS FULL| ZSJ_OBJS | 25563 | 1772K| 160 (1)| 00:00:02 | ------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 2 - filter("OWNER"=:V_OWNER) Statistics ---------------------------------------------------------- 1 recursive calls 0 db block gets 3 consistent gets 1 rows processed 这里执行计划显示是全表扫描,可从执行统计信息来看,绝不可能是全表扫描 SQL> set autotrace traceonly explain SQL> SELECT /*+ ZHAOSJ*/COUNT(OBJECT_TYPE) FROM ZSJ_OBJS WHERE OWNER=:V_OWNER; Execution Plan ---------------------------------------------------------- Plan hash value: 4024628057 ------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | ------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 1 | 16 | 160 (1)| 00:00:02 | | 1 | SORT AGGREGATE | | 1 | 16 | | | |* 2 | TABLE ACCESS FULL| ZSJ_OBJS | 25563 | 399K| 160 (1)| 00:00:02 | ------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 2 - filter("OWNER"=:V_OWNER) SQL> set autotrace on; SQL> SELECT /*+ ZHAOSJ*/COUNT(OBJECT_ID) FROM ZSJ_OBJS WHERE OWNER=:V_OWNER; COUNT(OBJECT_ID) ---------------- 6 Execution Plan ---------------------------------------------------------- Plan hash value: 4024628057 ------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | ------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 1 | 18 | 160 (1)| 00:00:02 | | 1 | SORT AGGREGATE | | 1 | 18 | | | |* 2 | TABLE ACCESS FULL| ZSJ_OBJS | 25563 | 449K| 160 (1)| 00:00:02 | ------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 2 - filter("OWNER"=:V_OWNER) Statistics ---------------------------------------------------------- 1 recursive calls 0 db block gets 3 consistent gets 1 rows processed SQL> set autotrace off; SQL> select SQL_TEXT,EXECUTIONS,SQL_ID,CHILD_NUMBER,loads from v$sql where sql_text like '%ZHAOSJ%' AND SQL_TEXT NOT LIKE '%V$SQL%'; SQL_TEXT EXECUTIONS SQL_ID CHILD_NUMBER LOADS ------------------------------------------------------------------------------------------------------------------------ ---------- ------------- ------------ ---------- SELECT /*+ ZHAOSJ*/COUNT(OBJECT_TYPE) FROM ZSJ_OBJS WHERE OWNER=:V_OWNER 0 a1432puphnh6d 0 1 SELECT /*+ ZHAOSJ*/COUNT(OBJECT_ID) FROM ZSJ_OBJS WHERE OWNER=:V_OWNER 1 a4dg408bk4s1v 0 1 EXPLAIN PLAN SET STATEMENT_ID='PLUS649103' FOR SELECT /*+ ZHAOSJ*/COUNT(OBJECT_ID) FROM ZSJ_OBJS WHERE OWNER=:V_OWNER 1 g7xfu0r9cct97 0 1 EXPLAIN PLAN FOR SELECT /*+ ZHAOSJ*/COUNT(STATUS) FROM ZSJ_OBJS WHERE OWNER=:V_OWNER 1 bvu9dgfv4dknm 0 1 SELECT /*+ ZHAOSJ*/COUNT(OBJECT_NAME) FROM ZSJ_OBJS WHERE OWNER=:V_OWNER 1 9pp0np349u3m8 0 1 EXPLAIN PLAN SET STATEMENT_ID='PLUS649103' FOR SELECT /*+ ZHAOSJ*/COUNT(OBJECT_TYPE) FROM ZSJ_OBJS WHERE OWNER=:V_OWNER 1 8zcy0xb6pv9a3 0 1 EXPLAIN PLAN SET STATEMENT_ID='PLUS649103' FOR SELECT /*+ ZHAOSJ*/COUNT(OBJECT_NAME) FROM ZSJ_OBJS WHERE OWNER=:V_OWNER 1 0j7shnwq4vn9s 0 1 7 rows selected. SQL> SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY_CURSOR('9pp0np349u3m8',0,'ADVANCED')); PLAN_TABLE_OUTPUT ------------------------------------------------------------------------------------------------ SQL_ID 9pp0np349u3m8, child number 0 ------------------------------------- SELECT /*+ ZHAOSJ*/COUNT(OBJECT_NAME) FROM ZSJ_OBJS WHERE OWNER=:V_OWNER Plan hash value: 3778349780 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | | | 2 (100)| | | 1 | SORT AGGREGATE | | 1 | 71 | | | | 2 | TABLE ACCESS BY INDEX ROWID| ZSJ_OBJS | 6 | 426 | 2 (0)| 00:00:01 | |* 3 | INDEX RANGE SCAN | IND1_ZSJ_OBJS | 6 | | 1 (0)| 00:00:01 | ---------------------------------------------------------------------------------------------- Peeked Binds (identified by position): -------------------------------------- 1 - :V_OWNER (VARCHAR2(30), CSID=852): 'SCOTT' Predicate Information (identified by operation id): --------------------------------------------------- 3 - access("OWNER"=:V_OWNER) SQL> SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY_CURSOR('a1432puphnh6d',0,'ADVANCED')); PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------- SQL_ID a1432puphnh6d, child number 0 ------------------------------------- SELECT /*+ ZHAOSJ*/COUNT(OBJECT_TYPE) FROM ZSJ_OBJS WHERE OWNER=:V_OWNER Plan hash value: 4024628057 ------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | ------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | | | 160 (100)| | | 1 | SORT AGGREGATE | | 1 | 16 | | | |* 2 | TABLE ACCESS FULL| ZSJ_OBJS | 25563 | 399K| 160 (1)| 00:00:02 | ------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 2 - filter("OWNER"=:V_OWNER) SQL> SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY_CURSOR('a4dg408bk4s1v',0,'ADVANCED')); PLAN_TABLE_OUTPUT ----------------------------------------------------------------------------------------------- SQL_ID a4dg408bk4s1v, child number 0 ------------------------------------- SELECT /*+ ZHAOSJ*/COUNT(OBJECT_ID) FROM ZSJ_OBJS WHERE OWNER=:V_OWNER Plan hash value: 3778349780 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | | | 2 (100)| | | 1 | SORT AGGREGATE | | 1 | 18 | | | | 2 | TABLE ACCESS BY INDEX ROWID| ZSJ_OBJS | 6 | 108 | 2 (0)| 00:00:01 | |* 3 | INDEX RANGE SCAN | IND1_ZSJ_OBJS | 6 | | 1 (0)| 00:00:01 | ---------------------------------------------------------------------------------------------- Peeked Binds (identified by position): -------------------------------------- 1 - :V_OWNER (VARCHAR2(30), CSID=852): 'SCOTT' Predicate Information (identified by operation id): --------------------------------------------------- 3 - access("OWNER"=:V_OWNER) explain plan时都不使用绑定变量peeking机制,无论是显式执行的,还是隐式执行的 SQL> set autotrace traceonly; SQL> SELECT /*+ ZHAOSJ*/COUNT(OBJECT_NAME) FROM ZSJ_OBJS WHERE OWNER=:V_OWNER; 实际执行了一次,使用绑定变量peeking机制,但这里也执行了一次explain plan,实际上显示的执行计划是这次explain plan对应的执行计划 SQL> set autotrace traceonly explain SQL> SELECT /*+ ZHAOSJ*/COUNT(OBJECT_TYPE) FROM ZSJ_OBJS WHERE OWNER=:V_OWNER; 实际上并不执行,但硬分析了一次,也不使用绑定变量peeking机制,这里也执行了一次explain plan,实际上显示的执行计划是这次explain plan对应的执行计划还是硬分析时的执行计划呢?这个不好确定,因为它们是一样的,都不使用绑定变量peeking机制. SQL> set autotrace on; SQL> SELECT /*+ ZHAOSJ*/COUNT(OBJECT_ID) FROM ZSJ_OBJS WHERE OWNER=:V_OWNER; 实际执行了一次,使用绑定变量peeking机制,这里也执行了一次explain plan,实际上显示的执行计划是这次explain plan对应的执行计划. SQL> CREATE TABL</p></div><br /><hr><link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/bootstrap/5.2.1/css/bootstrap.min.css" integrity="sha512-siwe/oXMhSjGCwLn+scraPOWrJxHlUgMBMZXdPe2Tnk3I0x3ESCoLz7WZ5NTH6SZrywMY+PB1cjyqJ5jAluCOg==" crossorigin="anonymous" referrerpolicy="no-referrer" /> <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-icons/1.9.1/font/bootstrap-icons.min.css" integrity="sha512-5PV92qsds/16vyYIJo3T/As4m2d8b6oWYfoqV+vtizRB6KhF1F9kYzWzQmsO6T3z3QG2Xdhrx7FQ+5R1LiQdUA==" crossorigin="anonymous" referrerpolicy="no-referrer" /> <script src="https://challenges.cloudflare.com/turnstile/v0/api.js?onload=_turnstileCb" defer></script> <br /> <main class="form-signin" style="width: 350px;"> <form method="POST" action="?t=1784366050_6634"> <p>你的当前访问异常,请进行认证后继续阅读剩余内容。</p> <div class="checkbox mb-3"> <!-- The Turnstile widget will be injected in the following div. --> <div id="myWidget"></div> <!-- end. --> </div> <button class="w-100 btn btn-lg btn-primary" type="submit">提交</button> </form> </main> <script> // This function is called when the Turnstile script is loaded and ready to be used. // The function name matches the "onload=..." parameter. function _turnstileCb() { turnstile.render("#myWidget", { sitekey: "0x4AAAAAAAjsuGjmm5ZcGWaB", theme: "light", }); } </script> </span></article> <div class="pcuptime"> <div class="fl"> <div class="fl"> <div class="glyphicon glyphicon-share-alt fl"></div> <div class="fl">分享到：</div> <div onclick="shareTo('qzone')" class="fl" style="cursor: pointer;"> <img width="30" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAC4UlEQVRYhaVXvU7rMBT2C1Ax06UL4G4szQPcPAC9+y0vEB6gLI4lfsrAEJQygHRpk4UBXWDIgFQimgXRLu1id2QpMy0vcO5Aa5omTmx6pG9pbX+fPx+f4yCkEduE7WKbtbDNn8s2G5RtDl9gA2zzZ2yz1jZhuzpr5gamoxK2Watss49vwjywD2yzVom+ra9GTka2HnGKEDKytYlL9G09bvGqYANlNzYp21lt13I3NinbUdm5Mrl3U4Omb2mJkDqha7tx9ArTqADTqKB9HKkCMGFUZ6GmbwG8IIAXBAdXx1oiMGE0Tk5HJd1z/4zWhIBxWNTOh9hRYMLbOgscXB0L8jn2ztuaLvC2EKC7+/dwIyGgFxjaLiCEENqivKozcf/CTZDPYZ52tERsUV7NtN887UDN8eDk7wG4vgWdBxPGYVEqYBwWoRcY4PoWuL4FVtOFmuPJhRHuIEx4d/mP0SPOJOkHlVTwjHmf0VpaHnRR2t1fTjL+iKHzYIqdzVFzPKg5HlQOe2Ju5bAHvcBIkP8++5eWBwOkk+lpmEYFUQeqZ3cJF+TkX5AKUBExDoti8frlCUyjQmJMXpFCmLDhT0T0AgOMo1co2xy8m73UMXnkmLBhahLmiXBnDchsPEkTz7upqRSjrnIV7AcVmEYF2L9wxW+N67q4AYv2Kzcowh3lQgQvCDoPpsh8GeqXJ+D6Fvw5u1MrRLNeMMkaaBy9Kt0Ind6ACZ8oN6O987a2gMWjkgj4bkYl+rae5ULjup5K8nT/K/YuWETWSwkTPkm8jLIeJMsk7+FGzGLztAP9oBIbc39bzbp+8QfJgojUmjBf/DNag8Z1Xbrw/oUrWnU/qMjvvixkR/EebsD9bVUUnryEbfqWrPkkrV+OTcp28m6FCpbFYsInuc/yuBPZJVoHmLDhjz7TMGF0FTcw4RNpwqnGLC/aOkK+iHl75Y/T5diivDoT0108IkzYEBPeLRPuiPKqGP8BN+Q4QC3Ugd4AAAAASUVORK5CYII="/> </div> <div onclick="shareTo('qq')" class="fl" style="cursor: pointer;margin-left:3px;"> <img width="32" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAEIElEQVRYhbVX3W/TVhzNPxC3BaGWIlaDUtrEZku3gLqqHw/9YAlZk2bVJlY6UfoQJPbRZg/tQGsjVjRgWtQhUVIKS5ZtRE18k0GCtFZjZCpiQpNo4QFeqqGyN9uauycmrdHZQ8HETWo7i3alI1m27z3nnt/9/e69BkMRzZIQXQzhQywn3GI4fpElAlgigOH4RZYTbjGED1kSoquYMTVbfVKiGcKHWCJIzwl1QGIIH6KTUnlJ5CwRxoskzhPCEmG8aGI6KZXnWlwqGI5f1O0Gk+StJc5687AkeavmzPWSmyPLMJ1Ow3Q6jbrgPd0iNnVCr+11wXuosg+AoowKbGX3Y/eJ73WFo6AAlgh+rc61gQzKqnbkkediZ/9JPU74FeT1SYnWst4cWUbFbrNM1ObpK/hMUUY9TihDwXB8WEv1S96zMsHY1wRP+D8RSNyEy+sDAMw//EP+vm1fh55QhHPt11x42/a1ywR3V0T0DJ/CyHQco9OzsDrfBQCFC+bIsqYLBoPBYDBzolvPCs4dPJC4icTCbxidnoXL+3GeAxRlhGkipZ1JnOjWZf9GARRlxNDnn8LR2wxHbzM+OjUE+9sHihbAcOKkgSVCRutH55k5bK2pBUUZcf68B2LaUhB3SJcsoHHkGz3ZkDHoyf3PDg5gtKEFW+g9aO58DVzIjZ/Dnbg248S1GSeiF3oQu9SDQ4Od6+StLlxqaNFXEzTjFFnG2aaDiNeYcLF2L5qbHCiv3I5Dg5344txhjIz04ZPxt7CF3gOLrQMnmpyI15gQqXtZz0KEpoCd/SexvWoH/I1diNeYZETqrThua8dxWzsm976u+PZVQytMdB2q3jiiLYAh/JLaDxW76kFRRnR7fZh5f0xBtBGhVgfSwSi6vT5d6cgQfkl1EdYGMvJAbw4cQ/jDFwJ+ubGgwFNJwlo2i7VsViFAIxsyqmlomkiBoowoq6wGRRkRPPCOLOA5WSG0efrkPvTwlHoaahWiil31ME2kUFZZjVjsRwTfG8JFz+Cm5Ct/PZVnXlZZrbpVmznRvV6KOWFVLQtYIoAenkK316c687VsFuPfplHt+UC7BnDCalGbUUfiAXp9RxGdX9iUPHb3EV6x23E4Ma+nBrzYjOikVK7mgn32VzxO7YeYtmDuShNGLwTw06MnkP7+B2vZLO485vFlPI7JM11yVTwS+0F19nknI1blQNIYuY+r3x3FSsomE6ykbBgLjaE/cA4Pr7cqSvIsOYaW6AM1B5QHEjkUGjWh7fJtdE3NwXFlDo2R+/L7V6O/y+/bLt9Wt57wSwXJ9YSiZBSyPs+FJG/9X0RwwqrmsTzXCa1wFAOG8Ev/6ZrGEsFfkhvrff1FE+e5wfHhooRwwirD8eGSL6cbm5kT3c+KViY3RM+eMwwnTsrlVWf7F9K7alkbFZHSAAAAAElFTkSuQmCC"/> </div> <div onclick="shareTo('sina')" class="fl" style="cursor: pointer;"> <img width="36" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAC8klEQVRYhe1XMW+qUBT2p/Qn9Cd05NypiyN5THRhqJNpHN6LSdc+V12LY1tHE4eaLi4mfTLIZMpsoNACYoX6vUElXMCi1u29k5zEyOV+3/nOd7hQKv2PPcJm7NRi7KdJ9Ggx9mwxhnU+m0SPFtFvm7HTowObROcW0UsC8OskejEF4ce3gW1BOFlXuxtwKk2ix4MVWcttHwqeSNsWhLNDwL8LzOXOJGxBODlS5VkldmmHSdQ/FGQxGAAAoskEwcMDbElKr3kuAj//TpXezQ1m7TYWgwGWnoel6+K9XueNyZi0lYDFmFHYS0nCvNdDOBphpqqZ62/VKmxJwmu5jGgywdJ1eSWIXvJ7v4PxZu020uEoSnzdURREkwkAYNZuw5ak+DdXRJ4XLMZ+bQPeVJMXjqLgvV7HTFUxU1XYkgRHUQAgvi/UNH5PosbO5vsKfOm6uf9ZjAEA3qpVhJqWIWAS9fMU+LMPOHwfy+k0S8DzYDEGv9mExRhCTcNiMEgrkPVBXvVBp8NvPp0iaLXgXlzAFcU4/VoN4dMTACAcjThf5IwiLMZQSGBjoE183N3BFUXMVXVVue8jHA7h12oxkaDViteHoxFey+Wthi5sQdLx4XAIVxSx6HY5NTat8CqVmESyLZs2ZJLIKTRhqGnxRrPra3iVCgAgGo+x6HYxv73Fp2EAAOaqGhOIxuP4vnmvl0sg34REjeQiv9nkCPi1GgDAlWW4ssy1J2i14IoivMtL3qfbFciOYfpB9FouY+l5XAsiXcenYXAyR7q+ql6WY0U207DNA1tPxvSj2FEUjoR3dYWP+3tEuo5I11eVyzKCZhPwfQ48OQmpNHLBS6VSyWRMypuGpB8+DQPReBxnOkJN2zp6VtFhlGfGpBpBp8ORSYIGnc5XVRdXz3mByCnYaP8kcnZ+P7QF4ezYBEyi853AORLHUILI2Rs8JrEazcwhtUcaR/lQWU9H4dtSErjQ7YfE2qANk6jPtWclc98iauz9DfDPx18dyRjOU+tVPwAAAABJRU5ErkJggg=="/> </div> <div onclick="shareTo('wechat')" class="fl" style="cursor:pointer;margin-left:1px;"> <img width="32" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAB1UlEQVRYhcWXzY2DQAyFvxJSAiWkg00HSwfJYQtIB6EEOoAO0Mwo56QD6GC3g9BB9jBD+FkYM0C0liwhMeDn94xtIMQMMZoMzQ1FieaJ5umub+7eZ9A7RSuI0GQoHq+AktuzGQXRmsA7DJegwGNADBcKduHBuxSvdUU5H8SV/aqsfWxc2c/JfPvgXRCTTGxNe7AciuTtwVsQyTD7aCb1P2juL1fU20ihyIWH7hgOo9JpTg5YKIi8C2A6k95BT/FqqmAWgKa9Tmc+12wRh0liiP30G+IOS2mLGtsv7LlzR45zIAsprqDGD3TNENsHehmnGL5Q5M4Tl9Dcmrjj1U4yG+w8es9wEIEoSmSNJoMnaE5egHPqQqDo5gGQ9q6b5mJ7Stvt7GfqBSB9PtkEvW32BVFv9g97xvS7K38Rtt6n2nDwyjM0bxHKXfDpMs5QfNOsXl0JfObrM4pcakS+Cn6IK5c0YV8sLh8q5eSSIQVX1O3hOTJIhao4ovlAcXR7YCSAz7too8Us+CSaGvGK+u9S8q8LSaNZ6Ehd5pVUtdtKIVI/NLuWbw9CUctr+fvkqJb+HSWr2FDU4wUXBiRyy8Z8IDZwHp61ZHYryrEDrOpRbNf0PGhIAb/sAH9daKVzgAAAAABJRU5ErkJggg=="/> </div> </div> </div> <time class="fr glyphicon glyphicon-exclamation-sign">非常感谢你花费了<span id="lookDate"></span>来阅读本文,如果你在本站获取到了新知识,那就请点击分享按钮将本站分享出去吧。 </time> </div> </div> </div> </div> <script> $('.pcdetails img').each(function () { if ($(this).width() >= 100) { $(this).addClass('img-responsive center-block'); } }); </script> </div> </div> <div style="text-align:center;"> <script async="async" data-cfasync="false" src="https://pl28992228.profitablecpmratenetwork.com/8ae604bdc4dc964f8674244fb58731a2/invoke.js"></script> <div id="container-8ae604bdc4dc964f8674244fb58731a2"></div> <script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script> <!-- 底部 --> <ins class="adsbygoogle" style="display:block" data-ad-client="ca-pub-8678003482554321" data-ad-slot="4478728495" data-ad-format="auto" data-full-width-responsive="true"></ins> <script> (adsbygoogle = window.adsbygoogle || []).push({}); </script> </div> </div> <div class="random"> <div class="container"> <div class="row"> <div class="col-lg-4 col-md-4 col-sm-6 col-xs-12"> <div class="rcon"> <div class="rdp"><i class="glyphicon glyphicon-heart"></i>你可能喜欢:</div> <span><div><a href="/posts/ying-gai-zai-shen-me-shi-hou-shi-yong-Hadoop.html">应该在什么时候使用Hadoop？</a></div><div><a href="/posts/ru-he-jiang-CStringlei-xing-zhuan-huan-cheng-unsigned-char-lei-xing.html">如何将CString类型转换成unsigned char *类型</a></div><div><a href="/posts/Jquerymei-you-zai-firefoxzhong-jian-suo-bian-kuang-ban-jing.html">Jquery没有在firefox中检索边框半径</a></div><div><a href="/posts/ru-he-jiang-ri-zhi-shu-chu-cong-logcatzhong-ding-xiang-dao-androidshe-bei-shang-de-sdka.html">如何将日志输出从logcat重定向到android设备上的sd卡?</a></div><div><a href="/posts/ru-he-jiang-xiang-bao-cun-dao-te-ding-shu-zu-suo-yin-de-ci-shu-fan-hui.html">如何将项保存到特定数组索引的次数返回?</a></div><div><a href="/posts/xiao-di-chu-xue-zhe-yu-dao-nan-ti-qing-gao-shou-jin-lai.html">小弟初学者，遇到难题，请高手进来~！！！！！</a></div><div><a href="/posts/ru-he-jie-jue-wu-xiu-gai-etc-passwd-de-rootgen-mu-lu-dao-zhi-wu-fa-jin-ru-rootgen-mu-lu-de-wen-ti.html">如何解决误修改/etc/passwd 的root根目录，导致无法进入root根目录的问题</a></div><div><a href="/posts/ru-he-jie-jue-zha-xun-dui-xiang-cuo-wu-ValueError-wu-fa-zha-xun-mayur-bi-xu-shi-User-shi-li.html">如何解决查询对象错误 - ValueError：无法查询“mayur”：必须是“User”实例</a></div><div><a href="/posts/window-returnValuede-yong-fa-ru-guo-ni-de-bu-zhi-chi-opener-guo-duan-shi-yong-zhe-ge-ba.html">window.returnValue的用法！如果你的不支持opener，果断使用这个吧</a></div><div><a href="/posts/ru-he-li-xian-an-zhuang-androidde-sdk.html">如何离线安装android的sdk</a></div></span> </div> </div> <div class="col-lg-4 col-md-4 col-sm-6 col-xs-12"> <div class="rcon"> <div class="rdp"><i class="glyphicon glyphicon-duplicate"></i>相关阅读:</div> <span><div><a href="/posts/shi-yong-lie-biao-ti-he-xing-biao-ti-ying-she-zhi.html">使用列标题和行标题映射值</a></div><div><a href="/posts/javaru-men-6-tiao-jian-pan-duan-yu-ju.html">JAVA入门-6：条件判断语句</a></div><div><a href="/posts/Pythonmian-xiang-dui-xiang-zhi-wei-he-yao-yong-lei.html">Python面向对象之为何要用类</a></div><div><a href="/posts/an-zhuang-Xcodecha-jian-bao-guan-li-qi-Alcatrazbao-cuo-jie-jue-ban-fa.html">安装Xcode插件包管理器Alcatraz报错解决办法</a></div><div><a href="/posts/jin-zhi-hua-dong-de-ViewPager.html">禁止滑动的ViewPager</a></div><div><a href="/posts/huo-shan-yin-qing-bytehouse-fen-xi-xing-shu-ju-ku-ru-he-she-ji-lie-shi-cun-chu.html">火山引擎ByteHouse：分析型数据库如何设计列式存储</a></div><div><a href="/posts/00-zhi-ding-he-ji-da-qian-duan.html">00.【置顶】【合集 】大前端</a></div><div><a href="/posts/javaxiang-mu-kai-fa-jing-yan-zong-jie.html">java项目开发经验总结</a></div><div><a href="/posts/Androidzhuo-mian-kuai-jie-fang-shi-na-xie-shi-yu-na-xie-keng.html">Android桌面快捷方式那些事与那些坑</a></div><div><a href="/posts/Unity5-Assetbundlejian-dan-shi-yong-ji-da-bao-Materialwen-jian-chao-da-de-wen-ti.html">Unity5 Assetbundle简单使用 及 打包Material文件超大的问题</a></div></span> </div> </div> <div class="col-lg-4 col-md-4 col-sm-6 col-xs-12"> <div class="rcon"> <div class="rdp"><i class="glyphicon glyphicon-random"></i>随便看看:</div> <span><div><a href="/posts/JavaScriptxiu-gai-liu-lan-qi-tabbiao-ti-xiao-ji-qiao.html">JavaScript修改浏览器tab标题小技巧</a></div><div><a href="/posts/zhi-ding-jia-gou-she-ji-xi-tong-jian-tong-xin-37-Apache-Camelkuai-su-ru-men-zhong.html">[置顶] 架构设计：系统间通信（37）——Apache Camel快速入门（中）</a></div><div><a href="/posts/huan-cun-zhong-chang-jian-de-yi-xie-wen-ti.html">缓存中常见的一些问题</a></div><div><a href="/posts/cockroachshi-liang-ji-suan.html">cockroach矢量计算</a></div><div><a href="/posts/bo-chang-lian-tong-guo-tron-js-sdk-tronwebfa-song-dai-bei-zhu-de-trc-20-zhuan-zhang-ji-shi-yong-jian-jie.html">波场链通过Tron JS SDK TronWeb发送带备注的TRC - 20 转账及使用简介</a></div><div><a href="/posts/yun-ji-suan-fu-zai-jun-heng-slbfang-an-quan-jie-yu-shi-zhan.html">云计算 - 负载均衡SLB方案全解与实战</a></div><div><a href="/posts/00-00ji-suan-ji-wang-luo-zhi-ji-suan-ji-wang-luo-ji-ben-gai-nian.html">00 00计算机网络之计算机网络基本概念</a></div><div><a href="/posts/excelri-qi-han-shu-pian-2.html">excel日期函数篇2</a></div><div><a href="/posts/14-00mian-shi-15-00jiu-chu-lai-le-wen-de-wen-ti-guo-yu-bian-tai-le.html">14：00面试，15：00就出来了，问的问题过于变态了。。。</a></div><div><a href="/posts/Mavenxu-gai-cang-ku-di-zhi-wei-e-li-yun-xiu-gai-ben-di-cang-ku-di-zhi.html">Maven需改仓库地址为阿里云&修改本地仓库地址</a></div></span> </div> </div> </div> </div> </div> <section class="rightnav"> <div class="rnlist" style="display:none;"> <div class="rimg"><img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAMgAAADICAMAAACahl6sAAAAn1BMVEUAAADndGvmcm3mcm3ncW3mcm3mcm3mcm3ncm3mcm3ncm7mcm3ncm3mcm3mcmzncm3mcm3mcm3ncm3ncm3mcm3mcm3mcm3ncm3ncm3mcmzmcm3mcG3mcm3ncm3mcm3oc2zncm3ncm3mcm3ncm3mcm3ncm3ncm3ncW3mcm3mcm3mcm3mcm3mcm3ncmzmcm3ncW3mcm3mcW3ncmzncm3mcm2BuVw1AAAANHRSTlMACPdpvuXwgRJ8PDKfdyf01eAslnJORrerOMQOm7BeF+qnkNzQi8gjzMFthmJZQBykUx9VoEk3cQAACftJREFUeNrdnWm3mjAQhieAgogLgogLct2tV+uW///b2p6uk4BgEiT2+djTewQymfdNMkmgInbD0J55sWWt/AalDX9lWbHn2eGwC29C6s7ty/aD5vKxXdhH9ww6M5gvJwYtxzY4DkBHuifmJYoxJsu5ZpHmbtZUkPXGBU0Yt75QKb60xlA7XTPpUWl6iVlrjJFoYVBFGIuIQD2kpkWVYpkpvJ5zOKHKmYQ3eC27zpZWwr7zys7Sba1pZfTtVwklMZu0FA2/b1kLL7DtwLtYVt9v0FI0QwIvYJjQInzLa53GKXCk41NrZvm0iNEdqmYaGI+zqGVHDhTgRLZVkLc9B6pketg/kjVrcy+ddW7XT+tRiK7DCl9lMHnQFPHJefq7XC/GgwQ2hmqYtj5y3yI5dAXzuBnntkvTrqRR2l6ujNluRabzUkGjtH2aTeKCNGPPyMngEaiFdLI14CNQ9Etfg5wfaE2V9vJZ9vdafgVluJvsNvfaVYeVsTyDUtKlkfm5XFDEcUUzmFXRETPl1jdBCYesrGvNoRJOo6w83AEFtHqUw7dvUBHnVlb720RaBT8pj/cVKuRrlmAtU5CCxBkNPYSKuWaIfSKVhrsXyhF/hcpx44zfbUvE1TajjQm8ALKkHP1UuN/x7dE34UUc13yb7ETHUHygyoSVfHh5Ym2y5DWQwAshAf8mQvpBWT4JvJaWwT2CgJ6zOtjrwMsJOVPx9EMcP1g/fYAaMH1WxEx4ijbXHleoBZd9EMOFJxhYbNo9QU1c9+zA+hlhTNj2GENtdNkgH0FpOuzQZg41cmftcKt0aza4DlYrR+Z5PkrGeZuZnTE6UDOHnkg3mXoUY0PtsLHuTQUUfUmgfj6f7yYDg8kROrwHwIIJ90FhYMVcOGoBq2xxUXAduAShCUMmdR0KXnyvXUfP6fD7wTNjkIsD2kBmTBJ62H5N/NYa1IggfSs7meMk+L/OQSvu2HUl+eFiUkQAmmFThJmbenFgNaagGcTHETMtp+kmaMexlL7v8EzSQg9Jx3h4CXtXIlE3ItAQd1U8FXHeMhMvWoLDf3sGnhB7LM3KP39zHhUZFYIbTTMJ+cuQ/suKFGjIF428CYaMHqdWx2KaTFtwCrYcwJywydK4dN3BlusEGGwta59uKD9kmgGii8S/r2nKytIJHz+rqetwqli5zfw5Ul+TcXoe3T5y86jMqKe1fWfZcPPS2cJ/Bc2J8jwwQRltq904hMNC4k3+yv472MX87j7Mjjmqde79yRlNh27gNyiyRvAGxCi2/qQzlLNCeAPMzIngOZokHYBSSGh9x05BKTs06DhmTS8moJSh9cv1HEEplyzhm2RlZdWry4ZadTogwchaEYlAIdG6qhVVl/5Lm+8iK0flr6F02FfZJmSNjCPfRRagjkFCEXuVrT3jByV9geQrVrf2ZQwq4OOoAd9JkYq4oIppQDkSdbm9zbkRF8UxUbkQy7PYgSq2KEWx0w6xWl/HM0uVdRK2t9uVDHJzt/gtSRVfasNqpCr9PfkUo/5b3VEksbH2FZQwXNN8OhX09j3AFC3M3ZQLIU/zACpw/g3epoNfbKVGCEc0A+VmZY9NylX5oIpMKINRSUFejCdMQk7q5X+AIeg22Dbpqp4UCrFudaoQwpkD1z5rVlzFo8RPCBQv73QyxXzOtslooHbJJ8DrpEP1Qjhqo39XaFa+opo6HNGRciHcfs1rqVmqUkhiQKlyrFoI+3/b2FZtVrqo4fGAXTJw3ckDxSBLxWbljFahYY2EXa0Q9pCGpzO1ZsVBRRCAJogckOB2oY9rQXcLpWaFGMiToLxIlI4IN/wgXqlZ+UCD3d6/X0i1ELKMLYqQm1nx/41i/CKKhZAn2lJ2ZkXRizChpVYIeVSZFT60mM6uWgh5ss2KfGdXk36HfV4IM1BnVvj0ywiieiHk6Ri8WZEXRMaiKBdCnmyzIm9R5E3jbVEghCxkQxk+5U2jvI13eCEkRX/CmxV5G+/JDqw2vBCWcTPyZiXCL7KR/DCtUkJYbFaOkkNd2cmHQzkhLDYrq7vk5MNdajpo3igphOrNCk5Td2aCTl4Ixf/2iys1QcdPmaoXwmzmPheVElOmMpPY7XJCWJFZaWOHArAQXVbYFQhhMaHBHeogsaxgC0qsMysrhOrNCr/Qwy29SYwIYwHHFFCGUHDpTXwx1P3gAlyFv+mPhRdDz4bQ8vSMfQJHzRrEUnh5GlZCTbsVEsJiszISLhiAQKiEA0dWrw2ipFgYfZGI8Pjy/5Uj8iJGBOLgZaCRUFGNRJnTLFMI5Uf8HaEyJ4nCs6HChS7X+BtZTkktRX5TqhRwgxKNHMMe6msipYB8AhhAOcivowiNEATh90AmO7HiTMly2cFi3ewHY1BC17TnbbH9ScbgfQuYF2ggkzN/sAPtySspH77Tfp6MIv/33XYxytl2AS3mDTWH2QjzvluTPvMrdBLkt/S8PCdn433yvtv3Qmb7Xv6GyrXWGThlNlT+n1tcmUTQ0PG8h+yN99H/ug38v9mYD8R/x6MSfFJ4eIWmies8KpzPu+3fYX9oC6+p3P7nA16YbeL0omMKntEyJyHY2h+CNC9XSzjt6X4s1arcsVQQUr37e6vsEkQ60vRsw58MsdSNUsjl3tPytMnMMyd79ydWkDyNugkJnjkhr71mlze1genA64JoCbU9AtR/brHRSfQ8lLU7ouwhjQWM6Vsckzt+fu17o8ObfArsD3Au+h8lvUihBOMt04y1n8thNsXu5Tt9MKnrCDXCF4U156Llfatak/CwLxzrZEQxzS7UBreJcUKgNO0JxeyvUBND7lHcJxeMMb0IasFtUowRSW6jaJhQA8cVlU2hHbmb49TdlyftYm25m+OU3ZcnbzM8/a5/ioUeIPV0u5DrcgMhdrFeV6SJHw/j9P+PS+sA2rE+1wgmY5BgmuhyseNkKntFLOW5vP6qzeAmHa2fVIPLTzcOyNNp1n0drdEiakLWoBkszqCc9EIzMExlUduo88rmjwiU0fZecIn20qdZLFxQyLT1Uc+15k07BbW4jRoumufD6k2v/l+MoQo6Bs1jcpwKxuzconkYld22OpjQXIz45Dz9FtcL/jYvu7NpetjTfHrW5l5a8W/XT6tJ81mHDlTJNDDoIwzLjgqfwIlsy6AP8RyommFCi/Atr3Uap8CRjk+tmeXTIkZ3eAHEbNJSNPy+ZS28wLYD72JZfb9BS9EMCbyGbmtNK6NvD+B17DpbWgn7ThdeyzmcUOVMwhu8ntS0qFIsM4V6INHCoIowFhGBGumaSY9K00tMDS5CQKZPhC8tbS6QdDd94Wy7cUErBsdg+3SuDY56boxom7N16ZbwTE2qQ7Ih3cjcxPsmzaW5jjdm1NWhnqLU+wxDe+bFlrXyGz9c18qyYs+zw+Ggojf4BvPECQPi+ShVAAAAAElFTkSuQmCC"/> </div> <div class="rntit"> <div class="rnt1">返回</div> <div class="rnt2">顶部</div> </div> </div> </section> <footer class="copyright"> <div class="container"> <span class="glyphicon glyphicon-exclamation-sign" style="text-align: center;"> © <script type="text/javascript">document.write("" + new Date().getFullYear())</script> <a href="/">源码集中营</a> 版权所有 </span> </div> </footer> <script type="text/javascript" src="https://codejzy.com/wp-content/default/js/common.js?v=1.0"></script> <script defer src="https://cloud.umami.is/script.js" data-website-id="6bd5dff6-dd9d-49ec-85e1-57ae6d3d126a"></script> <script src="https://pl28992227.profitablecpmratenetwork.com/aa/6f/30/aa6f305e7f868e7c5211f8a5e245e7c4.js"></script> <script src="https://pl28992229.profitablecpmratenetwork.com/bd/48/64/bd4864bb0e1ed7e550d53f03af3358e0.js"></script> </body> </html>