{"id":1297,"date":"2014-09-04T10:32:11","date_gmt":"2014-09-04T02:32:11","guid":{"rendered":"http:\/\/www.yallonking.com\/?p=1297"},"modified":"2014-12-30T12:11:15","modified_gmt":"2014-12-30T04:11:15","slug":"%e6%ad%a3%e7%a1%ae%e5%88%86%e6%9e%90%e8%a7%a3%e8%af%bb%e6%89%a7%e8%a1%8c%e8%ae%a1%e5%88%92","status":"publish","type":"post","link":"http:\/\/www.yallonking.com\/?p=1297","title":{"rendered":"\u6b63\u786e\u5206\u6790\u89e3\u8bfb\u6267\u884c\u8ba1\u5212"},"content":{"rendered":"

\u8be5\u7bc7\u6587\u6863\u8bf4\u660e\u5982\u4f55\u6b63\u786e\u7406\u89e3\u5206\u6790sql\u8bed\u53e5\u7684\u6267\u884c\u8ba1\u5212\u3002
\n\u9996\u5148\uff0c\u6269\u5c55\u4e0b\u4e8c\u53c9\u6811\u76f8\u5173\u77e5\u8bc6\uff1a
\n\u524d\u5e8f\u904d\u5386\uff08DLR\uff09
\n \u524d\u5e8f\u904d\u5386\u4e5f\u53eb\u505a\u5148\u6839\u904d\u5386\uff0c\u53ef\u8bb0\u505a\u6839\u5de6\u53f3\u3002
\n \u524d\u5e8f\u904d\u5386\u9996\u5148\u8bbf\u95ee\u6839\u7ed3\u70b9\u7136\u540e\u904d\u5386\u5de6\u5b50\u6811\uff0c\u6700\u540e\u904d\u5386\u53f3\u5b50\u6811\u3002\u5728\u904d\u5386\u5de6\u3001\u53f3\u5b50\u6811\u65f6\uff0c\u4ecd\u7136\u5148\u8bbf\u95ee\u6839\u7ed3\u70b9\uff0c\u7136\u540e\u904d\u5386\u5de6\u5b50\u6811\uff0c\u6700\u540e\u904d\u5386\u53f3\u5b50\u6811\u3002
\n \u82e5\u4e8c\u53c9\u6811\u4e3a\u7a7a\u5219\u7ed3\u675f\u8fd4\u56de\uff0c\u5426\u5219\uff1a
\n \uff081\uff09\u8bbf\u95ee\u6839\u7ed3\u70b9
\n \uff082\uff09\u524d\u5e8f\u904d\u5386\u5de6\u5b50\u6811
\n \uff083\uff09\u524d\u5e8f\u904d\u5386\u53f3\u5b50\u6811
\n \u6ce8\u610f\u7684\u662f\uff1a\u904d\u5386\u5de6\u53f3\u5b50\u6811\u65f6\u4ecd\u7136\u91c7\u7528\u524d\u5e8f\u904d\u5386\u65b9\u6cd5\u3002<\/p>\n

\u4e2d\u5e8f\u904d\u5386\uff08LDR\uff09
\n \u4e2d\u5e8f\u904d\u5386\u4e5f\u53eb\u505a\u4e2d\u6839\u904d\u5386\uff0c\u53ef\u8bb0\u505a\u5de6\u6839\u53f3\u3002
\n \u4e2d\u5e8f\u904d\u5386\u9996\u5148\u904d\u5386\u5de6\u5b50\u6811\uff0c\u7136\u540e\u8bbf\u95ee\u6839\u7ed3\u70b9\uff0c\u6700\u540e\u904d\u5386\u53f3\u5b50\u6811\u3002\u5728\u904d\u5386\u5de6\u3001\u53f3\u5b50\u6811\u65f6\uff0c\u4ecd\u7136\u5148\u904d\u5386\u5de6\u5b50\u6811\uff0c\u518d\u8bbf\u95ee\u6839\u7ed3\u70b9\uff0c\u6700\u540e\u904d\u5386\u53f3\u5b50\u6811\u3002\u5373\uff1a
\n \u82e5\u4e8c\u53c9\u6811\u4e3a\u7a7a\u5219\u7ed3\u675f\u8fd4\u56de\uff0c\u5426\u5219\uff1a
\n \uff081\uff09\u4e2d\u5e8f\u904d\u5386\u5de6\u5b50\u6811
\n \uff082\uff09\u8bbf\u95ee\u6839\u7ed3\u70b9
\n \uff083\uff09\u4e2d\u5e8f\u904d\u5386\u53f3\u5b50\u6811\u3002
\n \u6ce8\u610f\u7684\u662f\uff1a\u904d\u5386\u5de6\u53f3\u5b50\u6811\u65f6\u4ecd\u7136\u91c7\u7528\u4e2d\u5e8f\u904d\u5386\u65b9\u6cd5\u3002<\/p>\n

\u540e\u5e8f\u904d\u5386\uff08LRD\uff09
\n \u540e\u5e8f\u904d\u5386\u4e5f\u53eb\u505a\u540e\u6839\u904d\u5386\uff0c\u53ef\u8bb0\u505a\u5de6\u53f3\u6839\u3002
\n \u540e\u5e8f\u904d\u5386\u9996\u5148\u904d\u5386\u5de6\u5b50\u6811\uff0c\u7136\u540e\u904d\u5386\u53f3\u5b50\u6811\uff0c\u6700\u540e\u8bbf\u95ee\u6839\u7ed3\u70b9\u3002\u5728\u904d\u5386\u5de6\u3001\u53f3\u5b50\u6811\u65f6\uff0c\u4ecd\u7136\u5148\u904d\u5386\u5de6\u5b50\u6811\uff0c\u518d\u904d\u5386\u53f3\u5b50\u6811\uff0c\u6700\u540e\u8bbf\u95ee\u6839\u7ed3\u70b9\u3002\u5373\uff1a
\n \u82e5\u4e8c\u53c9\u6811\u4e3a\u7a7a\u5219\u7ed3\u675f\u8fd4\u56de\uff0c\u5426\u5219\uff1a
\n \uff081\uff09\u540e\u5e8f\u904d\u5386\u5de6\u5b50\u6811\u3002
\n \uff082\uff09\u540e\u5e8f\u904d\u5386\u53f3\u5b50\u6811\u3002
\n \uff083\uff09\u8bbf\u95ee\u6839\u7ed3\u70b9\u3002
\n \u6ce8\u610f\u7684\u662f\uff1a\u904d\u5386\u5de6\u53f3\u5b50\u6811\u65f6\u4ecd\u7136\u91c7\u7528\u540e\u5e8f\u904d\u5386\u65b9\u6cd5\u3002<\/p>\n

\u5982\u4e0b\u6267\u884c\u8ba1\u5212\u5217\u51fa\u6b63\u786e\u7684\u6267\u884c\u987a\u5e8f<\/p>\n

\r\n--------------------------------------------------------------------------------------------------\r\n| Id  | Operation                      | Name    | Rows  | Bytes |TempSpc| Cost (%CPU)| Time     |\r\n--------------------------------------------------------------------------------------------------\r\n|   0 | SELECT STATEMENT               |         |  7372 |   746K|       |   298  (81)| 00:00:04 |\r\n|   1 |  MINUS                         |         |       |       |       |            |          |\r\n|   2 |   SORT UNIQUE                  |         |  7372 |   424K|   504K|   168   (2)| 00:00:03 |\r\n|   3 |    CONCATENATION               |         |       |       |       |            |          |\r\n|   4 |     TABLE ACCESS BY INDEX ROWID| A       |     1 |    59 |       |    29   (0)| 00:00:01 |\r\n|*  5 |      INDEX RANGE SCAN          | IDX_A_1 |    34 |       |       |   118   (0)| 00:00:02 |\r\n|*  6 |     TABLE ACCESS FULL          | A       |  7371 |   424K|       |    31   (4)| 00:00:01 |\r\n|   7 |   SORT UNIQUE                  |         |  5584 |   321K|   384K|   130   (3)| 00:00:02 |\r\n|   8 |    CONCATENATION               |         |       |       |       |            |          |\r\n|   9 |     TABLE ACCESS BY INDEX ROWID| B       |     1 |    59 |       |    22   (0)| 00:00:01 |\r\n|* 10 |      INDEX RANGE SCAN          | IDX_B_1 |    26 |       |       |    90   (0)| 00:00:02 |\r\n|* 11 |     TABLE ACCESS FULL          | B       |  5583 |   321K|       |    23   (0)| 00:00:01 |\r\n--------------------------------------------------------------------------------------------------\r\n<\/pre>\n
A\u300110-5-11-9-6-4-8-3-7-2-1-0
\nB\u300110-9-11-5-4-6-8-3-2-7-1-0
\nC\u30015-4-6-10-9-11-3-8-2-7-1-0
\nD\u30015-4-3-6-2-10-9-8-11-7-1-0
\nE\u3001_________________________<\/p>\n
\u4ee5\u4e0b\u4e3a\u5206\u6790\u8fc7\u7a0b
\n\u6570\u636e\u5e93\u7248\u672c<\/p>\n
\r\nsys@ora11gr2> @reg\r\n\r\nACTION_TIME          ACTION               NAMESPACE            VERSION            ID COMMENTS                       BUNDLE_SER\r\n-------------------- -------------------- -------------------- ---------- ---------- ------------------------------ ----------\r\n25-DEC-2012 13:24:04 APPLY                SERVER               11.2.0.3            4 PSU 11.2.0.3.4                 PSU\r\n\r\n1 row selected.\r\n<\/pre>\n
\u5efa\u6d4b\u8bd5\u6570\u636e<\/p>\n
\r\nsys@ora11gr2> create table a as select * from dba_segments;\r\n\r\nTable created.\r\n\r\nsys@ora11gr2> create table b as select * from dba_extents;\r\n\r\nTable created.\r\n\r\nsys@ora11gr2> insert into a select * from a;\r\n\r\n5601 rows created.\r\n\r\nsys@ora11gr2> \/\r\n\r\n11202 rows created.\r\n\r\nsys@ora11gr2> \/\r\n\r\n22404 rows created.\r\n\r\nsys@ora11gr2> \/\r\n\r\n44808 rows created.\r\n\r\nsys@ora11gr2> \/\r\n\r\n89616 rows created.\r\n\r\nsys@ora11gr2> \/\r\n\r\n179232 rows created.\r\n\r\nsys@ora11gr2> \/\r\n\r\n358464 rows created.\r\n\r\nsys@ora11gr2> commit;\r\n\r\nCommit complete.\r\n\r\nsys@ora11gr2> insert into b select * from b;\r\n\r\n8450 rows created.\r\n\r\nsys@ora11gr2> \/\r\n\r\n16900 rows created.\r\n\r\nsys@ora11gr2> \/\r\n\r\n33800 rows created.\r\n\r\nsys@ora11gr2> \/\r\n\r\n67600 rows created.\r\n\r\nsys@ora11gr2> \/\r\n\r\n135200 rows created.\r\n\r\nsys@ora11gr2> \/\r\n\r\n270400 rows created.\r\n\r\nsys@ora11gr2> commit;\r\n\r\nCommit complete.\r\n\r\nsys@ora11gr2> create index idx_a on a(SEGMENT_NAME);\r\n\r\nIndex created.\r\n\r\nsys@ora11gr2> create index idx_b on b(SEGMENT_NAME);\r\n\r\nIndex created.\r\n\r\nsys@ora11gr2> create index idx_a_1 on a(OWNER);\r\n\r\nIndex created.\r\n\r\nsys@ora11gr2> create index idx_b_1 on b(OWNER);\r\n\r\nIndex created.\r\n\r\nsys@ora11gr2> alter system flush BUFFER_CACHE;\r\n\r\nSystem altered.\r\n<\/pre>\n
\u4f7f\u752810046\u5206\u6790\u6267\u884c\u8ba1\u5212<\/p>\n
\r\nsys@ora11gr2> @10046_on\r\n\r\nSession altered.\r\n\r\n\r\nTRACE_FILE_NAME\r\n----------------------------------------------------------------------------------------------------\r\n\/u01\/app\/oracle\/diag\/rdbms\/ora11gr2\/ora11gr2\/trace\/ora11gr2_ora_2973.trc\r\n\r\n1 row selected.\r\n\r\nsys@ora11gr2> set autot traceonly\r\nsys@ora11gr2> select owner,segment_name from a where segment_name='SYS' OR owner='SYSMAN'\r\n  2  minus\r\n  3  select owner,segment_name from b where segment_name='SYS' OR owner='SYSMAN';\r\n\r\nno rows selected\r\n\r\n\r\nExecution Plan\r\n----------------------------------------------------------\r\nPlan hash value: 1933636850\r\n\r\n--------------------------------------------------------------------------------------------------\r\n| Id  | Operation                      | Name    | Rows  | Bytes |TempSpc| Cost (%CPU)| Time     |\r\n--------------------------------------------------------------------------------------------------\r\n|   0 | SELECT STATEMENT               |         |  7372 |   746K|       |   298  (81)| 00:00:04 |\r\n|   1 |  MINUS                         |         |       |       |       |            |          |\r\n|   2 |   SORT UNIQUE                  |         |  7372 |   424K|   504K|   168   (2)| 00:00:03 |\r\n|   3 |    CONCATENATION               |         |       |       |       |            |          |\r\n|   4 |     TABLE ACCESS BY INDEX ROWID| A       |     1 |    59 |       |    29   (0)| 00:00:01 |\r\n|*  5 |      INDEX RANGE SCAN          | IDX_A_1 |    34 |       |       |   118   (0)| 00:00:02 |\r\n|*  6 |     TABLE ACCESS FULL          | A       |  7371 |   424K|       |    31   (4)| 00:00:01 |\r\n|   7 |   SORT UNIQUE                  |         |  5584 |   321K|   384K|   130   (3)| 00:00:02 |\r\n|   8 |    CONCATENATION               |         |       |       |       |            |          |\r\n|   9 |     TABLE ACCESS BY INDEX ROWID| B       |     1 |    59 |       |    22   (0)| 00:00:01 |\r\n|* 10 |      INDEX RANGE SCAN          | IDX_B_1 |    26 |       |       |    90   (0)| 00:00:02 |\r\n|* 11 |     TABLE ACCESS FULL          | B       |  5583 |   321K|       |    23   (0)| 00:00:01 |\r\n--------------------------------------------------------------------------------------------------\r\n\r\nPredicate Information (identified by operation id):\r\n---------------------------------------------------\r\n\r\n   5 - access("OWNER"='SYSMAN')\r\n   6 - filter("SEGMENT_NAME"='SYS' AND LNNVL("OWNER"='SYSMAN'))\r\n  10 - access("OWNER"='SYSMAN')\r\n  11 - filter("SEGMENT_NAME"='SYS' AND LNNVL("OWNER"='SYSMAN'))\r\n\r\nNote\r\n-----\r\n   - dynamic sampling used for this statement (level=2)\r\n\r\n\r\nStatistics\r\n----------------------------------------------------------\r\n          0  recursive calls\r\n          0  db block gets\r\n      18367  consistent gets\r\n      18361  physical reads\r\n          0  redo size\r\n        407  bytes sent via SQL*Net to client\r\n        512  bytes received via SQL*Net from client\r\n          1  SQL*Net roundtrips to\/from client\r\n          2  sorts (memory)\r\n          0  sorts (disk)\r\n          0  rows processed\r\n\r\nsys@ora11gr2> @10046_off\r\n\r\nSession altered.\r\n\r\nsys@ora11gr2> set autot off\r\n<\/pre>\n
\u67e5\u770b10046\u7684trace\u6587\u4ef6<\/p>\n
\r\n=====================\r\nPARSING IN CURSOR #139675261676696 len=157 dep=0 uid=0 oct=3 lid=0 tim=1407831155594924 hv=2227977636 ad='91e32af0' sqlid='4s1knck2csgd4'\r\nselect owner,segment_name from a where segment_name='SYS' OR owner='SYSMAN'\r\nminus\r\nselect owner,segment_name from b where segment_name='SYS' OR owner='SYSMAN'\r\nEND OF STMT\r\nPARSE #139675261676696:c=0,e=111,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=1933636850,tim=1407831155594923\r\nEXEC #139675261676696:c=0,e=130,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=1933636850,tim=1407831155595128\r\nWAIT #139675261676696: nam='SQL*Net message to client' ela= 1 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=1407831155595165\r\nWAIT #139675261676696: nam='db file sequential read' ela= 16 file#=1 block#=102201 blocks=1 obj#=71854 tim=1407831155595257\r\nWAIT #139675261676696: nam='db file sequential read' ela= 10 file#=1 block#=105840 blocks=1 obj#=71854 tim=1407831155595371\r\nWAIT #139675261676696: nam='db file sequential read' ela= 7 file#=1 block#=105697 blocks=1 obj#=71854 tim=1407831155595434\r\nWAIT #139675261676696: nam='db file sequential read' ela= 10 file#=1 block#=80056 blocks=1 obj#=71850 tim=1407831155595506\r\nWAIT #139675261676696: nam='direct path read' ela= 639 file number=1 first dba=80057 block cnt=71 obj#=71850 tim=1407831155596842\r\nWAIT #139675261676696: nam='direct path read' ela= 531 file number=1 first dba=80384 block cnt=40 obj#=71850 tim=1407831155597494\r\nWAIT #139675261676696: nam='direct path read' ela= 70 file number=1 first dba=80512 block cnt=16 obj#=71850 tim=1407831155598051\r\nWAIT #139675261676696: nam='direct path read' ela= 631 file number=1 first dba=80640 block cnt=128 obj#=71850 tim=1407831155598815\r\nWAIT #139675261676696: nam='direct path read' ela= 316 file number=1 first dba=80768 block cnt=128 obj#=71850 tim=1407831155599241\r\nWAIT #139675261676696: nam='direct path read' ela= 161 file number=1 first dba=80896 block cnt=128 obj#=71850 tim=1407831155599712\r\nWAIT #139675261676696: nam='direct path read' ela= 263 file number=1 first dba=81024 block cnt=128 obj#=71850 tim=1407831155600274\r\nWAIT #139675261676696: nam='direct path read' ela= 157 file number=1 first dba=81152 block cnt=128 obj#=71850 tim=1407831155600753\r\nWAIT #139675261676696: nam='direct path read' ela= 177 file number=1 first dba=81280 block cnt=128 obj#=71850 tim=1407831155601216\r\nWAIT #139675261676696: nam='direct path read' ela= 166 file number=1 first dba=81408 block cnt=128 obj#=71850 tim=1407831155601734\r\nWAIT #139675261676696: nam='direct path read' ela= 163 file number=1 first dba=81536 block cnt=128 obj#=71850 tim=1407831155602192\r\nWAIT #139675261676696: nam='direct path read' ela= 171 file number=1 first dba=81664 block cnt=128 obj#=71850 tim=1407831155602695\r\nWAIT #139675261676696: nam='direct path read' ela= 156 file number=1 first dba=81792 block cnt=128 obj#=71850 tim=1407831155603135\r\nWAIT #139675261676696: nam='direct path read' ela= 248 file number=1 first dba=81920 block cnt=128 obj#=71850 tim=1407831155603824\r\nWAIT #139675261676696: nam='direct path read' ela= 319 file number=1 first dba=82048 block cnt=128 obj#=71850 tim=1407831155604742\r\nWAIT #139675261676696: nam='direct path read' ela= 243 file number=1 first dba=82176 block cnt=128 obj#=71850 tim=1407831155605354\r\nWAIT #139675261676696: nam='direct path read' ela= 172 file number=1 first dba=82304 block cnt=128 obj#=71850 tim=1407831155605864\r\nWAIT #139675261676696: nam='direct path read' ela= 251 file number=1 first dba=82432 block cnt=128 obj#=71850 tim=1407831155606412\r\nWAIT #139675261676696: nam='direct path read' ela= 161 file number=1 first dba=82560 block cnt=128 obj#=71850 tim=1407831155606874\r\nWAIT #139675261676696: nam='direct path read' ela= 163 file number=1 first dba=82688 block cnt=128 obj#=71850 tim=1407831155607320\r\nWAIT #139675261676696: nam='direct path read' ela= 163 file number=1 first dba=82816 block cnt=128 obj#=71850 tim=1407831155607823\r\nWAIT #139675261676696: nam='direct path read' ela= 188 file number=1 first dba=82944 block cnt=128 obj#=71850 tim=1407831155608303\r\nWAIT #139675261676696: nam='direct path read' ela= 170 file number=1 first dba=83072 block cnt=128 obj#=71850 tim=1407831155609012\r\nWAIT #139675261676696: nam='direct path read' ela= 212 file number=1 first dba=83200 block cnt=128 obj#=71850 tim=1407831155609519\r\nWAIT #139675261676696: nam='direct path read' ela= 274 file number=1 first dba=83328 block cnt=128 obj#=71850 tim=1407831155610085\r\nWAIT #139675261676696: nam='direct path read' ela= 289 file number=1 first dba=83456 block cnt=128 obj#=71850 tim=1407831155610744\r\nWAIT #139675261676696: nam='direct path read' ela= 464 file number=1 first dba=83584 block cnt=128 obj#=71850 tim=1407831155611696\r\nWAIT #139675261676696: nam='direct path read' ela= 257 file number=1 first dba=83712 block cnt=128 obj#=71850 tim=1407831155612264\r\nWAIT #139675261676696: nam='direct path read' ela= 274 file number=1 first dba=83840 block cnt=128 obj#=71850 tim=1407831155612852\r\nWAIT #139675261676696: nam='direct path read' ela= 319 file number=1 first dba=83968 block cnt=128 obj#=71850 tim=1407831155613468\r\nWAIT #139675261676696: nam='direct path read' ela= 419 file number=1 first dba=84096 block cnt=128 obj#=71850 tim=1407831155614184\r\nWAIT #139675261676696: nam='direct path read' ela= 247 file number=1 first dba=84224 block cnt=128 obj#=71850 tim=1407831155614755\r\nWAIT #139675261676696: nam='direct path read' ela= 348 file number=1 first dba=84352 block cnt=128 obj#=71850 tim=1407831155615397\r\nWAIT #139675261676696: nam='direct path read' ela= 310 file number=1 first dba=84480 block cnt=128 obj#=71850 tim=1407831155616005\r\nWAIT #139675261676696: nam='direct path read' ela= 427 file number=1 first dba=84608 block cnt=128 obj#=71850 tim=1407831155616723\r\nWAIT #139675261676696: nam='direct path read' ela= 242 file number=1 first dba=84736 block cnt=128 obj#=71850 tim=1407831155617268\r\nWAIT #139675261676696: nam='direct path read' ela= 383 file number=1 first dba=84864 block cnt=128 obj#=71850 tim=1407831155617964\r\nWAIT #139675261676696: nam='direct path read' ela= 368 file number=1 first dba=84992 block cnt=128 obj#=71850 tim=1407831155619042\r\nWAIT #139675261676696: nam='direct path read' ela= 316 file number=1 first dba=85120 block cnt=128 obj#=71850 tim=1407831155619438\r\nWAIT #139675261676696: nam='direct path read' ela= 300 file number=1 first dba=85248 block cnt=128 obj#=71850 tim=1407831155620036\r\nWAIT #139675261676696: nam='direct path read' ela= 279 file number=1 first dba=85376 block cnt=128 obj#=71850 tim=1407831155620645\r\nWAIT #139675261676696: nam='direct path read' ela= 290 file number=1 first dba=85504 block cnt=128 obj#=71850 tim=1407831155621230\r\nWAIT #139675261676696: nam='direct path read' ela= 288 file number=1 first dba=85632 block cnt=128 obj#=71850 tim=1407831155621839\r\nWAIT #139675261676696: nam='direct path read' ela= 316 file number=1 first dba=85760 block cnt=128 obj#=71850 tim=1407831155622445\r\nWAIT #139675261676696: nam='direct path read' ela= 257 file number=1 first dba=85888 block cnt=128 obj#=71850 tim=1407831155623004\r\nWAIT #139675261676696: nam='direct path read' ela= 403 file number=1 first dba=86016 block cnt=128 obj#=71850 tim=1407831155623696\r\nWAIT #139675261676696: nam='direct path read' ela= 268 file number=1 first dba=86144 block cnt=128 obj#=71850 tim=1407831155624288\r\nWAIT #139675261676696: nam='direct path read' ela= 280 file number=1 first dba=86272 block cnt=128 obj#=71850 tim=1407831155624892\r\nWAIT #139675261676696: nam='direct path read' ela= 326 file number=1 first dba=86400 block cnt=128 obj#=71850 tim=1407831155625520\r\nWAIT #139675261676696: nam='direct path read' ela= 230 file number=1 first dba=86528 block cnt=128 obj#=71850 tim=1407831155626042\r\nWAIT #139675261676696: nam='direct path read' ela= 315 file number=1 first dba=86656 block cnt=128 obj#=71850 tim=1407831155626685\r\nWAIT #139675261676696: nam='direct path read' ela= 376 file number=1 first dba=86784 block cnt=128 obj#=71850 tim=1407831155627369\r\nWAIT #139675261676696: nam='direct path read' ela= 501 file number=1 first dba=86912 block cnt=128 obj#=71850 tim=1407831155628641\r\nWAIT #139675261676696: nam='direct path read' ela= 313 file number=1 first dba=87040 block cnt=128 obj#=71850 tim=1407831155629285\r\nWAIT #139675261676696: nam='direct path read' ela= 273 file number=1 first dba=87168 block cnt=128 obj#=71850 tim=1407831155629919\r\nWAIT #139675261676696: nam='direct path read' ela= 446 file number=1 first dba=87296 block cnt=128 obj#=71850 tim=1407831155630668\r\nWAIT #139675261676696: nam='direct path read' ela= 250 file number=1 first dba=87424 block cnt=128 obj#=71850 tim=1407831155631241\r\nWAIT #139675261676696: nam='direct path read' ela= 337 file number=1 first dba=87552 block cnt=128 obj#=71850 tim=1407831155631886\r\nWAIT #139675261676696: nam='direct path read' ela= 271 file number=1 first dba=87680 block cnt=128 obj#=71850 tim=1407831155632461\r\nWAIT #139675261676696: nam='direct path read' ela= 171 file number=1 first dba=87808 block cnt=128 obj#=71850 tim=1407831155632927\r\nWAIT #139675261676696: nam='direct path read' ela= 324 file number=1 first dba=87936 block cnt=128 obj#=71850 tim=1407831155633536\r\nWAIT #139675261676696: nam='direct path read' ela= 390 file number=1 first dba=88064 block cnt=128 obj#=71850 tim=1407831155634229\r\nWAIT #139675261676696: nam='direct path read' ela= 247 file number=1 first dba=88192 block cnt=128 obj#=71850 tim=1407831155634848\r\nWAIT #139675261676696: nam='direct path read' ela= 464 file number=1 first dba=88320 block cnt=128 obj#=71850 tim=1407831155635616\r\nWAIT #139675261676696: nam='direct path read' ela= 278 file number=1 first dba=88448 block cnt=128 obj#=71850 tim=1407831155636368\r\nWAIT #139675261676696: nam='direct path read' ela= 298 file number=1 first dba=88576 block cnt=128 obj#=71850 tim=1407831155636959\r\nWAIT #139675261676696: nam='direct path read' ela= 489 file number=1 first dba=88704 block cnt=128 obj#=71850 tim=1407831155637748\r\nWAIT #139675261676696: nam='direct path read' ela= 286 file number=1 first dba=88832 block cnt=128 obj#=71850 tim=1407831155638367\r\nWAIT #139675261676696: nam='direct path read' ela= 286 file number=1 first dba=88960 block cnt=128 obj#=71850 tim=1407831155638965\r\nWAIT #139675261676696: nam='direct path read' ela= 368 file number=1 first dba=89088 block cnt=128 obj#=71850 tim=1407831155639636\r\nWAIT #139675261676696: nam='direct path read' ela= 218 file number=1 first dba=89216 block cnt=128 obj#=71850 tim=1407831155640144\r\nWAIT #139675261676696: nam='direct path read' ela= 437 file number=1 first dba=89344 block cnt=128 obj#=71850 tim=1407831155640873\r\nWAIT #139675261676696: nam='direct path read' ela= 527 file number=1 first dba=89472 block cnt=128 obj#=71850 tim=1407831155641677\r\nWAIT #139675261676696: nam='direct path read' ela= 224 file number=1 first dba=89600 block cnt=128 obj#=71850 tim=1407831155642168\r\nWAIT #139675261676696: nam='direct path read' ela= 304 file number=1 first dba=89728 block cnt=128 obj#=71850 tim=1407831155642770\r\nWAIT #139675261676696: nam='direct path read' ela= 213 file number=1 first dba=89856 block cnt=128 obj#=71850 tim=1407831155643238\r\nWAIT #139675261676696: nam='direct path read' ela= 332 file number=1 first dba=89984 block cnt=128 obj#=71850 tim=1407831155643870\r\nWAIT #139675261676696: nam='direct path read' ela= 325 file number=1 first dba=90112 block cnt=128 obj#=71850 tim=1407831155644454\r\nWAIT #139675261676696: nam='direct path read' ela= 316 file number=1 first dba=90240 block cnt=128 obj#=71850 tim=1407831155645023\r\nWAIT #139675261676696: nam='direct path read' ela= 483 file number=1 first dba=90368 block cnt=128 obj#=71850 tim=1407831155645759\r\nWAIT #139675261676696: nam='direct path read' ela= 269 file number=1 first dba=90496 block cnt=128 obj#=71850 tim=1407831155646315\r\nWAIT #139675261676696: nam='direct path read' ela= 386 file number=1 first dba=90624 block cnt=128 obj#=71850 tim=1407831155647023\r\nWAIT #139675261676696: nam='direct path read' ela= 482 file number=1 first dba=90752 block cnt=128 obj#=71850 tim=1407831155647792\r\nWAIT #139675261676696: nam='direct path read' ela= 270 file number=1 first dba=90880 block cnt=128 obj#=71850 tim=1407831155648445\r\nWAIT #139675261676696: nam='direct path read' ela= 303 file number=1 first dba=91008 block cnt=128 obj#=71850 tim=1407831155649039\r\nWAIT #139675261676696: nam='direct path read' ela= 304 file number=1 first dba=91136 block cnt=128 obj#=71850 tim=1407831155649634\r\nWAIT #139675261676696: nam='direct path read' ela= 219 file number=1 first dba=91264 block cnt=128 obj#=71850 tim=1407831155650141\r\nWAIT #139675261676696: nam='direct path read' ela= 260 file number=1 first dba=91392 block cnt=128 obj#=71850 tim=1407831155650693\r\nWAIT #139675261676696: nam='direct path read' ela= 313 file number=1 first dba=91520 block cnt=128 obj#=71850 tim=1407831155651257\r\nWAIT #139675261676696: nam='direct path read' ela= 350 file number=1 first dba=91648 block cnt=128 obj#=71850 tim=1407831155652029\r\nWAIT #139675261676696: nam='direct path read' ela= 366 file number=1 first dba=91776 block cnt=128 obj#=71850 tim=1407831155652672\r\nWAIT #139675261676696: nam='direct path read' ela= 255 file number=1 first dba=91904 block cnt=128 obj#=71850 tim=1407831155653188\r\nWAIT #139675261676696: nam='direct path read' ela= 372 file number=1 first dba=92032 block cnt=128 obj#=71850 tim=1407831155653849\r\nWAIT #139675261676696: nam='direct path read' ela= 319 file number=1 first dba=92160 block cnt=128 obj#=71850 tim=1407831155654435\r\nWAIT #139675261676696: nam='direct path read' ela= 317 file number=1 first dba=92288 block cnt=128 obj#=71850 tim=1407831155655016\r\nWAIT #139675261676696: nam='direct path read' ela= 318 file number=1 first dba=92416 block cnt=128 obj#=71850 tim=1407831155655589\r\nWAIT #139675261676696: nam='direct path read' ela= 296 file number=1 first dba=92544 block cnt=128 obj#=71850 tim=1407831155656137\r\nWAIT #139675261676696: nam='direct path read' ela= 241 file number=1 first dba=92672 block cnt=128 obj#=71850 tim=1407831155656687\r\nWAIT #139675261676696: nam='direct path read' ela= 304 file number=1 first dba=92800 block cnt=128 obj#=71850 tim=1407831155657246\r\nWAIT #139675261676696: nam='direct path read' ela= 326 file number=1 first dba=92928 block cnt=128 obj#=71850 tim=1407831155657888\r\nWAIT #139675261676696: nam='direct path read' ela= 426 file number=1 first dba=93056 block cnt=128 obj#=71850 tim=1407831155658641\r\nWAIT #139675261676696: nam='direct path read' ela= 361 file number=1 first dba=93184 block cnt=128 obj#=71850 tim=1407831155659324\r\nWAIT #139675261676696: nam='direct path read' ela= 348 file number=1 first dba=93312 block cnt=128 obj#=71850 tim=1407831155660014\r\nWAIT #139675261676696: nam='direct path read' ela= 317 file number=1 first dba=93440 block cnt=128 obj#=71850 tim=1407831155660640\r\nWAIT #139675261676696: nam='direct path read' ela= 262 file number=1 first dba=93568 block cnt=128 obj#=71850 tim=1407831155661198\r\nWAIT #139675261676696: nam='direct path read' ela= 200 file number=1 first dba=93696 block cnt=89 obj#=71850 tim=1407831155661697\r\nWAIT #139675261676696: nam='db file sequential read' ela= 13 file#=1 block#=104633 blocks=1 obj#=71855 tim=1407831155662180\r\nWAIT #139675261676696: nam='db file sequential read' ela= 10 file#=1 block#=107482 blocks=1 obj#=71855 tim=1407831155662229\r\nWAIT #139675261676696: nam='db file sequential read' ela= 9 file#=1 block#=107189 blocks=1 obj#=71855 tim=1407831155662269\r\nWAIT #139675261676696: nam='db file sequential read' ela= 9 file#=1 block#=80424 blocks=1 obj#=71851 tim=1407831155662323\r\nWAIT #139675261676696: nam='direct path read' ela= 222 file number=1 first dba=80425 block cnt=87 obj#=71851 tim=1407831155662778\r\nWAIT #139675261676696: nam='direct path read' ela= 126 file number=1 first dba=80528 block cnt=40 obj#=71851 tim=1407831155662952\r\nWAIT #139675261676696: nam='direct path read' ela= 491 file number=1 first dba=93824 block cnt=128 obj#=71851 tim=1407831155663713\r\nWAIT #139675261676696: nam='direct path read' ela= 288 file number=1 first dba=93952 block cnt=128 obj#=71851 tim=1407831155664200\r\nWAIT #139675261676696: nam='direct path read' ela= 338 file number=1 first dba=94080 block cnt=128 obj#=71851 tim=1407831155664946\r\nWAIT #139675261676696: nam='direct path read' ela= 324 file number=1 first dba=94208 block cnt=128 obj#=71851 tim=1407831155665630\r\nWAIT #139675261676696: nam='direct path read' ela= 266 file number=1 first dba=94336 block cnt=128 obj#=71851 tim=1407831155666251\r\nWAIT #139675261676696: nam='direct path read' ela= 256 file number=1 first dba=94464 block cnt=128 obj#=71851 tim=1407831155666926\r\nWAIT #139675261676696: nam='direct path read' ela= 567 file number=1 first dba=94592 block cnt=128 obj#=71851 tim=1407831155667892\r\nWAIT #139675261676696: nam='direct path read' ela= 344 file number=1 first dba=94720 block cnt=128 obj#=71851 tim=1407831155668808\r\nWAIT #139675261676696: nam='direct path read' ela= 315 file number=1 first dba=94848 block cnt=128 obj#=71851 tim=1407831155669518\r\nWAIT #139675261676696: nam='direct path read' ela= 339 file number=1 first dba=94976 block cnt=128 obj#=71851 tim=1407831155670212\r\nWAIT #139675261676696: nam='direct path read' ela= 274 file number=1 first dba=95104 block cnt=128 obj#=71851 tim=1407831155670881\r\nWAIT #139675261676696: nam='direct path read' ela= 447 file number=1 first dba=95232 block cnt=128 obj#=71851 tim=1407831155671722\r\nWAIT #139675261676696: nam='direct path read' ela= 373 file number=1 first dba=95360 block cnt=128 obj#=71851 tim=1407831155672513\r\nWAIT #139675261676696: nam='direct path read' ela= 217 file number=1 first dba=95488 block cnt=128 obj#=71851 tim=1407831155673093\r\nWAIT #139675261676696: nam='direct path read' ela= 263 file number=1 first dba=95616 block cnt=128 obj#=71851 tim=1407831155673751\r\nWAIT #139675261676696: nam='direct path read' ela= 273 file number=1 first dba=95744 block cnt=128 obj#=71851 tim=1407831155674378\r\nWAIT #139675261676696: nam='direct path read' ela= 306 file number=1 first dba=95872 block cnt=128 obj#=71851 tim=1407831155675052\r\nWAIT #139675261676696: nam='direct path read' ela= 266 file number=1 first dba=96000 block cnt=128 obj#=71851 tim=1407831155675704\r\nWAIT #139675261676696: nam='direct path read' ela= 266 file number=1 first dba=96128 block cnt=128 obj#=71851 tim=1407831155676311\r\nWAIT #139675261676696: nam='direct path read' ela= 165 file number=1 first dba=96256 block cnt=128 obj#=71851 tim=1407831155676894\r\nWAIT #139675261676696: nam='direct path read' ela= 324 file number=1 first dba=96384 block cnt=128 obj#=71851 tim=1407831155677581\r\nWAIT #139675261676696: nam='direct path read' ela= 312 file number=1 first dba=96512 block cnt=128 obj#=71851 tim=1407831155678288\r\nWAIT #139675261676696: nam='direct path read' ela= 277 file number=1 first dba=96640 block cnt=128 obj#=71851 tim=1407831155679006\r\nWAIT #139675261676696: nam='direct path read' ela= 316 file number=1 first dba=96768 block cnt=128 obj#=71851 tim=1407831155679673\r\nWAIT #139675261676696: nam='direct path read' ela= 247 file number=1 first dba=96896 block cnt=128 obj#=71851 tim=1407831155680276\r\nWAIT #139675261676696: nam='direct path read' ela= 340 file number=1 first dba=97024 block cnt=128 obj#=71851 tim=1407831155681067\r\nWAIT #139675261676696: nam='direct path read' ela= 261 file number=1 first dba=97152 block cnt=128 obj#=71851 tim=1407831155681731\r\nWAIT #139675261676696: nam='direct path read' ela= 287 file number=1 first dba=97280 block cnt=128 obj#=71851 tim=1407831155682386\r\nWAIT #139675261676696: nam='direct path read' ela= 301 file number=1 first dba=97408 block cnt=128 obj#=71851 tim=1407831155683056\r\nWAIT #139675261676696: nam='direct path read' ela= 269 file number=1 first dba=97536 block cnt=128 obj#=71851 tim=1407831155683741\r\nWAIT #139675261676696: nam='direct path read' ela= 229 file number=1 first dba=97664 block cnt=128 obj#=71851 tim=1407831155684342\r\nWAIT #139675261676696: nam='direct path read' ela= 283 file number=1 first dba=97792 block cnt=128 obj#=71851 tim=1407831155685007\r\nWAIT #139675261676696: nam='direct path read' ela= 244 file number=1 first dba=97920 block cnt=128 obj#=71851 tim=1407831155685653\r\nWAIT #139675261676696: nam='direct path read' ela= 275 file number=1 first dba=98048 block cnt=128 obj#=71851 tim=1407831155686302\r\nWAIT #139675261676696: nam='direct path read' ela= 259 file number=1 first dba=98176 block cnt=128 obj#=71851 tim=1407831155687293\r\nWAIT #139675261676696: nam='direct path read' ela= 341 file number=1 first dba=98304 block cnt=128 obj#=71851 tim=1407831155687679\r\nWAIT #139675261676696: nam='direct path read' ela= 271 file number=1 first dba=98432 block cnt=128 obj#=71851 tim=1407831155688329\r\nWAIT #139675261676696: nam='direct path read' ela= 304 file number=1 first dba=98560 block cnt=128 obj#=71851 tim=1407831155689137\r\nWAIT #139675261676696: nam='direct path read' ela= 209 file number=1 first dba=98688 block cnt=90 obj#=71851 tim=1407831155689771\r\nFETCH #139675261676696:c=94985,e=95168,p=18361,cr=18367,cu=0,mis=0,r=0,dep=0,og=1,plh=1933636850,tim=1407831155690354\r\nSTAT #139675261676696 id=1 cnt=0 pid=0 pos=1 obj=0 op='MINUS  (cr=18367 pr=18361 pw=0 time=95220 us)'\r\nSTAT #139675261676696 id=2 cnt=0 pid=1 pos=1 obj=0 op='SORT UNIQUE (cr=13279 pr=13276 pw=0 time=66974 us cost=168 size=434948 card=7372)'\r\nSTAT #139675261676696 id=3 cnt=0 pid=2 pos=1 obj=0 op='CONCATENATION  (cr=13279 pr=13276 pw=0 time=66960 us)'\r\nSTAT #139675261676696 id=4 cnt=0 pid=3 pos=1 obj=71850 op='TABLE ACCESS BY INDEX ROWID A (cr=3 pr=3 pw=0 time=309 us cost=29 size=59 card=1)'\r\nSTAT #139675261676696 id=5 cnt=0 pid=4 pos=1 obj=71854 op='INDEX RANGE SCAN IDX_A_1 (cr=3 pr=3 pw=0 time=281 us cost=118 size=0 card=34)'\r\nSTAT #139675261676696 id=6 cnt=0 pid=3 pos=2 obj=71850 op='TABLE ACCESS FULL A (cr=13276 pr=13273 pw=0 time=66639 us cost=31 size=434889 card=7371)'\r\nSTAT #139675261676696 id=7 cnt=0 pid=1 pos=2 obj=0 op='SORT UNIQUE (cr=5088 pr=5085 pw=0 time=28239 us cost=130 size=329456 card=5584)'\r\nSTAT #139675261676696 id=8 cnt=0 pid=7 pos=1 obj=0 op='CONCATENATION  (cr=5088 pr=5085 pw=0 time=28222 us)'\r\nSTAT #139675261676696 id=9 cnt=0 pid=8 pos=1 obj=71851 op='TABLE ACCESS BY INDEX ROWID B (cr=3 pr=3 pw=0 time=166 us cost=22 size=59 card=1)'\r\nSTAT #139675261676696 id=10 cnt=0 pid=9 pos=1 obj=71855 op='INDEX RANGE SCAN IDX_B_1 (cr=3 pr=3 pw=0 time=156 us cost=90 size=0 card=26)'\r\nSTAT #139675261676696 id=11 cnt=0 pid=8 pos=2 obj=71851 op='TABLE ACCESS FULL B (cr=5085 pr=5082 pw=0 time=28051 us cost=23 size=329397 card=5583)'\r\nWAIT #139675261676696: nam='SQL*Net message from client' ela= 279 driver id=1650815232 #bytes=1 p3=0 obj#=71851 tim=1407831155690867\r\n*** SESSION ID:(1.23) 2014-08-12 16:12:35.691\r\n\r\nCLOSE #139675261676696:c=0,e=10,dep=0,type=0,tim=1407831155691886\r\n=====================\r\n<\/pre>\n
\u5757\u5bf9\u8c61\u7684\u8bbf\u95ee\u987a\u5e8f\uff1a
\n71854->71850->71855->71851<\/p>\n
\r\nsys@ora11gr2> col OBJECT_NAME for a10\r\nsys@ora11gr2> select OWNER,OBJECT_NAME,OBJECT_TYPE,DATA_OBJECT_ID from dba_objects where DATA_OBJECT_ID in (71854,71850,71855,71851);\r\n\r\nOWNER                          OBJECT_NAM OBJECT_TYPE         DATA_OBJECT_ID\r\n------------------------------ ---------- ------------------- --------------\r\nSYS                            A          TABLE                        71850\r\nSYS                            B          TABLE                        71851\r\nSYS                            IDX_A_1    INDEX                        71854\r\nSYS                            IDX_B_1    INDEX                        71855\r\n\r\n4 rows selected.\r\n<\/pre>\n
\u7ffb\u8bd1\u540e\u5757\u5bf9\u8c61\u7684\u8bbf\u95ee\u987a\u5e8f\u5c31\u662f\uff1a<\/p>\n
\r\nIDX_A_1\t ->\tA\t->\tIDX_B_1 \t->\tB\r\n5\t ->\t4\t->\t10\t\t->\t9\r\n<\/pre>\n
\u7ed3\u5408\u6267\u884c\u8ba1\u5212\uff0c10046\u5757\u8bbf\u95ee\u987a\u5e8f\u53ca\u4e8c\u53c9\u6811\uff0c\u5f97\u51fa\u5982\u4e0b\u4e8c\u53c9\u6811\uff1a<\/p>\n
\r\n\t\t0\r\n\t\t|\r\n\t\t1\r\n             \/     \\\r\n\t    2       7\r\n           \/       \/\r\n          3       8\r\n         \/ \\     \/ \\\r\n        4   6   9   11\r\n       \/       \/\r\n      5       10\r\n<\/pre>\n
\u4e8c\u53c9\u6811LRD\u904d\u5386\uff08\u540e\u5e8f\u904d\u5386\uff09\u8def\u5f84\u4e3a\uff1a5-4-6-3-2-10-9-11-8-7-1-0
\n\u6240\u4ee5\u6b63\u786e\u7684\u6267\u884c\u987a\u5e8f\u4e5f\u5c31\u662f\uff1a5-4-6-3-2-10-9-11-8-7-1-0<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"
\u8be5\u7bc7\u6587\u6863\u8bf4\u660e\u5982\u4f55\u6b63\u786e\u7406\u89e3\u5206\u6790sql\u8bed\u53e5\u7684\u6267\u884c\u8ba1\u5212\u3002 \u9996\u5148\uff0c\u6269\u5c55\u4e0b\u4e8c\u53c9\u6811\u76f8\u5173\u77e5\u8bc6\uff1a \u524d\u5e8f\u904d\u5386\uff08DLR\uff09 \u524d\u5e8f\u904d\u5386 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":true,"template":"","format":"standard","meta":[],"categories":[37],"tags":[],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/1297"}],"collection":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1297"}],"version-history":[{"count":5,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/1297\/revisions"}],"predecessor-version":[{"id":1373,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/1297\/revisions\/1373"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1297"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1297"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1297"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}