oracle rac 变慢,新迁移到p595 10gRAC慢啊~求指教 - Oracle数据库管理 - Oracle数据库数据恢复、性能优化来问问AskMaclean - ParnassusData...

新库使用时间：104秒

执行计划：

10:26:30 SQL> select * from tb_proc_perf t where t.createdate between '20130501140427' and '20130531140427';

Execution Plan

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

Plan hash value: 16178747

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

| Id  | Operation         | Name         | Rows  | Bytes | Cost (%CPU)| Time     |

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

|   0 | SELECT STATEMENT  |              |    61 |  3111 |   160K  (2)| 00:32:08 |

|*  1 |  TABLE ACCESS FULL| TB_PROC_PERF |    61 |  3111 |   160K  (2)| 00:32:08 |

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

Predicate Information (identified by operation id):

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

1 - filter("T"."CREATEDATE"<='20130531140427' AND

"T"."CREATEDATE">='20130501140427')

Statistics

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

457  recursive calls

0  db block gets

719311  consistent gets

552739  physical reads

116  redo size

906  bytes sent via SQL*Net to client

481  bytes received via SQL*Net from client

1  SQL*Net roundtrips to/from client

5  sorts (memory)

0  sorts (disk)

0  rows processed

10:28:14 SQL>

老库时间：27秒

执行计划：

10:23:29 SQL> select * from tb_proc_perf t where t.createdate between '20130501140427' and '20130531140427';

no rows selected

Execution Plan

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

Plan hash value: 373438921

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

| Id  | Operation         | Name         | Rows  | Bytes | Cost (%CPU)| Time     |

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

|   0 | SELECT STATEMENT  |              |    63 |  3213 |   214K  (3)| 00:42:51 |

|*  1 |  TABLE ACCESS FULL| TB_PROC_PERF |    63 |  3213 |   214K  (3)| 00:42:51 |

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

Predicate Information (identified by operation id):

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

1 - filter("T"."CREATEDATE"<='20130531140427' AND

"T"."CREATEDATE">='20130501140427')

Statistics

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

1  recursive calls

2  db block gets

1067846  consistent gets

851603  physical reads

176  redo size

906  bytes sent via SQL*Net to client

481  bytes received via SQL*Net from client

1  SQL*Net roundtrips to/from client

0  sorts (memory)

0  sorts (disk)

0  rows processed

10:23:56 SQL>