Statspack ratios help
- From: "Sandeep Dubey" <dubey.sandeep@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 6 Jun 2006 14:05:07 -0400
Hi,
I am running OLTP system on Oracle 10.2 and J2EE weblogic.
I am getting some ratios as:
Load Profile Per Second Per Transaction
~~~~~~~~~~~~ --------------- ---------------
Redo size: 156,162.18 3,020.55
Logical reads: 26,407.64 510.79
Block changes: 904.27 17.49
Physical reads: 0.39 0.01
Physical writes: 34.01 0.66
User calls: 5,863.32 113.41
Parses: 981.47 18.98
Hard parses: 0.01 0.00
Sorts: 16.97 0.33
Logons: 5.54 0.11
Executes: 1,085.95 21.00
Transactions: 51.70
Rollback per transaction %: 44.17
Buffer Nowait %: 100.00 Redo NoWait %: 99.97
Buffer Hit %: 100.00 In-memory Sort %: 100.00
Library Hit %: 100.00 Soft Parse %: 100.00
Execute to Parse %: 9.62 Latch Hit %: 99.88
Parse CPU to Parse Elapsd %: 69.06 % Non-Parse CPU: 91.60
With 100% soft parse, execute to parse ratio is so low. Is it bad, how
I can I improve it?
I see rollback per transaction as 44.17. We are using Hibernate that
generates database mapping and produces most of the SQLs. How can I
invetigate further? But I doubt if application is doing some big time
rollbacks.
Thanks for help
Sandeep
--
//www.freelists.org/webpage/oracle-l
Other related posts:
