Hi Tom
Your website is a great resource to us. Thank you.
Following is the statspack report ran during performance testing to see how many orders can be processed in an hour.

(Parse CPU to Parse Elapsd %: 35.71 ) is the concern to me. Our application uses bind variables. you could see Execute to Parse %: 98.75 which I belive is not too bad.
Could you advise why would be Parse CPU to Parse Elapsd is such low ?
DO you think there is still place to improve bind variables.
Thanks for your help.



Instance Efficiency Percentages
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 99.99 Redo NoWait %: 100.00
Buffer Hit %: 100.00 In-memory Sort %: 100.00
Library Hit %: 99.99 Soft Parse %: 99.44
Execute to Parse %: 98.75 Latch Hit %: 99.93
Parse CPU to Parse Elapsd %: 35.71 % Non-Parse CPU: 99.89





STATSPACK report for

Database DB Id Instance Inst Num Startup Time Release RAC
~~~~~~~~ ----------- ------------ -------- --------------- ----------- ---
1507337700 XXX 1 27-Jul-06 09:40 10.2.0.1.0 NO

Host Name: xxxx Num CPUs: 16 Phys Memory (MB): 15,680
~~~~

Snapshot Snap Id Snap Time Sessions Curs/Sess Comment
~~~~~~~~ ---------- ------------------ -------- --------- -------------------
Begin Snap: 178 28-Jul-06 15:37:32 34 54.3
End Snap: 179 28-Jul-06 15:48:47 34 55.3
Elapsed: 11.25 (mins)

Cache Sizes Begin End
~~~~~~~~~~~ ---------- ----------
Buffer Cache: 3,824M Std Block Size: 8K
Shared Pool Size: 816M Log Buffer: 13,963K

Load Profile Per Second Per Transaction
~~~~~~~~~~~~ --------------- ---------------
Redo size: 424,946.86 1,388.19
Logical reads: 26,998.76 88.20
Block changes: 3,740.63 12.22
Physical reads: 0.06 0.00
Physical writes: 24.95 0.08
User calls: 3,228.74 10.55
Parses: 25.29 0.08
Hard parses: 0.14 0.00
Sorts: 712.57 2.33
Logons: 0.03 0.00
Executes: 2,019.49 6.60
Transactions: 306.12

% Blocks changed per Read: 13.85 Recursive Call %: 44.47
Rollback per transaction %: 0.00 Rows per Sort: 48.31

Instance Efficiency Percentages
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 99.99 Redo NoWait %: 100.00
Buffer Hit %: 100.00 In-memory Sort %: 100.00
Library Hit %: 99.99 Soft Parse %: 99.44
Execute to Parse %: 98.75 Latch Hit %: 99.93
Parse CPU to Parse Elapsd %: 35.71 % Non-Parse CPU: 99.89

Shared Pool Statistics Begin End
------ ------
Memory Usage %: 34.20 34.45
% SQL with executions>1: 49.37 49.92
% Memory for SQL w/exec>1: 61.51 62.93

Top 5 Timed Events Avg %Total
~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time
----------------------------------------- ------------ ----------- ------ ------
CPU time 267 55.6
log file sync 191,265 108 1 22.4
log file parallel write 203,240 102 1 21.1
db file parallel write 1,884 2 1 .5
os thread startup 10 1 83 .2
-------------------------------------------------------------
Host CPU (CPUs: 16)
~~~~~~~~ Load Average
Begin End User System Idle WIO WCPU
------- ------- ------- ------- ------- ------- --------
0.00 0.00 5.76 1.44 92.80 0.76 6.45

Instance CPU
~~~~~~~~~~~~
% of total CPU for Instance: 6.00
% of busy CPU for Instance: 83.34
%DB time waiting for CPU - Resource Mgr:

Memory Statistics Begin End
~~~~~~~~~~~~~~~~~ ------------ ------------
Host Mem (MB): 15,680.0 15,680.0
SGA use (MB): 4,688.0 4,688.0
PGA use (MB): 130.9 129.4
% Host Mem used for SGA+PGA: 30.7 30.7
-------------------------------------------------------------

Time Model System Stats DB/Inst: AAD/AAD Snaps: 178-179
-> Ordered by % of DB time desc, Statistic name

Statistic Time (s) % of DB time
----------------------------------- -------------------- ------------
DB CPU 633.4 96.2
sql execute elapsed time 498.2 75.7
sequence load elapsed time 6.6 1.0
PL/SQL execution elapsed time 5.7 .9
parse time elapsed 1.4 .2
repeated bind elapsed time 0.9 .1
hard parse elapsed time 0.7 .1
hard parse (sharing criteria) elaps 0.6 .1
PL/SQL compilation elapsed time 0.1 .0
failed parse elapsed time 0.1 .0
connection management call elapsed 0.0 .0
DB time 658.3
background elapsed time 116.6
background cpu time 14.8
-------------------------------------------------------------
Wait Events DB/Inst: AAD/AAD Snaps: 178-179
-> s - second, cs - centisecond, ms - millisecond, us - microsecond
-> %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
-> Only events with Total Wait Time (s) >= .001 are shown
-> ordered by Total Wait Time desc, Waits desc (idle events last)