在awr里的统计出来的信息：

Reads              CPU     Elapsed

Physical Reads  Executions    per Exec   %Total Time (s)  Time (s)    SQL Id

-------------- ----------- ------------- ------ -------- --------- -------------

1,245,793          18      69,210.7    4.6   293.41    866.86 6ujbj8ysd8vh8

Module: JDBC Thin Client

SELECT COUNT(*) FROM O_W_PERF_TRUNKGROUP WHERE local_ne_id = :1 AND START_TIME

= :2 AND STOP_TIME = :3

但是在sqlplus里：

1  SELECT COUNT(*)

2    FROM O_W_PERF_TRUNKGROUP

3   WHERE local_ne_id = '3004000000000000' and

4         START_TIME >= '2010-12-13 20:00:00' AND

5*        STOP_TIME <= '2010-12-13 21:00:00'

SQL> /

COUNT(*)

----------

0

Execution Plan

----------------------------------------------------------

0      SELECT STATEMENT Optimizer=ALL_ROWS (Cost=164 Card=1 Bytes=3

3)

1    0   SORT (AGGREGATE)

2    1     TABLE ACCESS (BY INDEX ROWID) OF 'O_W_PERF_TRUNKGROUP' (

TABLE) (Cost=164 Card=125 Bytes=4125)

3    2       INDEX (RANGE SCAN) OF 'IDX_O_W_PERF_TRUNKGROUP' (INDEX

(UNIQUE)) (Cost=7 Card=565)

Statistics

----------------------------------------------------------

0  recursive calls

0  db block gets

357  consistent gets

0  physical reads

0  redo size

519  bytes sent via SQL*Net to client

616  bytes received via SQL*Net from client

2  SQL*Net roundtrips to/from client

0  sorts (memory)

0  sorts (disk)

1  rows processed

SQL>

是用到了索引的，这是为什么？不解。

oracle版本10.2.0.1.0 ，是不是sga_target设置小了，当前设置的是6000m；

[本帖最后由 lutheran 于 2010-12-17 11:53 编辑]