Oracle 并发回滚

最新推荐文章于 2024-05-20 20:26:39 发布

cqr0591

最新推荐文章于 2024-05-20 20:26:39 发布

阅读量214

点赞数

文章标签：数据库

问题描述：

数据库突然出现大量的回滚进程。

问题分析：

从v$session中看到操作的对象是TAB1及表上的索引。但是为什么会使用并发来回滚呢？

查询视图v$fast_start_transactions

点击(此处)折叠或打开

select usn,slt,seq,state,undoblockstotal,undoblocksdone,xid,rcvservers from v$fast_start_transactions;
USN SLT SEQ STATE UNDOBLOCKSTOTAL UNDOBLOCKSDONE XID RCVSERVERS
---------- ---------- ---------- ---------------- --------------- -------------- ---------------- ----------
34 24 5044735 RECOVERED 40861 40861 00220018004CF9FF 256
45 26 2937596 RECOVERED 40862 40862 002D001A002CD2FC 256
45 7 2935629 RECOVERED 40861 40861 002D0007002CCB4D 256
46 14 2594590 RECOVERED 60436 60436 002E000E0027971E 256
15 19 3116186 RECOVERED 40863 40863 000F0013002F8C9A 256
48 9 1713657 RECOVERED 29744 29744 00300009001A25F9 256
16 44 3088013 RECOVERED 16098 16098 0010002C002F1E8D 256
39 25 5180630 RECOVERED 18 18 00270019004F0CD6 1
39 42 5314292 RECOVERED 40861 40861 0027002A005116F4 256
7 21 3077967 RECOVERED 40862 40862 00070015002EF74F 256
42 24 3950504 RECOVERED 40861 40861 002A0018003C47A8 256
43 11 3892882 RECOVERED 40862 40862 002B000B003B6692 256
21 23 3309555 RECOVERED 112751 112751 0015001700327FF3 256
10 38 3186672 RECOVERED 29632 29632 000A002600309FF0 256
14 rows selected.