日期:2014-05-16  浏览次数:20785 次

在线等待高手解答,latch: cache buffers chains事件怎么解决!
1	SQL_ID  6s7jtnzrmmuw1, child number 0
2 -------------------------------------
3 insert  /*+ append */  into qianyi.WEB_APP_BASE select * from V_WEB_APP_BASE
4  
5 Plan hash value: 843235207
6  
7 ------------------------------------------------------------------------
8 | Id  | Operation                       | Name             | Rows  | Bytes |TempSpc| Cost (%CPU)| Time     |
9 ------------------------------------------------------------------------
10 |   0 | INSERT STATEMENT                |                  |       |       |       | 16714 (100)|          |
11 |   1 |  LOAD AS SELECT                 |                  |       |       |       |            |          |
12 |   2 |   VIEW                          | V_WEB_APP_BASE   | 50001 |  1035M|       | 16714   (2)| 00:01:54 |
13 |   3 |    UNION-ALL                    |                  |       |       |       |            |          |
14 |   4 |     NESTED LOOPS                |                  |     1 |   707 |       |     4   (0)| 00:00:01 |
15 |   5 |      TABLE ACCESS FULL          | T_PLY_BASE_TRANS |     1 |    38 |       |     2   (0)| 00:00:01 |
16 |   6 |      TABLE ACCESS BY INDEX ROWID| T_PLY_BASE       |     1