- 最后登录
- 2023-8-16
- 在线时间
- 1686 小时
- 威望
- 2135
- 金钱
- 50532
- 注册时间
- 2011-10-12
- 阅读权限
- 200
- 帖子
- 5207
- 精华
- 39
- 积分
- 2135
- UID
- 2
|
1#
发表于 2012-6-18 20:50:01
|
查看: 4179 |
回复: 1
SQL优化减少逻辑读一例
多表LEFT JOIN 执行计划使用 NESTED LOOP导致逻辑读较多, 产生大量 latch: cache buffer chains等待事件, 优化该SQL意在减少逻辑读 避免latch free出现
原始SQL 使用了 use_hash hint但实际在子查询中并未生效
- SQL> set autotrace traceonly;
- SQL>
- SQL>
- SQL> SELECT /*+use_hash(TCATEGORY TPROCATMAPPING TPRODUCTPRICE
- 2 TPRODUCTBRIEF TBARCODE TBRAND)*/
- 3 PCC.SEQ_ID,
- 4 PCC.NC_CATEGORYNAME,
- 5 PCC.NC_CATEGORYNAME_EN,
- 6 NVL(B.CNT, 0) CONT,
- 7 PCC.N_SECONDCATEID N_PARENTID,
- 8 PCC.N_FIRESTCATEID N_PARENTID2
- 9 FROM TCATEGORY PCC
- 10 LEFT JOIN (SELECT A.SEQ_ID, COUNT(A.N_SKUID) CNT
- 11 FROM (SELECT DISTINCT CAT.SEQ_ID, PRI.N_SKUID
- 12 FROM TCATEGORY CAT
- 13 LEFT JOIN TCATEGORY CAT2
- 14 ON CAT.SEQ_ID = CAT2.N_THIRDCATEID
- 15 LEFT JOIN TPROCATMAPPING PMC
- 16 ON (CAT2.SEQ_ID = PMC.N_CATEGORYID OR
- 17 CAT.SEQ_ID = PMC.N_CATEGORYID)
- 18 LEFT JOIN TPRODUCTPRICE PRI
- 19 ON PMC.N_PRODUCTID = PRI.N_SKUID
- 20 LEFT JOIN TPRODUCTBRIEF BRI
- 21 ON PRI.N_SKUID = BRI.SEQ_ID
- 22 LEFT JOIN TBRAND BRA
- 23 ON BRI.N_BRANDID = BRA.SEQ_ID
- 24 LEFT JOIN TBARCODE BAR
- 25 ON PRI.N_SKUID = BAR.N_PRODUCT_CODE
- 26 WHERE CAT.N_FIRESTCATEID > 0
- 27 AND CAT.N_SECONDCATEID > 0
- 28 AND CAT.N_THIRDCATEID = 0
- 29 AND PRI.N_SHOPID = 103
- 30 AND (PRI.SI_STATUS = 2 OR PRI.SI_STATUS = 4)
- 31 AND BAR.N_SHOPID = 103
- 32 AND NVL(BAR.B_ISDELETE, '0') = '0'
- 33 AND NOT BRI.C_ISIMAGE IS NULL
- 34 AND NVL(BRA.B_ISDELETE, '0') = '0'
- 35 AND PRI.N_PRICE > 0
- 36 AND PRI.B_ISDELETE = '0'
- 37 AND BRI.B_ISDELETE = '0'
- 38 AND PRI.SI_RTSTATUS <> 8
- 39 AND PRI.SI_RTSTATUS <> 9) A
- 40 GROUP BY A.SEQ_ID) B
- 41 ON PCC.SEQ_ID = B.SEQ_ID
- 42 WHERE PCC.N_FIRESTCATEID > 0
- 43 AND PCC.N_SECONDCATEID > 0
- 44 AND PCC.N_THIRDCATEID = 0
- 45 AND NOT PCC.NC_CATEGORYNAME IS NULL
- 46 AND NOT PCC.NC_CATEGORYNAME_EN IS NULL
- 47 AND B.CNT > 0
- 48 ORDER BY PCC.N_FIRESTCATEID ASC, PCC.N_SECONDCATEID ASC, PCC.SI_SORT ASC
- 49 /
- 514 rows selected.
- Execution Plan
- ----------------------------------------------------------
- Plan hash value: 3880035186
- ------------------------------------------------------------------------------------------------------------------------------
- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
- ------------------------------------------------------------------------------------------------------------------------------
- | 0 | SELECT STATEMENT | | 1 | 59 | 617 (1)| 00:00:01 |
- | 1 | SORT ORDER BY | | 1 | 59 | 617 (1)| 00:00:01 |
- | 2 | NESTED LOOPS | | | | | |
- | 3 | NESTED LOOPS | | 1 | 59 | 616 (1)| 00:00:01 |
- | 4 | VIEW | | 1 | 16 | 616 (1)| 00:00:01 |
- |* 5 | FILTER | | | | | |
- | 6 | HASH GROUP BY | | 1 | 16 | 616 (1)| 00:00:01 |
- | 7 | VIEW | | 139 | 2224 | 616 (1)| 00:00:01 |
- | 8 | HASH UNIQUE | | 139 | 11676 | 616 (1)| 00:00:01 |
- | 9 | CONCATENATION | | | | | |
- | 10 | NESTED LOOPS OUTER | | 80 | 6720 | 406 (1)| 00:00:01 |
- | 11 | NESTED LOOPS | | 11 | 858 | 388 (0)| 00:00:01 |
- |* 12 | FILTER | | | | | |
- |* 13 | HASH JOIN OUTER | | 10 | 700 | 348 (0)| 00:00:01 |
- | 14 | NESTED LOOPS | | | | | |
- | 15 | NESTED LOOPS | | 19 | 1254 | 339 (0)| 00:00:01 |
- | 16 | NESTED LOOPS | | 19 | 684 | 320 (0)| 00:00:01 |
- | 17 | NESTED LOOPS | | 94 | 1974 | 38 (0)| 00:00:01 |
- |* 18 | TABLE ACCESS BY INDEX ROWID| TCATEGORY | 7 | 84 | 5 (0)| 00:00:01 |
- |* 19 | INDEX RANGE SCAN | IDEX_N_THIRDCATEID | 7 | | 1 (0)| 00:00:01 |
- | 20 | TABLE ACCESS BY INDEX ROWID| TPROCATMAPPING | 14 | 126 | 6 (0)| 00:00:01 |
- |* 21 | INDEX RANGE SCAN | IDX_TPROCATMAPPING_CATEGORYID | 14 | | 1 (0)| 00:00:01 |
- |* 22 | TABLE ACCESS BY INDEX ROWID | TPRODUCTPRICE | 1 | 15 | 3 (0)| 00:00:01 |
- |* 23 | INDEX RANGE SCAN | IDX_TPRODUCTPRICE_SKUID | 2 | | 1 (0)| 00:00:01 |
- |* 24 | INDEX UNIQUE SCAN | PK_TPRODUCTBRIEF | 1 | | 0 (0)| 00:00:01 |
- |* 25 | TABLE ACCESS BY INDEX ROWID | TPRODUCTBRIEF | 1 | 30 | 1 (0)| 00:00:01 |
- | 26 | TABLE ACCESS FULL | TBRAND | 1835 | 7340 | 9 (0)| 00:00:01 |
- |* 27 | TABLE ACCESS BY INDEX ROWID | TBARCODE | 1 | 8 | 4 (0)| 00:00:01 |
- |* 28 | INDEX RANGE SCAN | IDX_TBARCODE_PRODUCTCODE | 2 | | 1 (0)| 00:00:01 |
- | 29 | TABLE ACCESS BY INDEX ROWID | TCATEGORY | 7 | 42 | 5 (0)| 00:00:01 |
- |* 30 | INDEX RANGE SCAN | IDEX_N_THIRDCATEID | 7 | | 1 (0)| 00:00:01 |
- |* 31 | FILTER | | | | | |
- | 32 | NESTED LOOPS OUTER | | 3 | 252 | 209 (1)| 00:00:01 |
- | 33 | NESTED LOOPS | | 6 | 480 | 203 (1)| 00:00:01 |
- | 34 | NESTED LOOPS | | 5 | 360 | 183 (1)| 00:00:01 |
- | 35 | NESTED LOOPS | | 5 | 210 | 178 (1)| 00:00:01 |
- |* 36 | HASH JOIN | | 24 | 648 | 106 (1)| 00:00:01 |
- | 37 | NESTED LOOPS OUTER | | 46 | 828 | 40 (0)| 00:00:01 |
- |* 38 | TABLE ACCESS BY INDEX ROWID | TCATEGORY | 7 | 84 | 5 (0)| 00:00:01 |
- |* 39 | INDEX RANGE SCAN | IDEX_N_THIRDCATEID | 7 | | 1 (0)| 00:00:01 |
- | 40 | TABLE ACCESS BY INDEX ROWID | TCATEGORY | 7 | 42 | 5 (0)| 00:00:01 |
- |* 41 | INDEX RANGE SCAN | IDEX_N_THIRDCATEID | 7 | | 1 (0)| 00:00:01 |
- | 42 | TABLE ACCESS FULL | TPROCATMAPPING | 22878 | 201K| 65 (0)| 00:00:01 |
- |* 43 | TABLE ACCESS BY INDEX ROWID | TPRODUCTPRICE | 1 | 15 | 3 (0)| 00:00:01 |
- |* 44 | INDEX RANGE SCAN | IDX_TPRODUCTPRICE_SKUID | 2 | | 1 (0)| 00:00:01 |
- |* 45 | TABLE ACCESS BY INDEX ROWID | TPRODUCTBRIEF | 1 | 30 | 1 (0)| 00:00:01 |
- |* 46 | INDEX UNIQUE SCAN | PK_TPRODUCTBRIEF | 1 | | 0 (0)| 00:00:01 |
- |* 47 | TABLE ACCESS BY INDEX ROWID | TBARCODE | 1 | 8 | 4 (0)| 00:00:01 |
- |* 48 | INDEX RANGE SCAN | IDX_TBARCODE_PRODUCTCODE | 2 | | 1 (0)| 00:00:01 |
- | 49 | TABLE ACCESS BY INDEX ROWID | TBRAND | 1 | 4 | 1 (0)| 00:00:01 |
- |* 50 | INDEX UNIQUE SCAN | PK_TBRAND | 1 | | 0 (0)| 00:00:01 |
- |* 51 | INDEX UNIQUE SCAN | PK_TCATEGORY | 1 | | 0 (0)| 00:00:01 |
- |* 52 | TABLE ACCESS BY INDEX ROWID | TCATEGORY | 1 | 43 | 1 (0)| 00:00:01 |
- ------------------------------------------------------------------------------------------------------------------------------
- Predicate Information (identified by operation id):
- ---------------------------------------------------
- 5 - filter(COUNT("A"."N_SKUID")>0)
- 12 - filter(NVL("BRA"."B_ISDELETE",'0')='0')
- 13 - access("BRA"."SEQ_ID"(+)=TO_NUMBER("BRI"."N_BRANDID"))
- 18 - filter("CAT"."N_FIRESTCATEID">0 AND "CAT"."N_SECONDCATEID">0)
- 19 - access("CAT"."N_THIRDCATEID"=0)
- 21 - access("CAT"."SEQ_ID"="PMC"."N_CATEGORYID")
- 22 - filter("PRI"."N_SHOPID"=103 AND ("PRI"."SI_STATUS"=2 OR "PRI"."SI_STATUS"=4) AND "PRI"."SI_RTSTATUS"<>8 AND
- "PRI"."SI_RTSTATUS"<>9 AND "PRI"."B_ISDELETE"='0' AND "PRI"."N_PRICE">0)
- 23 - access("PMC"."N_PRODUCTID"="PRI"."N_SKUID")
- 24 - access("PRI"."N_SKUID"="BRI"."SEQ_ID")
- 25 - filter("BRI"."C_ISIMAGE" IS NOT NULL AND "BRI"."B_ISDELETE"='0')
- 27 - filter("BAR"."N_SHOPID"=103 AND NVL("BAR"."B_ISDELETE",'0')='0')
- 28 - access("PRI"."N_SKUID"="BAR"."N_PRODUCT_CODE")
- 30 - access("CAT"."SEQ_ID"="CAT2"."N_THIRDCATEID"(+))
- 31 - filter(NVL("BRA"."B_ISDELETE",'0')='0')
- 36 - access("CAT2"."SEQ_ID"="PMC"."N_CATEGORYID")
- filter(LNNVL("CAT"."SEQ_ID"="PMC"."N_CATEGORYID"))
- 38 - filter("CAT"."N_FIRESTCATEID">0 AND "CAT"."N_SECONDCATEID">0)
- 39 - access("CAT"."N_THIRDCATEID"=0)
- 41 - access("CAT"."SEQ_ID"="CAT2"."N_THIRDCATEID"(+))
- 43 - filter("PRI"."N_SHOPID"=103 AND ("PRI"."SI_STATUS"=2 OR "PRI"."SI_STATUS"=4) AND "PRI"."SI_RTSTATUS"<>8 AND
- "PRI"."SI_RTSTATUS"<>9 AND "PRI"."B_ISDELETE"='0' AND "PRI"."N_PRICE">0)
- 44 - access("PMC"."N_PRODUCTID"="PRI"."N_SKUID")
- 45 - filter("BRI"."C_ISIMAGE" IS NOT NULL AND "BRI"."B_ISDELETE"='0')
- 46 - access("PRI"."N_SKUID"="BRI"."SEQ_ID")
- 47 - filter("BAR"."N_SHOPID"=103 AND NVL("BAR"."B_ISDELETE",'0')='0')
- 48 - access("PRI"."N_SKUID"="BAR"."N_PRODUCT_CODE")
- 50 - access("BRA"."SEQ_ID"(+)=TO_NUMBER("BRI"."N_BRANDID"))
- 51 - access("PCC"."SEQ_ID"="B"."SEQ_ID")
- 52 - filter("PCC"."N_THIRDCATEID"=0 AND "PCC"."N_FIRESTCATEID">0 AND "PCC"."N_SECONDCATEID">0 AND
- "PCC"."NC_CATEGORYNAME" IS NOT NULL AND "PCC"."NC_CATEGORYNAME_EN" IS NOT NULL)
- Statistics
- ----------------------------------------------------------
- 1 recursive calls
- 0 db block gets
- 154793 consistent gets
- 0 physical reads
- 0 redo size
- 30138 bytes sent via SQL*Net to client
- 898 bytes received via SQL*Net from client
- 36 SQL*Net roundtrips to/from client
- 1 sorts (memory)
- 0 sorts (disk)
- 514 rows processed
复制代码
过度使用NESTED LOOPS ,虽然单个表很小 只有几万行记录,但是在多表连接的情况下 仍产生了大量的逻辑读
使用NO_USE_NL HINT避免子查询中的 嵌套循环后 ,逻辑读有效减少:
- SQL> SELECT PCC.SEQ_ID,
- 2 PCC.NC_CATEGORYNAME,
- 3 PCC.NC_CATEGORYNAME_EN,
- 4 NVL(B.CNT, 0) CONT,
- 5 PCC.N_SECONDCATEID N_PARENTID,
- 6 PCC.N_FIRESTCATEID N_PARENTID2
- 7 FROM TCATEGORY PCC
- 8 LEFT JOIN (SELECT A.SEQ_ID,
- 9 COUNT(A.N_SKUID) CNT
- 10 FROM (SELECT /*+ NO_USE_NL(BAR,BRA,BRI,PRI,PMC,CAT2) */ DISTINCT CAT.SEQ_ID,
- 11 PRI.N_SKUID
- 12 FROM TCATEGORY CAT
- 13 LEFT JOIN TCATEGORY CAT2
- 14 ON CAT.SEQ_ID = CAT2.N_THIRDCATEID
- 15 LEFT JOIN TPROCATMAPPING PMC
- 16 ON CAT2.SEQ_ID = PMC.N_CATEGORYID
- 17 OR CAT.SEQ_ID = PMC.N_CATEGORYID
- 18 LEFT JOIN TPRODUCTPRICE PRI
- 19 ON PMC.N_PRODUCTID = PRI.N_SKUID
- 20 LEFT JOIN TPRODUCTBRIEF BRI
- 21 ON PRI.N_SKUID = BRI.SEQ_ID
- 22 LEFT JOIN TBRAND BRA
- 23 ON BRI.N_BRANDID = BRA.SEQ_ID
- 24 LEFT JOIN TBARCODE BAR
- 25 ON PRI.N_SKUID = BAR.N_PRODUCT_CODE
- 26 WHERE CAT.N_FIRESTCATEID > 0
- 27 AND CAT.N_SECONDCATEID > 0
- 28 AND CAT.N_THIRDCATEID = 0
- 29 AND PRI.N_SHOPID = 103
- 30 AND (PRI.SI_STATUS = 2
- 31 OR PRI.SI_STATUS = 4)
- 32 AND BAR.N_SHOPID = 103
- 33 AND NVL (BAR.B_ISDELETE, '0') = '0'
- 34 AND BRI.C_ISIMAGE IS NOT NULL
- 35 AND NVL (BRA.B_ISDELETE, '0') = '0'
- 36 AND PRI.N_PRICE > 0
- 37 AND PRI.B_ISDELETE = '0'
- 38 AND BRI.B_ISDELETE = '0'
- 39 AND PRI.SI_RTSTATUS <> 8
- 40 AND PRI.SI_RTSTATUS <> 9) A GROUP BY A.SEQ_ID) B
- 41 ON PCC.SEQ_ID = B.SEQ_ID
- 42 WHERE PCC.N_FIRESTCATEID > 0
- 43 AND PCC.N_SECONDCATEID > 0
- 44 AND PCC.N_THIRDCATEID = 0
- 45 AND PCC.NC_CATEGORYNAME IS NOT NULL
- 46 AND PCC.NC_CATEGORYNAME_EN IS NOT NULL
- 47 AND B.CNT > 0
- 48 ORDER BY PCC.N_FIRESTCATEID ASC,
- 49 PCC.N_SECONDCATEID ASC,
- 50 PCC.SI_SORT ASC;
-
-
-
- 514 rows selected.
- Execution Plan
- ----------------------------------------------------------
- Plan hash value: 1864691228
- ---------------------------------------------------------------------------------------------------------------------------------
- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
- ---------------------------------------------------------------------------------------------------------------------------------
- | 0 | SELECT STATEMENT | | 1 | 59 | 1877 (2)| 00:00:01 |
- | 1 | SORT ORDER BY | | 1 | 59 | 1877 (2)| 00:00:01 |
- | 2 | NESTED LOOPS | | | | | |
- | 3 | NESTED LOOPS | | 1 | 59 | 1876 (2)| 00:00:01 |
- | 4 | VIEW | | 1 | 16 | 1875 (2)| 00:00:01 |
- |* 5 | FILTER | | | | | |
- | 6 | HASH GROUP BY | | 1 | 16 | 1875 (2)| 00:00:01 |
- | 7 | VIEW | | 139 | 2224 | 1875 (2)| 00:00:01 |
- | 8 | HASH UNIQUE | | 139 | 11676 | 1875 (2)| 00:00:01 |
- |* 9 | FILTER | | | | | |
- |* 10 | HASH JOIN OUTER | | 139 | 11676 | 1874 (2)| 00:00:01 |
- |* 11 | HASH JOIN | | 277 | 22160 | 1864 (1)| 00:00:01 |
- | 12 | MERGE JOIN | | 236 | 16992 | 1382 (2)| 00:00:01 |
- | 13 | SORT JOIN | | 236 | 9912 | 1002 (2)| 00:00:01 |
- |* 14 | HASH JOIN | | 236 | 9912 | 1001 (1)| 00:00:01 |
- | 15 | NESTED LOOPS | | | | | |
- | 16 | NESTED LOOPS | | 1153 | 31131 | 655 (1)| 00:00:01 |
- | 17 | MERGE JOIN OUTER | | 46 | 828 | 109 (2)| 00:00:01 |
- | 18 | SORT JOIN | | 7 | 84 | 6 (17)| 00:00:01 |
- |* 19 | TABLE ACCESS BY INDEX ROWID | TCATEGORY | 7 | 84 | 5 (0)| 00:00:01 |
- |* 20 | INDEX RANGE SCAN | IDEX_N_THIRDCATEID | 7 | | 1 (0)| 00:00:01 |
- |* 21 | SORT JOIN | | 2159 | 12954 | 103 (1)| 00:00:01 |
- | 22 | TABLE ACCESS FULL | TCATEGORY | 2159 | 12954 | 102 (0)| 00:00:01 |
- | 23 | BITMAP CONVERSION TO ROWIDS | | | | | |
- | 24 | BITMAP OR | | | | | |
- | 25 | BITMAP CONVERSION FROM ROWIDS| | | | | |
- |* 26 | INDEX RANGE SCAN | IDX_TPROCATMAPPING_CATEGORYID | | | 1 (0)| 00:00:01 |
- | 27 | BITMAP CONVERSION FROM ROWIDS| | | | | |
- |* 28 | INDEX RANGE SCAN | IDX_TPROCATMAPPING_CATEGORYID | | | 1 (0)| 00:00:01 |
- |* 29 | TABLE ACCESS BY INDEX ROWID | TPROCATMAPPING | 25 | 225 | 655 (1)| 00:00:01 |
- |* 30 | TABLE ACCESS FULL | TPRODUCTPRICE | 4162 | 62430 | 345 (1)| 00:00:01 |
- |* 31 | SORT JOIN | | 13374 | 391K| 380 (2)| 00:00:01 |
- |* 32 | TABLE ACCESS FULL | TPRODUCTBRIEF | 13374 | 391K| 379 (1)| 00:00:01 |
- |* 33 | TABLE ACCESS FULL | TBARCODE | 23223 | 181K| 481 (1)| 00:00:01 |
- | 34 | TABLE ACCESS FULL | TBRAND | 1835 | 7340 | 9 (0)| 00:00:01 |
- |* 35 | INDEX UNIQUE SCAN | PK_TCATEGORY | 1 | | 0 (0)| 00:00:01 |
- |* 36 | TABLE ACCESS BY INDEX ROWID | TCATEGORY | 1 | 43 | 1 (0)| 00:00:01 |
- ---------------------------------------------------------------------------------------------------------------------------------
- Predicate Information (identified by operation id):
- ---------------------------------------------------
- 5 - filter(COUNT("A"."N_SKUID")>0)
- 9 - filter(NVL("BRA"."B_ISDELETE",'0')='0')
- 10 - access("BRA"."SEQ_ID"(+)=TO_NUMBER("BRI"."N_BRANDID"))
- 11 - access("PRI"."N_SKUID"="BAR"."N_PRODUCT_CODE")
- 14 - access("PMC"."N_PRODUCTID"="PRI"."N_SKUID")
- 19 - filter("CAT"."N_FIRESTCATEID">0 AND "CAT"."N_SECONDCATEID">0)
- 20 - access("CAT"."N_THIRDCATEID"=0)
- 21 - access("CAT"."SEQ_ID"="CAT2"."N_THIRDCATEID"(+))
- filter("CAT"."SEQ_ID"="CAT2"."N_THIRDCATEID"(+))
- 26 - access("CAT2"."SEQ_ID"="PMC"."N_CATEGORYID")
- 28 - access("CAT"."SEQ_ID"="PMC"."N_CATEGORYID")
- 29 - filter("CAT2"."SEQ_ID"="PMC"."N_CATEGORYID" OR "CAT"."SEQ_ID"="PMC"."N_CATEGORYID")
- 30 - filter("PRI"."N_SHOPID"=103 AND ("PRI"."SI_STATUS"=2 OR "PRI"."SI_STATUS"=4) AND "PRI"."SI_RTSTATUS"<>8 AND
- "PRI"."SI_RTSTATUS"<>9 AND "PRI"."B_ISDELETE"='0' AND "PRI"."N_PRICE">0)
- 31 - access("PRI"."N_SKUID"="BRI"."SEQ_ID")
- filter("PRI"."N_SKUID"="BRI"."SEQ_ID")
- 32 - filter("BRI"."C_ISIMAGE" IS NOT NULL AND "BRI"."B_ISDELETE"='0')
- 33 - filter("BAR"."N_SHOPID"=103 AND NVL("BAR"."B_ISDELETE",'0')='0')
- 35 - access("PCC"."SEQ_ID"="B"."SEQ_ID")
- 36 - filter("PCC"."N_THIRDCATEID"=0 AND "PCC"."N_FIRESTCATEID">0 AND "PCC"."N_SECONDCATEID">0 AND
- "PCC"."NC_CATEGORYNAME" IS NOT NULL AND "PCC"."NC_CATEGORYNAME_EN" IS NOT NULL)
- Statistics
- ----------------------------------------------------------
- 0 recursive calls
- 0 db block gets
- 11368 consistent gets
- 0 physical reads
- 0 redo size
- 30138 bytes sent via SQL*Net to client
- 898 bytes received via SQL*Net from client
- 36 SQL*Net roundtrips to/from client
- 1 sorts (memory)
- 0 sorts (disk)
- 514 rows processed
复制代码 |
|