{"id":240,"date":"2011-10-26T23:49:33","date_gmt":"2011-10-26T15:49:33","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=240"},"modified":"2011-10-27T08:56:50","modified_gmt":"2011-10-27T00:56:50","slug":"%e6%9f%a5%e8%af%a2%e6%9d%a1%e4%bb%b6%e4%b8%barownum1%e4%bb%8d%e4%ba%a7%e7%94%9f%e9%95%bf%e6%97%b6%e9%97%b4%e7%ad%89%e5%be%85","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=240","title":{"rendered":"\u67e5\u8be2\u6761\u4ef6\u4e3aROWNUM=1\u4ecd\u4ea7\u751f\u957f\u65f6\u95f4\u7b49\u5f85"},"content":{"rendered":"

\u6b63\u5e38\u60c5\u51b5\u4e0b\uff0c\u6307\u5b9a\u4e86ROWNUM=1\u4f1a\u8fc5\u901f\u7684\u8fd4\u56de\u7ed3\u679c\uff0c\u4f46\u662f\u4e5f\u6709\u5f02\u5e38\u7684\u60c5\u51b5\u4ea7\u751f\u3002
\n\u5176\u5b9eROWNUM\uff1d1\u4e4b\u6240\u4ee5\u53ef\u4ee5\u5feb\u901f\u7684\u8fd4\u56de\u7ed3\u679c\uff0c\u662f\u7531\u4e8e\u6267\u884c\u8ba1\u5212\u4e2d\u91c7\u7528\u4e86STOPKEY\u7684\u65b9\u5f0f\uff0c\u5f53\u67e5\u8be2\u5230\u7b2c\u4e00\u6761\u7b26\u5408\u8981\u6c42\u7684\u8bb0\u5f55\u540e\uff0c\u6267\u884c\u5c31\u4e2d\u6b62\u4e86\u3002
\n\u4f46\u662fROWNUM=1\u5e76\u975e\u5bf9\u6240\u6709\u60c5\u51b5\u90fd\u9002\u7528\uff0c\u6bd4\u5982\u5982\u679c\u5185\u5b58\u67e5\u8be2\u5305\u542bGROUP BY\u64cd\u4f5c\uff0c\u90a3\u4e48ROWNUM=1\u5c31\u65e0\u6cd5\u63a8\u5230GROUP BY\u67e5\u8be2\u5185\u90e8\uff0c\u56e0\u6b64\u8fd9\u65f6\u7684ROWNUM=1\u7684\u6761\u4ef6\u5bf9\u4e8e\u67e5\u8be2\u901f\u5ea6\u7684\u63d0\u9ad8\u5c31\u975e\u5e38\u6709\u9650\u4e86\u3002\u8fd8\u6709\u4e00\u79cd\u60c5\u51b5\uff0c\u5728\u6307\u5b9a\u4e86\u4e00\u4e2a\u9650\u5236\u6761\u4ef6\u540e\uff0c\u52a0\u4e0aROWNUM=1\u540e\uff0c\u53d1\u73b0\u67e5\u8be2\u6548\u7387\u4ecd\u7136\u4e0d\u9ad8\u3002\u8fd9\u65f6\u56e0\u4e3a\u8868\u4e2d\u6ee1\u8db3\u6307\u5b9a\u9650\u5236\u6761\u4ef6\u7684\u8bb0\u5f55\u975e\u5e38\u5c11\u6216\u8005\u6839\u672c\u6ca1\u6709\uff0c\u4ee5\u81f4\u4e8eOracle\u8981\u626b\u63cf\u5168\u90e8\u8868\u6570\u636e\u540e\u624d\u80fd\u8fd4\u56de\u7ed3\u679c\u3002
\n\u4f46\u662f\u5ba2\u6237\u78b0\u5230\u4e86\u7684\u73b0\u8c61\u548c\u4e0a\u9762\u63cf\u8ff0\u7684\u51e0\u79cd\u60c5\u51b5\u90fd\u4e0d\u76f8\u7b26\uff0c\u67e5\u8be2\u53ea\u662f\u4e00\u4e2a\u5355\u8868\u67e5\u8be2\uff0c\u552f\u4e00\u7684\u9650\u5236\u6761\u4ef6\u5c31\u662fROWNUM=1\uff0c\u6ca1\u6709GROUP BY\u548cORDER BY\u8bed\u53e5\uff0c\u8bed\u53e5\u5c31\u662f\u7b80\u5355\u5230\u4e0d\u80fd\u518d\u7b80\u5355\u7684\uff1aselect * from RTDRULETRACEHISTORY where rownum = 1\u3002
\n\u68c0\u67e5\u4e86\u8fd9\u4e2a\u8bed\u53e5\u7684\u6267\u884c\u8ba1\u5212\uff0c\u5e76\u672a\u53d1\u73b0\u5f02\u5e38\u4e4b\u5904\uff1a<\/p>\n

Id  Operation             Name                Rows  Bytes  Cost (%CPU) Time  \r\n0   SELECT STATEMENT                                       2 (100)   \r\n1     COUNT STOPKEY            \r\n2       TABLE ACCESS FULL RTDRULETRACEHISTORY  1    827    2 (0)       00:00:01  <\/pre>\n
\u5c1d\u8bd5\u6307\u5b9a\u7d22\u5f15\u5217\u7684\u6761\u4ef6\uff0c\u901a\u8fc7\u7d22\u5f15\u626b\u63cf\u7684\u65b9\u5f0f\u6765\u8bbf\u95ee\u8fd9\u4e2a\u8868\uff0c\u67e5\u8be2\u77ac\u95f4\u5c31\u53ef\u4ee5\u8fd4\u56de\u7ed3\u679c\u3002\u8fd9\u8bf4\u660e\u8868\u672c\u8eab\u6ca1\u6709\u95ee\u9898\u3002\u89c2\u5bdf\u67e5\u8be2\u65f6\u523b\u7684\u7b49\u5f85\u4e8b\u4ef6\uff0c\u53d1\u73b0\u7edd\u5927\u90e8\u5206\u662f\u6b63\u5e38\u7684db file scattered read\u548cgc cr multi block request\u7b49\u5f85\uff0c\u8fd9\u8bf4\u660e\u5e76\u4e0d\u662flatch\u4e4b\u7c7b\u7684\u5c06\u8d44\u6e90\u9501\u4f4f\u3002<\/p>\n
*** 2011-10-18 10:16:35.765\r\n*** ACTION NAME:() 2011-10-18 10:16:35.722\r\n*** MODULE NAME:(SQL*Plus) 2011-10-18 10:16:35.722\r\n*** SERVICE NAME:(SYS$USERS) 2011-10-18 10:16:35.722\r\n*** SESSION ID:(1500.50317) 2011-10-18 10:16:35.722\r\nWAIT #8: nam='SQL*Net message to client' ela= 9 driver id=1650815232 #bytes=1 p3=0 obj#=12803 tim=31019702733135\r\n*** 2011-10-18 10:16:46.489\r\nWAIT #8: nam='SQL*Net message from client' ela= 10471689 driver id=1650815232 #bytes=1 p3=0 obj#=12803 tim=31019713247383\r\n=====================\r\nPARSING IN CURSOR #4 len=50 dep=0 uid=33 oct=3 lid=33 tim=31019713253946 hv=3186239259 ad='964fa8b0'\r\nselect * from RTDRULETRACEHISTORY where rownum = 1\r\nEND OF STMT\r\nPARSE #4:c=10000,e=5864,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,tim=31019713253748\r\nBINDS #4:\r\nEXEC #4:c=0,e=215,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=31019713254416\r\nWAIT #4: nam='SQL*Net message to client' ela= 13 driver id=1650815232 #bytes=1 p3=0 obj#=12803 tim=31019713254581\r\nWAIT #4: nam='gc cr multi block request' ela= 2041 file#=22 block#=352168 class#=1 obj#=12803 tim=31019713257631\r\nWAIT #4: nam='db file scattered read' ela= 1195 file#=22 block#=352164 blocks=5 obj#=12803 tim=31019713259143\r\nWAIT #4: nam='gc cr multi block request' ela= 1888 file#=22 block#=352176 class#=1 obj#=12803 tim=31019713261925\r\nWAIT #4: nam='db file scattered read' ela= 1732 file#=22 block#=352169 blocks=8 obj#=12803 tim=31019713264136\r\nWAIT #4: nam='gc cr multi block request' ela= 1699 file#=22 block#=352184 class#=1 obj#=12803 tim=31019713266769\r\nWAIT #4: nam='db file scattered read' ela= 764 file#=22 block#=352178 blocks=7 obj#=12803 tim=31019713267883\r\nWAIT #4: nam='gc cr multi block request' ela= 1357 file#=22 block#=352192 class#=1 obj#=12803 tim=31019713270308\r\nWAIT #4: nam='gc cr multi block request' ela= 215 file#=22 block#=352192 class#=1 obj#=12803 tim=31019713270605\r\nWAIT #4: nam='db file scattered read' ela= 1489 file#=22 block#=352185 blocks=8 obj#=12803 tim=31019713272209\r\nWAIT #4: nam='gc cr multi block request' ela= 46 file#=22 block#=352200 class#=1 obj#=12803 tim=31019713273728\r\nWAIT #4: nam='gc cr multi block request' ela= 1897 file#=22 block#=352200 class#=1 obj#=12803 tim=31019713275710\r\nWAIT #4: nam='db file scattered read' ela= 836 file#=22 block#=352194 blocks=7 obj#=12803 tim=31019713276890\r\nWAIT #4: nam='gc cr multi block request' ela= 1555 file#=22 block#=352208 class#=1 obj#=12803 tim=31019713279226\r\nWAIT #4: nam='db file scattered read' ela= 1397 file#=22 block#=352201 blocks=8 obj#=12803 tim=31019713280861\r\nWAIT #4: nam='gc cr multi block request' ela= 2194 file#=22 block#=352216 class#=1 obj#=12803 tim=31019713284098\r\nWAIT #4: nam='db file scattered read' ela= 971 file#=22 block#=352210 blocks=7 obj#=12803 tim=31019713285421\r\nWAIT #4: nam='gc cr multi block request' ela= 1394 file#=22 block#=352224 class#=1 obj#=12803 tim=31019713287803\r\nWAIT #4: nam='gc cr multi block request' ela= 153 file#=22 block#=352222 class#=1 obj#=12803 tim=31019713288044\r\nWAIT #4: nam='db file scattered read' ela= 1206 file#=22 block#=352217 blocks=8 obj#=12803 tim=31019713289370\r\nWAIT #4: nam='gc cr multi block request' ela= 1577 file#=22 block#=352232 class#=1 obj#=12803 tim=31019713291581\r\nWAIT #4: nam='db file scattered read' ela= 1157 file#=22 block#=352226 blocks=7 obj#=12803 tim=31019713293069\r\nWAIT #4: nam='gc cr multi block request' ela= 2132 file#=22 block#=352240 class#=1 obj#=12803 tim=31019713296012\r\nWAIT #4: nam='db file scattered read' ela= 1285 file#=22 block#=352233 blocks=8 obj#=12803 tim=31019713297485\r\nWAIT #4: nam='gc cr multi block request' ela= 1575 file#=22 block#=352248 class#=1 obj#=12803 tim=31019713300039\r\nWAIT #4: nam='db file scattered read' ela= 2419 file#=22 block#=352242 blocks=7 obj#=12803 tim=31019713302788\r\nWAIT #4: nam='gc cr multi block request' ela= 31 file#=22 block#=352255 class#=1 obj#=12803 tim=31019713303561\r\nWAIT #4: nam='gc cr multi block request' ela= 1354 file#=22 block#=352255 class#=1 obj#=12803 tim=31019713305054\r\nWAIT #4: nam='db file scattered read' ela= 1346 file#=22 block#=352249 blocks=8 obj#=12803 tim=31019713306635\r\nWAIT #4: nam='db file scattered read' ela= 740 file#=22 block#=352258 blocks=4 obj#=12803 tim=31019713308265\r\nWAIT #4: nam='db file scattered read' ela= 971 file#=22 block#=352263 blocks=2 obj#=12803 tim=31019713309864\r\nWAIT #4: nam='db file scattered read' ela= 1146 file#=23 block#=353033 blocks=7 obj#=12803 tim=31019713311595\r\nWAIT #4: nam='db file scattered read' ela= 1169 file#=23 block#=353042 blocks=7 obj#=12803 tim=31019713313700\r\nWAIT #4: nam='db file scattered read' ela= 2273 file#=23 block#=353049 blocks=8 obj#=12803 tim=31019713316548\r\nWAIT #4: nam='db file scattered read' ela= 1663 file#=24 block#=357643 blocks=16 obj#=12803 tim=31019713319295\r\nWAIT #4: nam='db file scattered read' ela= 3674 file#=24 block#=357659 blocks=16 obj#=12803 tim=31019713324249\r\nWAIT #4: nam='db file scattered read' ela= 2430 file#=24 block#=357675 blocks=16 obj#=12803 tim=31019713328180\r\nWAIT #4: nam='db file scattered read' ela= 2894 file#=24 block#=357691 blocks=16 obj#=12803 tim=31019713332267\r\nWAIT #4: nam='db file scattered read' ela= 7359 file#=24 block#=357707 blocks=16 obj#=12803 tim=31019713341148\r\nWAIT #4: nam='db file scattered read' ela= 1682 file#=24 block#=357723 blocks=8 obj#=12803 tim=31019713343705\r\nWAIT #4: nam='db file scattered read' ela= 1493 file#=24 block#=357732 blocks=16 obj#=12803 tim=31019713346356\r\nWAIT #4: nam='gc cr multi block request' ela= 47 file#=24 block#=357763 class#=1 obj#=12803 tim=31019713347548\r\nWAIT #4: nam='gc cr multi block request' ela= 1538 file#=24 block#=357763 class#=1 obj#=12803 tim=31019713349157\r\nWAIT #4: nam='gc cr multi block request' ela= 79 file#=24 block#=357763 class#=1 obj#=12803 tim=31019713349320\r\nWAIT #4: nam='gc cr multi block request' ela= 61 file#=24 block#=357763 class#=1 obj#=12803 tim=31019713349576\r\nWAIT #4: nam='gc cr multi block request' ela= 62 file#=24 block#=357763 class#=1 obj#=12803 tim=31019713349688\r\nWAIT #4: nam='db file scattered read' ela= 2292 file#=24 block#=357748 blocks=16 obj#=12803 tim=31019713352166\r\nWAIT #4: nam='gc cr multi block request' ela= 1713 file#=24 block#=357768 class#=1 obj#=12803 tim=31019713354600\r\nWAIT #4: nam='db file scattered read' ela= 942 file#=24 block#=357764 blocks=5 obj#=12803 tim=31019713355837\r\nWAIT #4: nam='db file scattered read' ela= 1830 file#=22 block#=352267 blocks=16 obj#=12803 tim=31019713358515\r\nWAIT #4: nam='db file scattered read' ela= 2326 file#=22 block#=352283 blocks=16 obj#=12803 tim=31019713362098\r\nWAIT #4: nam='db file scattered read' ela= 1546 file#=22 block#=352299 blocks=16 obj#=12803 tim=31019713364587\r\nWAIT #4: nam='db file scattered read' ela= 2004 file#=22 block#=352315 blocks=16 obj#=12803 tim=31019713367496\r\nWAIT #4: nam='db file scattered read' ela= 1926 file#=22 block#=352331 blocks=16 obj#=12803 tim=31019713370250\r\nWAIT #4: nam='db file scattered read' ela= 1750 file#=22 block#=352347 blocks=16 obj#=12803 tim=31019713373524\r\nWAIT #4: nam='db file scattered read' ela= 1375 file#=22 block#=352363 blocks=16 obj#=12803 tim=31019713375927\r\nWAIT #4: nam='gc cr multi block request' ela= 2280 file#=22 block#=352392 class#=1 obj#=12803 tim=31019713380187\r\nWAIT #4: nam='db file scattered read' ela= 6749 file#=22 block#=352379 blocks=14 obj#=12803 tim=31019713387286\r\nWAIT #4: nam='gc cr multi block request' ela= 2624 file#=23 block#=353178 class#=1 obj#=12803 tim=31019713391083\r\nWAIT #4: nam='db file scattered read' ela= 1645 file#=23 block#=353163 blocks=16 obj#=12803 tim=31019713392893\r\nWAIT #4: nam='gc cr multi block request' ela= 1470 file#=23 block#=353194 class#=1 obj#=12803 tim=31019713395432\r\nWAIT #4: nam='gc cr multi block request' ela= 498 file#=23 block#=353194 class#=1 obj#=12803 tim=31019713396168\r\nWAIT #4: nam='db file scattered read' ela= 2708 file#=23 block#=353179 blocks=16 obj#=12803 tim=31019713399190\r\nWAIT #4: nam='gc cr multi block request' ela= 70 file#=23 block#=353210 class#=1 obj#=12803 tim=31019713401176\r\nWAIT #4: nam='gc cr multi block request' ela= 2393 file#=23 block#=353210 class#=1 obj#=12803 tim=31019713403660\r\nWAIT #4: nam='db file scattered read' ela= 2962 file#=23 block#=353195 blocks=16 obj#=12803 tim=31019713406784\r\nWAIT #4: nam='gc cr multi block request' ela= 2055 file#=23 block#=353220 class#=1 obj#=12803 tim=31019713409738\r\nWAIT #4: nam='db file scattered read' ela= 1882 file#=23 block#=353211 blocks=10 obj#=12803 tim=31019713411882\r\nWAIT #4: nam='gc cr multi block request' ela= 43 file#=23 block#=353237 class#=1 obj#=12803 tim=31019713414032\r\nWAIT #4: nam='gc cr multi block request' ela= 2417 file#=23 block#=353237 class#=1 obj#=12803 tim=31019713416569\r\nWAIT #4: nam='db file scattered read' ela= 1825 file#=23 block#=353222 blocks=16 obj#=12803 tim=31019713418775\r\nWAIT #4: nam='gc cr multi block request' ela= 1917 file#=23 block#=353245 class#=1 obj#=12803 tim=31019713421691\r\nWAIT #4: nam='gc cr multi block request' ela= 90 file#=23 block#=353245 class#=1 obj#=12803 tim=31019713421908\r\nWAIT #4: nam='gc cr multi block request' ela= 62 file#=23 block#=353245 class#=1 obj#=12803 tim=31019713422020\r\nWAIT #4: nam='gc cr multi block request' ela= 84 file#=23 block#=353245 class#=1 obj#=12803 tim=31019713422253\r\nWAIT #4: nam='db file scattered read' ela= 1067 file#=23 block#=353238 blocks=8 obj#=12803 tim=31019713423663\r\nWAIT #4: nam='gc cr multi block request' ela= 41 file#=23 block#=353251 class#=1 obj#=12803 tim=31019713424512\r\nWAIT #4: nam='gc cr multi block request' ela= 1167 file#=23 block#=353251 class#=1 obj#=12803 tim=31019713425733\r\nWAIT #4: nam='gc cr multi block request' ela= 265 file#=23 block#=353251 class#=1 obj#=12803 tim=31019713426060\r\nWAIT #4: nam='db file scattered read' ela= 1041 file#=23 block#=353247 blocks=5 obj#=12803 tim=31019713427205\r\nWAIT #4: nam='gc cr multi block request' ela= 2468 file#=23 block#=353268 class#=1 obj#=12803 tim=31019713430616\r\nWAIT #4: nam='db file scattered read' ela= 1562 file#=23 block#=353253 blocks=16 obj#=12803 tim=31019713432505\r\n.\r\n.\r\n.\r\nWAIT #4: nam='db file scattered read' ela= 12261 file#=23 block#=582746 blocks=16 obj#=12803 tim=31019894112271\r\nWAIT #4: nam='db file scattered read' ela= 4545 file#=23 block#=582762 blocks=16 obj#=12803 tim=31019894118627\r\nWAIT #4: nam='gc cr multi block request' ela= 55 file#=23 block#=582792 class#=1 obj#=12803 tim=31019894119991\r\nWAIT #4: nam='gc cr multi block request' ela= 2321 file#=23 block#=582792 class#=1 obj#=12803 tim=31019894122435\r\nWAIT #4: nam='db file scattered read' ela= 35721 file#=23 block#=582778 blocks=15 obj#=12803 tim=31019894158558\r\nWAIT #4: nam='db file scattered read' ela= 2538 file#=24 block#=588562 blocks=16 obj#=12803 tim=31019894163029\r\nFETCH #4:c=73150000,e=180908720,p=532660,cr=537132,cu=0,mis=0,r=1,dep=0,og=1,tim=31019894163425\r\nWAIT #4: nam='SQL*Net message from client' ela= 2818 driver id=1650815232 #bytes=1 p3=0 obj#=12803 tim=31019894166521\r\nFETCH #4:c=0,e=54,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=31019894166683\r\nWAIT #4: nam='SQL*Net message to client' ela= 3 driver id=1650815232 #bytes=1 p3=0 obj#=12803 tim=31019894166836\r\n*** 2011-10-18 10:20:15.486\r\nWAIT #4: nam='SQL*Net message from client' ela= 23178892 driver id=1650815232 #bytes=1 p3=0 obj#=12803 tim=31019917345799\r\nSTAT #4 id=1 cnt=1 pid=0 pos=1 obj=0 op='COUNT STOPKEY (cr=537132 pr=532660 pw=0 time=180908666 us)'\r\nSTAT #4 id=2 cnt=1 pid=1 pos=1 obj=12803 op='TABLE ACCESS FULL RTDRULETRACEHISTORY (cr=537132 pr=532660 pw=0 time=180908601 us)'\r\n=====================\r\nPARSING IN CURSOR #10 len=55 dep=0 uid=33 oct=42 lid=33 tim=31019917347295 hv=2217940283 ad='0'\r\nalter session set events '10046 trace name context off'\r\nEND OF STMT\r\nPARSE #10:c=0,e=633,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,tim=31019917347273\r\nEXEC #10:c=0,e=283,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,tim=31019917347733<\/pre>\n
\u8be2\u95ee\u4e86\u4e00\u4e0b\u8fd9\u5f20\u8868\u7684\u4e1a\u52a1\u5904\u7406\u903b\u8f91\uff0c\u627e\u5230\u4e86\u6700\u7ec8\u95ee\u9898\u6240\u5728\u3002\u8fd9\u662f\u8868\u5b58\u653e\u7684\u6570\u636e\u53ea\u4f1a\u4fdd\u7559\u4e00\u6bb5\u65f6\u95f4\uff0c\u56e0\u6b64\u6bcf\u5929\u90fd\u4f1a\u6267\u884c\u5220\u9664\u64cd\u4f5c\u6765\u5220\u9664\u3002\u5927\u91cf\u5220\u9664\u7684\u64cd\u4f5c\u4f7f\u5f97\u8868\u7684\u524d\u90e8\u4ea7\u751f\u5927\u91cf\u7684\u7a7a\u5757\uff0c\u56e0\u6b64Oracle\u5373\u4f7f\u8981\u83b7\u53d6\u4e00\u6761\u6570\u636e\uff0c\u4e5f\u8981\u626b\u63cf\u8fd9\u4e9b\u7a7a\u5757\u77e5\u9053\u627e\u5230\u7b2c\u4e00\u6761\u672a\u5220\u9664\u7684\u8bb0\u5f55\u3002\u8fd9\u548c\u5373\u4f7f\u8868\u4e2d\u6ca1\u6709\u6570\u636e\uff0c\u4f46\u662f\u9ad8\u6c34\u4f4d\u7ebf\u5f88\u9ad8\uff0cCOUNT(*)\u64cd\u4f5c\u4e5f\u8981\u6267\u884c\u5f88\u957f\u65f6\u95f4\u7684\u9053\u7406\u662f\u4e00\u6837\u7684\u3002
\n\u6839\u636e\u8868\u7684\u7edf\u8ba1\u4fe1\u606f\u8ba1\u7b97\uff0c\u8868\u4e2d\u63a5\u8fd1\u4e00\u534a\u7684\u5927\u5c0f\u7684\u7a7a\u7684\uff0c\u800c\u8fd9\u4e9b\u7a7a\u884c\u51e0\u79cd\u5206\u5e03\u5728\u8868\u7684\u524d\u7aef\uff0c\u9020\u6210\u4e86\u8fd9\u4e2a\u95ee\u9898\u7684\u4ea7\u751f\uff0c\u89e3\u51b3\u95ee\u9898\u7684\u65b9\u6cd5\u5f88\u7b80\u5355\uff0c\u5bf9\u4e8e\u53ef\u4ee5\u77ed\u65f6\u95f4\u4e2d\u65ad\u4e1a\u52a1\u7684\u73af\u5883\uff0c\u53ea\u9700\u8981MOVE\u7136\u540eREBUILD\u7d22\u5f15\u65e2\u53ef\uff0c\u800c\u5bf9\u4e8e\u4e1a\u52a1\u4e0d\u80fd\u505c\u987f\u7684\u7cfb\u7edf\uff0c\u53ef\u4ee5\u4f7f\u7528SHRINK\u6765\u5728\u7ebf\u56de\u6536\u8868\u4e2d\u7684\u7a7a\u95f2\u7a7a\u95f4\uff0c\u5f53\u7136\u5982\u679c\u8868\u4e0a\u7684\u64cd\u4f5c\u6bd4\u8f83\u9891\u7e41\uff0c\u8fd8\u53ef\u4ee5\u4f7f\u7528\u5728\u7ebf\u91cd\u5b9a\u4e49\u6765\u63a5\u8fd1\u95ee\u9898\u3002
\n\u867d\u7136\u95ee\u9898\u89e3\u51b3\u4e86\uff0c\u4f46\u662f\u8981\u89c4\u907f\u8fd9\u4e2a\u95ee\u9898\u7684\u518d\u6b21\u51fa\u73b0\uff0c\u8fd8\u5fc5\u987b\u5efa\u7acb\u9002\u5408\u7684\u6570\u636e\u751f\u547d\u5468\u671f\u7ba1\u7406\u65b9\u6848\uff0c\u901a\u8fc7\u5408\u7406\u9ad8\u6548\u7684\u65b9\u5f0f\u6765\u5904\u7406\u6570\u636e\uff0c\u907f\u514d\u901a\u8fc7\u5927\u91cf\u7684DELETE\u5220\u9664\u8fc7\u671f\u6570\u636e\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u6b63\u5e38\u60c5\u51b5\u4e0b\uff0c\u6307\u5b9a\u4e86ROWNUM=1\u4f1a\u8fc5\u901f\u7684\u8fd4\u56de\u7ed3\u679c\uff0c\u4f46\u662f\u4e5f\u6709\u5f02\u5e38\u7684\u60c5\u51b5\u4ea7\u751f\u3002 \u5176\u5b9eROWNUM\uff1d1\u4e4b\u6240\u4ee5\u53ef\u4ee5\u5feb\u901f\u7684\u8fd4\u56de\u7ed3\u679c\uff0c\u662f\u7531\u4e8e\u6267\u884c\u8ba1\u5212\u4e2d\u91c7\u7528\u4e86STOPKEY\u7684\u65b9\u5f0f\uff0c\u5f53\u67e5\u8be2\u5230\u7b2c\u4e00\u6761\u7b26\u5408\u8981\u6c42\u7684\u8bb0\u5f55\u540e\uff0c\u6267\u884c\u5c31\u4e2d\u6b62\u4e86\u3002 \u4f46\u662fROWNUM=1\u5e76\u975e\u5bf9\u6240\u6709\u60c5\u51b5\u90fd\u9002\u7528\uff0c\u6bd4\u5982\u5982\u679c\u5185\u5b58\u67e5\u8be2\u5305\u542bGROUP BY\u64cd\u4f5c\uff0c\u90a3\u4e48ROWNUM=1\u5c31\u65e0\u6cd5\u63a8\u5230GROUP BY\u67e5\u8be2\u5185\u90e8\uff0c\u56e0\u6b64\u8fd9\u65f6\u7684ROWNUM=1\u7684\u6761\u4ef6\u5bf9\u4e8e\u67e5\u8be2\u901f\u5ea6\u7684\u63d0\u9ad8\u5c31\u975e\u5e38\u6709\u9650\u4e86\u3002\u8fd8\u6709\u4e00\u79cd\u60c5\u51b5\uff0c\u5728\u6307\u5b9a\u4e86\u4e00\u4e2a\u9650\u5236\u6761\u4ef6\u540e\uff0c\u52a0\u4e0aROWNUM=1\u540e\uff0c\u53d1\u73b0\u67e5\u8be2\u6548\u7387\u4ecd\u7136\u4e0d\u9ad8\u3002\u8fd9\u65f6\u56e0\u4e3a\u8868\u4e2d\u6ee1\u8db3\u6307\u5b9a\u9650\u5236\u6761\u4ef6\u7684\u8bb0\u5f55\u975e\u5e38\u5c11\u6216\u8005\u6839\u672c\u6ca1\u6709\uff0c\u4ee5\u81f4\u4e8eOracle\u8981\u626b\u63cf\u5168\u90e8\u8868\u6570\u636e\u540e\u624d\u80fd\u8fd4\u56de\u7ed3\u679c\u3002 \u4f46\u662f\u5ba2\u6237\u78b0\u5230\u4e86\u7684\u73b0\u8c61\u548c\u4e0a\u9762\u63cf\u8ff0\u7684\u51e0\u79cd\u60c5\u51b5\u90fd\u4e0d\u76f8\u7b26\uff0c\u67e5\u8be2\u53ea\u662f\u4e00\u4e2a\u5355\u8868\u67e5\u8be2\uff0c\u552f\u4e00\u7684\u9650\u5236\u6761\u4ef6\u5c31\u662fROWNUM=1\uff0c\u6ca1\u6709GROUP BY\u548cORDER BY\u8bed\u53e5\uff0c\u8bed\u53e5\u5c31\u662f\u7b80\u5355\u5230\u4e0d\u80fd\u518d\u7b80\u5355\u7684\uff1aselect * from RTDRULETRACEHISTORY where rownum = 1\u3002 \u68c0\u67e5\u4e86\u8fd9\u4e2a\u8bed\u53e5\u7684\u6267\u884c\u8ba1\u5212\uff0c\u5e76\u672a\u53d1\u73b0\u5f02\u5e38\u4e4b\u5904\uff1a Id Operation Name Rows Bytes Cost (%CPU) Time 0 SELECT STATEMENT 2 (100) 1 COUNT STOPKEY 2 TABLE ACCESS FULL RTDRULETRACEHISTORY 1 827 2 … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3],"tags":[173,174,28],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-3S","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/240"}],"collection":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=240"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/240\/revisions"}],"predecessor-version":[{"id":241,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/240\/revisions\/241"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=240"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=240"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=240"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}