目前卡住的id > 3803899633 and id <= 3803942605 的执行计划
54 rows selected.
Execution Plan
----------------------------------------------------------
Plan hash value: 2894523647
--------------------------------------------------------------------------------
------------------------
| Id | Operation | Name | Rows | Bytes |
Cost (%CPU)| Time |
--------------------------------------------------------------------------------
------------------------
| 0 | SELECT STATEMENT | | 1 | 183 |
11 (19)| 00:00:01 |
| 1 | SEQUENCE | SEQ_DATA | | |
| |
| 2 | TABLE ACCESS BY INDEX ROWID | T_SIGNATURE | 1 | 14 |
2 (0)| 00:00:01 |
| 3 | NESTED LOOPS | | 1 | 183 |
11 (19)| 00:00:01 |
| 4 | VIEW | | 1 | 169 |
9 (23)| 00:00:01 |
| 5 | HASH GROUP BY | | 1 | 73 |
9 (23)| 00:00:01 |
|* 6 | TABLE ACCESS BY INDEX ROWID| T_LOG | 1 | 65 |
4 (0)| 00:00:01 |
| 7 | NESTED LOOPS | | 1 | 73 |
8 (13)| 00:00:01 |
| 8 | SORT UNIQUE | | 99 | 792 |
3 (0)| 00:00:01 |
| 9 | TABLE ACCESS FULL | T_INFO | 99 | 792 |
3 (0)| 00:00:01 |
|* 10 | INDEX RANGE SCAN | SYS_C005376 | 1 | |
3 (0)| 00:00:01 |
|* 11 | INDEX RANGE SCAN | IDX_SID_T_SIG | 1 | |
1 (0)| 00:00:01 |
--------------------------------------------------------------------------------
------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
6 - filter("DST_IP"="IP")
10 - access("ID">3803899633 AND "ID"<=3803942605)
11 - access("A"."SID"="B"."SID")
Statistics
----------------------------------------------------------
87 recursive calls
19 db block gets
2907 consistent gets
12 physical reads
3888 redo size
5228 bytes sent via SQL*Net to client
502 bytes received via SQL*Net from client
5 SQL*Net roundtrips to/from client
1 sorts (memory)
0 sorts (disk)
54 rows processed
[本帖最后由 xrjrunning 于 2010-9-8 17:21 编辑]