I have been reviewing Oracle Statspack reports generated in our SAP R/3 database and one of the statistics that jumped out at me is a very high Rollback per Transaction percent of over 45%. I support other non-SAP Oracle databases and have never seen anything like this. I am somewhat new to SAP and realize this might be normal (??), but this leads me to be concerned about what is happening in the environment. My question is..... Is this normal in an SAP Oracle database and if so why? Or is this truely a problem that needs serious further analysis?
We are running Oracle 22.214.171.124 on a 16-way Sun server. The Oracle load profile looks something like this:
Logical Reads (100,000/s)
Physical Reads (2,100/s)
Physical Writes (550/s)
RollBack per Transaction % (45%)