How to find out which transactions are being rollbacked?
Hi all,
a recent application connected to our database (10.2.0.5) has started to cause excessive rollbacks. I have tracked it down to a specific user with the query;:
select se.username,sum(s.value) from v$sesstat s, v$session se where statistic# in(5) and s.sid=se.sid group by se.username (statistic# 5=user rollback)
where I can se the growth of rollbacks in sizes of 500-1000 per second.
Is there any way I can find which queries are being rollbacked? I hade a brief look into the auditing of tables, but I was unable to distinguish the rollbacked queris from the committed... (but I am no expert, the info might be there anyway...)
a recent application connected to our database (10.2.0.5) has started to cause excessive rollbacks. I have tracked it down to a specific user with the query;:
select se.username,sum(s.value) from v$sesstat s, v$session se where statistic# in(5) and s.sid=se.sid group by se.username (statistic# 5=user rollback)
where I can se the growth of rollbacks in sizes of 500-1000 per second.
Is there any way I can find which queries are being rollbacked? I hade a brief look into the auditing of tables, but I was unable to distinguish the rollbacked queris from the committed... (but I am no expert, the info might be there anyway...)
0