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.
