oracle 回滚段,死锁和回滚段 - Oracle数据库管理 - ITPUB论坛－中国专业的IT技术社区...

最近程序人员修改了程序后，系统中发现有死锁，但是死锁发生的

时候有时oracle自动回滚其中一个交易就没事了，但是有的时候

oracle确要使用很多回滚段，这个时候创建回滚段占用了大量系统资源导致大量ora-12571错误。请问一下，oracle为什么会在发生死锁的时候需要那么多的回滚段呢，如下alert.log

ORA-000060: Deadlock detected. More info in file d:\oracle\admin\dyhis\udump\dyhis_ora_2964.trc.

Sat May 28 09:20:16 2005

Undo Segment 13 Onlined

Sat May 28 09:20:16 2005

Undo Segment 14 Onlined

Sat May 28 09:20:16 2005

Undo Segment 15 Onlined

Sat May 28 09:20:16 2005

Undo Segment 16 Onlined

Sat May 28 09:20:16 2005

Undo Segment 17 Onlined

Sat May 28 09:20:17 2005

Undo Segment 18 Onlined

Sat May 28 09:20:17 2005

Undo Segment 19 Onlined

Sat May 28 09:20:17 2005

ARC1: Completed archiving  log 1 thread 1 sequence 3209

Sat May 28 09:20:17 2005

Undo Segment 20 Onlined

Sat May 28 09:20:17 2005

Undo Segment 21 Onlined

Sat May 28 09:20:17 2005

Undo Segment 22 Onlined

Sat May 28 09:20:17 2005

Undo Segment 23 Onlined

Sat May 28 09:20:17 2005

Undo Segment 24 Onlined

Sat May 28 09:20:17 2005

Undo Segment 25 Onlined

Sat May 28 09:20:17 2005

Undo Segment 27 Onlined

Sat May 28 09:20:17 2005

Undo Segment 28 Onlined

Sat May 28 09:20:18 2005

Undo Segment 29 Onlined

Sat May 28 09:20:18 2005

Undo Segment 30 Onlined

Sat May 28 09:20:18 2005

Undo Segment 31 Onlined

Sat May 28 09:20:18 2005

Undo Segment 32 Onlined

Sat May 28 09:20:18 2005

Undo Segment 33 Onlined

Sat May 28 09:20:18 2005

Undo Segment 34 Onlined

Sat May 28 09:20:18 2005

Undo Segment 35 Onlined

Sat May 28 09:20:18 2005

Undo Segment 36 Onlined

Sat May 28 09:20:18 2005

Undo Segment 37 Onlined

Sat May 28 09:20:18 2005

Undo Segment 38 Onlined

Sat May 28 09:20:18 2005

Undo Segment 39 Onlined

Sat May 28 09:20:18 2005

Undo Segment 40 Onlined

Sat May 28 09:20:18 2005

Undo Segment 41 Onlined

Sat May 28 09:20:19 2005

Undo Segment 42 Onlined

Sat May 28 09:20:19 2005

Undo Segment 43 Onlined

Sat May 28 09:20:19 2005

Undo Segment 26 Onlined

Sat May 28 09:20:19 2005

Undo Segment 44 Onlined

Sat May 28 09:20:19 2005

Errors in file d:\oracle\admin\dyhis\udump\dyhis_ora_2920.trc:

Sat May 28 09:20:19 2005

Errors in file d:\oracle\admin\dyhis\udump\dyhis_ora_2224.trc:

Sat May 28 09:20:19 2005

Errors in file d:\oracle\admin\dyhis\udump\dyhis_ora_216.trc:

Sat May 28 09:20:19 2005

Undo Segment 45 Onlined

Sat May 28 09:20:20 2005

Undo Segment 46 Onlined

Sat May 28 09:20:20 2005

Errors in file d:\oracle\admin\dyhis\udump\dyhis_ora_3332.trc:

Sat May 28 09:20:20 2005

Errors in file d:\oracle\admin\dyhis\udump\dyhis_ora_3532.trc:

Sat May 28 09:20:20 2005

Errors in file d:\oracle\admin\dyhis\udump\dyhis_ora_2432.trc:

Sat May 28 09:20:20 2005

Undo Segment 47 Onlined

Sat May 28 09:20:20 2005

Errors in file d:\oracle\admin\dyhis\udump\dyhis_ora_3256.trc:

Sat May 28 09:20:20 2005

Undo Segment 48 Onlined

Sat May 28 09:20:20 2005

Undo Segment 49 Onlined

Sat May 28 09:20:20 2005

Undo Segment 50 Onlined

Sat May 28 09:20:20 2005

Undo Segment 51 Onlined