|
|
这是我们生产库的一段statspack
Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 99.81 In-memory Sort %: 99.97
Library Hit %: 99.78 Soft Parse %: 99.00
Execute to Parse %: 7.44 Latch Hit %: 99.67
Parse CPU to Parse Elapsd %: 88.05 % Non-Parse CPU: 87.25
Shared Pool Statistics Begin End
------ ------
Memory Usage %: 63.11 65.86
% SQL with executions>1: 69.38 68.76
% Memory for SQL w/exec>1: 81.51 80.52
Top 5 Timed Events
~~~~~~~~~~~~~~~~~~ % Total
Event Waits Time (s) Ela Time
-------------------------------------------- ------------ ----------- --------
PX qref latch 7,438 7,306 40.32
PX Deq: Execute Reply 167,381 4,625 25.52
PX Deq: Parse Reply 28,507 2,635 14.54
PX Deq: Signal ACK 60,064 1,573 8.68
CPU time 1,544 8.52
Execute to Parse %: 7.44 吓我一跳啊。
首先 我们的应用正确地使用了bind var.这个我可以肯定. |
|