Is there any idea in this kind of use of rollback ?
I'll answer this one first. It's typically a hangover from applications or developers that have been based on other database vendors, where a *read* takes a lock on the table blocks affected.
Hence the "standard" coding process becomes:
- run query
- do a commit (or a rollback)
- run query
- do a commit (or a rollback)
"If in doubt, run a commit"
Is there any way to find out, if rollbacks are actually doing some undo operation ?
'rollback changes - undo records applied' is a useful statistic here.