| 2 | INDEX RANGE SCAN | PK_USER_TO_CHANNEL | 34 | 272 |
2 |
| 3 | TABLE ACCESS BY INDEX ROWID| PUB_CHANNEL | 1 | 36 |
1 |
| 4 | INDEX UNIQUE SCAN | PK_CHANNEL | 1 | |
0 |
--------------------------------------------------------------------------------
---
Note
-----
- 'PLAN_TABLE' is old version
Statistics
----------------------------------------------------------
1 recursive calls
0 db block gets
77 consistent gets
0 physical reads
0 redo size
2273 bytes sent via SQL*Net to client
514 bytes received via SQL*Net from client
4 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
33 rows processed
SQL>
结论:还是由于sql的质量比较差导致的逻辑读比较多。
此时的逻辑读=consistent gets+db block gets=77
感慨:原因虽然找到了,在一个线上系统查找该sql很困难,总之在一个线上系统做点调整真难。
责任编辑:小草