oracle的事务的停止方法,诡异的进程kill掉后undo不释放该事务，无法回滚。（已解决）...

最新推荐文章于 2023-07-13 15:26:36 发布
最新推荐文章于 2023-07-13 15:26:36 发布
阅读量496 收藏
点赞数
文章标签： oracle的事务的停止方法

本帖最后由 jieyancai 于 2015-3-14 11:26 编辑

续dump文件：

*-----------------------------

* Rec #0x1a  slt: 0x0a  objn: 4292894(0x0041811e)  objd: 4293319  tblspc: 8(0x00000008)

*       Layer:  10 (Index)   opc: 22   rci 0x19

Undo type:  Regular undo   Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

index undo for leaf key operations

KTB Redo

op: 0x02  ver: 0x01

op: C  uba: 0x0084d40a.0ef6.2b

Dump kdilk : itl=2, kdxlkflg=0x1 sdc=1 indexid=0x3635ce3 block=0x04cbc15b

restore leaf row (clear leaf delete flags)

key :(34):

1a bb aa ce aa a3 a8 b6 ab cb c4 a3 a9 5f bd a8 cd e2 53 4f 48 4f 28 4e 47

4e 29 06 04 c7 53 c8 00 01

*-----------------------------

* Rec #0x1b  slt: 0x0a  objn: 4292894(0x0041811e)  objd: 4293319  tblspc: 8(0x00000008)

*       Layer:  10 (Index)   opc: 22   rci 0x1a

Undo type:  Regular undo   Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

index undo for leaf key operations

KTB Redo

op: 0x02  ver: 0x01

op: C  uba: 0x0084d40a.0ef6.2c

Dump kdilk : itl=2, kdxlkflg=0x1 sdc=2 indexid=0x3635ce3 block=0x05a1b56b

purge leaf row

key :(34):

1a bb aa ce aa a3 a8 b6 ab cb c4 a3 a9 5f b1 b1 cc ab c6 bd d7 af 28 4e 47

4e 29 06 04 c7 53 c8 00 01

*-----------------------------

* Rec #0x1c  slt: 0x0a  objn: 4292902(0x00418126)  objd: 4293312  tblspc: 8(0x00000008)

*       Layer:  10 (Index)   opc: 22   rci 0x1b

Undo type:  Regular undo   Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

index undo for leaf key operations

KTB Redo

op: 0x02  ver: 0x01

op: C  uba: 0x0084d405.0ef6.3c

Dump kdilk : itl=2, kdxlkflg=0x1 sdc=1 indexid=0x41590cb block=0x04cba52b

restore leaf row (clear leaf delete flags)

key :(25):

06 d2 d1 cd cb bb d8 08 bd a8 cd e2 53 4f 48 4f 01 4e 06 04 c7 53 c8 00 01

*-----------------------------

* Rec #0x1d  slt: 0x0a  objn: 4292902(0x00418126)  objd: 4293312  tblspc: 8(0x00000008)

*       Layer:  10 (Index)   opc: 22   rci 0x1c

Undo type:  Regular undo   Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

index undo for leaf key operations

KTB Redo

op: 0x02  ver: 0x01

op: C  uba: 0x0084d405.0ef6.44

Dump kdilk : itl=2, kdxlkflg=0x1 sdc=2 indexid=0x41590cb block=0x054aa5a3

purge leaf row

key :(25):

06 d2 d1 cd cb bb d8 08 b1 b1 cc ab c6 bd d7 af 01 4e 06 04 c7 53 c8 00 01

*-----------------------------

* Rec #0x1e  slt: 0x0a  objn: 4909866(0x004aeb2a)  objd: 4909866  tblspc: 8(0x00000008)

*       Layer:  10 (Index)   opc: 22   rci 0x1d

Undo type:  Regular undo   Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

index undo for leaf key operations

KTB Redo

op: 0x02  ver: 0x01

op: C  uba: 0x0084d40a.0ef6.2f

Dump kdilk : itl=2, kdxlkflg=0x1 sdc=0 indexid=0x4a4fd03 block=0x0511fe0b

restore leaf row (clear leaf delete flags)

key :(16):  08 bd a8 cd e2 53 4f 48 4f 06 04 c7 53 c8 00 01

*-----------------------------

* Rec #0x1f  slt: 0x0a  objn: 4909866(0x004aeb2a)  objd: 4909866  tblspc: 8(0x00000008)

*       Layer:  10 (Index)   opc: 22   rci 0x1e

Undo type:  Regular undo   Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

index undo for leaf key operations

KTB Redo

op: 0x02  ver: 0x01

op: C  uba: 0x0084d405.0ef6.3f

Dump kdilk : itl=2, kdxlkflg=0x1 sdc=2 indexid=0x4a4fd03 block=0x0511fd9a

purge leaf row

key :(16):  08 b1 b1 cc ab c6 bd d7 af 06 04 c7 53 c8 00 01

*-----------------------------

* Rec #0x20  slt: 0x0a  objn: 4292867(0x00418103)  objd: 4293151  tblspc: 8(0x00000008)

*       Layer:  11 (Row)   opc: 1   rci 0x1f

Undo type:  Regular undo   Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

KDO undo record:

KTB Redo

op: 0x04  ver: 0x01

op: L  itl: xid:  0x0004.018.000c87ea uba: 0x00805e13.857b.46

flg: C---    lkc:  0     scn: 0x0b06.d74a3369

KDO Op code: URP row dependencies Disabled

xtype: XA  bdba: 0x04646e77  hdba: 0x0413f7e3

itli: 3  ispac: 0  maxfr: 4858

tabn: 0 slot: 4(0x4) flag: 0x2c lock: 0 ckix: 0

ncol: 234 nnew: 2 size: 0

col 41: [26]

bb aa ce aa a3 a8 b6 ab cb c4 a3 a9 5f bd a8 cd e2 53 4f 48 4f 28 4e 47 4e

29

col 42: [ 8]  bd a8 cd e2 53 4f 48 4f

*-----------------------------

* Rec #0x21  slt: 0x0a  objn: 4292895(0x0041811f)  objd: 4293320  tblspc: 8(0x00000008)

*       Layer:  10 (Index)   opc: 22   rci 0x20

Undo type:  Regular undo   Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

index undo for leaf key operations

KTB Redo

op: 0x04  ver: 0x01

op: L  itl: xid:  0x0001.020.00347010 uba: 0x008ffcfb.ca78.01

flg: C-U-    lkc:  0     scn: 0x0b06.b7f1e165

Dump kdilk : itl=2, kdxlkflg=0x1 sdc=1 indexid=0x3635ceb block=0x04667afa

restore leaf row (clear leaf delete flags)

key :(34):

1a bb aa ce aa a3 a8 b6 ab cb c4 a3 a9 5f bd a8 cd e2 53 4f 48 4f 28 4e 47

4e 29 06 04 64 6e 77 00 04

*-----------------------------

* Rec #0x22  slt: 0x0a  objn: 4292895(0x0041811f)  objd: 4293320  tblspc: 8(0x00000008)

*       Layer:  10 (Index)   opc: 22   rci 0x21

Undo type:  Regular undo   Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

index undo for leaf key operations

KTB Redo

op: 0x03  ver: 0x01

op: Z

Dump kdilk : itl=2, kdxlkflg=0x1 sdc=2 indexid=0x3635ceb block=0x0217f7f5

purge leaf row

key :(34):

1a bb aa ce aa a3 a8 b6 ab cb c4 a3 a9 5f b1 b1 cc ab c6 bd d7 af 28 4e 47

4e 29 06 04 64 6e 77 00 04

*-----------------------------

* Rec #0x23  slt: 0x0a  objn: 4292903(0x00418127)  objd: 4293313  tblspc: 8(0x00000008)

*       Layer:  10 (Index)   opc: 22   rci 0x22

Undo type:  Regular undo    User Undo Applied  Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

index undo for leaf key operations

KTB Redo

op: 0x04  ver: 0x01

op: L  itl: xid:  0x0009.009.000bebfc uba: 0x00814ecf.65d0.03

flg: C-U-    lkc:  0     scn: 0x0b06.dc4fa8cf

Dump kdilk : itl=2, kdxlkflg=0x1 sdc=1 indexid=0x41590d3 block=0x04666335

restore leaf row (clear leaf delete flags)

key :(25):

06 d2 d1 cd ea b3 c9 08 bd a8 cd e2 53 4f 48 4f 01 4e 06 04 64 6e 77 00 04

*-----------------------------

* Rec #0x24  slt: 0x0a  objn: 4292903(0x00418127)  objd: 4293313  tblspc: 8(0x00000008)

*       Layer:  10 (Index)   opc: 22   rci 0x23

Undo type:  Regular undo    User Undo Applied  Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

index undo for leaf key operations

KTB Redo

op: 0x04  ver: 0x01

op: L  itl: xid:  0x0009.009.000bebfc uba: 0x0081631c.65d5.03

flg: C-U-    lkc:  0     scn: 0x0b06.dc5fcb96

Dump kdilk : itl=2, kdxlkflg=0x1 sdc=2 indexid=0x41590d3 block=0x054aa962

purge leaf row

key :(25):

06 d2 d1 cd ea b3 c9 08 b1 b1 cc ab c6 bd d7 af 01 4e 06 04 64 6e 77 00 04

*-----------------------------

* Rec #0x25  slt: 0x0a  objn: 4909867(0x004aeb2b)  objd: 4909867  tblspc: 8(0x00000008)

*       Layer:  10 (Index)   opc: 22   rci 0x24

Undo type:  Regular undo    User Undo Applied  Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

index undo for leaf key operations

KTB Redo

op: 0x04  ver: 0x01

op: L  itl: xid:  0x0009.009.000bebfc uba: 0x008101d6.65c1.01

flg: C-U-    lkc:  0     scn: 0x0b06.dc4f9c5d

Dump kdilk : itl=2, kdxlkflg=0x1 sdc=0 indexid=0x4a4fe33 block=0x05120680

restore leaf row (clear leaf delete flags)

key :(16):  08 bd a8 cd e2 53 4f 48 4f 06 04 64 6e 77 00 04

*-----------------------------

* Rec #0x26  slt: 0x0a  objn: 4909867(0x004aeb2b)  objd: 4909867  tblspc: 8(0x00000008)

*       Layer:  10 (Index)   opc: 22   rci 0x25

Undo type:  Regular undo    User Undo Applied  Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

index undo for leaf key operations

KTB Redo

op: 0x04  ver: 0x01

op: L  itl: xid:  0x0009.009.000bebfc uba: 0x00811bf0.65c5.0d

flg: C-U-    lkc:  0     scn: 0x0b06.dc4e77ad

Dump kdilk : itl=2, kdxlkflg=0x1 sdc=2 indexid=0x4a4fe33 block=0x05120050

purge leaf row

key :(16):  08 b1 b1 cc ab c6 bd d7 af 06 04 64 6e 77 00 04

*-----------------------------

* Rec #0x27  slt: 0x0a  objn: 4292867(0x00418103)  objd: 4293151  tblspc: 8(0x00000008)

*       Layer:  11 (Row)   opc: 1   rci 0x26

Undo type:  Regular undo    User Undo Applied  Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

KDO undo record:

KTB Redo

op: 0x03  ver: 0x01

op: Z

KDO Op code: URP row dependencies Disabled

xtype: XA  bdba: 0x04c75def  hdba: 0x0413f7e3

itli: 3  ispac: 0  maxfr: 4858

tabn: 0 slot: 7(0x7) flag: 0x2c lock: 0 ckix: 0

ncol: 234 nnew: 2 size: 0

col 41: [26]

bb aa ce aa a3 a8 b6 ab cb c4 a3 a9 5f bd a8 cd e2 53 4f 48 4f 28 4e 47 4e

29

col 42: [ 8]  bd a8 cd e2 53 4f 48 4f

*-----------------------------

* Rec #0x28  slt: 0x0a  objn: 4292895(0x0041811f)  objd: 4293320  tblspc: 8(0x00000008)

*       Layer:  10 (Index)   opc: 22   rci 0x27

Undo type:  Regular undo    User Undo Applied  Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

index undo for leaf key operations

KTB Redo

op: 0x02  ver: 0x01

op: C  uba: 0x0084d40a.0ef6.40

Dump kdilk : itl=2, kdxlkflg=0x1 sdc=1 indexid=0x3635ceb block=0x04cbcad4

restore leaf row (clear leaf delete flags)

key :(34):

1a bb aa ce aa a3 a8 b6 ab cb c4 a3 a9 5f bd a8 cd e2 53 4f 48 4f 28 4e 47

4e 29 06 04 c7 5d ef 00 07

*-----------------------------

* Rec #0x29  slt: 0x0a  objn: 4292895(0x0041811f)  objd: 4293320  tblspc: 8(0x00000008)

*       Layer:  10 (Index)   opc: 22   rci 0x28

Undo type:  Regular undo    User Undo Applied  Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

index undo for leaf key operations

KTB Redo

op: 0x02  ver: 0x01

op: C  uba: 0x0084d40a.0ef6.3a

Dump kdilk : itl=2, kdxlkflg=0x1 sdc=2 indexid=0x3635ceb block=0x0217f7d5

purge leaf row

key :(34):

1a bb aa ce aa a3 a8 b6 ab cb c4 a3 a9 5f b1 b1 cc ab c6 bd d7 af 28 4e 47

4e 29 06 04 c7 5d ef 00 07

*-----------------------------

* Rec #0x2a  slt: 0x0a  objn: 4292903(0x00418127)  objd: 4293313  tblspc: 8(0x00000008)

*       Layer:  10 (Index)   opc: 22   rci 0x29

Undo type:  Regular undo    User Undo Applied  Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

index undo for leaf key operations

KTB Redo

op: 0x02  ver: 0x01

op: C  uba: 0x0084d40a.0ef6.3b

Dump kdilk : itl=2, kdxlkflg=0x1 sdc=1 indexid=0x41590d3 block=0x046667c1

restore leaf row (clear leaf delete flags)

key :(25):

06 d2 d1 cd ea b3 c9 08 bd a8 cd e2 53 4f 48 4f 01 4e 06 04 c7 5d ef 00 07

*-----------------------------

* Rec #0x2b  slt: 0x0a  objn: 4292903(0x00418127)  objd: 4293313  tblspc: 8(0x00000008)

*       Layer:  10 (Index)   opc: 22   rci 0x2a

Undo type:  Regular undo    User Undo Applied  Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

index undo for leaf key operations

KTB Redo

op: 0x02  ver: 0x01

op: C  uba: 0x0084d40a.0ef6.35

Dump kdilk : itl=2, kdxlkflg=0x1 sdc=2 indexid=0x41590d3 block=0x054aaa15

purge leaf row

key :(25):

06 d2 d1 cd ea b3 c9 08 b1 b1 cc ab c6 bd d7 af 01 4e 06 04 c7 5d ef 00 07

*-----------------------------

* Rec #0x2c  slt: 0x0a  objn: 4909867(0x004aeb2b)  objd: 4909867  tblspc: 8(0x00000008)

*       Layer:  10 (Index)   opc: 22   rci 0x2b

Undo type:  Regular undo    User Undo Applied  Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

index undo for leaf key operations

KTB Redo

op: 0x02  ver: 0x01

op: C  uba: 0x0084d40a.0ef6.3d

Dump kdilk : itl=2, kdxlkflg=0x1 sdc=0 indexid=0x4a4fe33 block=0x05120c6d

restore leaf row (clear leaf delete flags)

key :(16):  08 bd a8 cd e2 53 4f 48 4f 06 04 c7 5d ef 00 07

*-----------------------------

* Rec #0x2d  slt: 0x0a  objn: 4909867(0x004aeb2b)  objd: 4909867  tblspc: 8(0x00000008)

*       Layer:  10 (Index)   opc: 22   rci 0x2c

Undo type:  Regular undo    User Undo Applied  Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

index undo for leaf key operations

KTB Redo

op: 0x02  ver: 0x01

op: C  uba: 0x0084d40a.0ef6.3e

Dump kdilk : itl=2, kdxlkflg=0x1 sdc=2 indexid=0x4a4fe33 block=0x054aa2ad

purge leaf row

key :(16):  08 b1 b1 cc ab c6 bd d7 af 06 04 c7 5d ef 00 07

*-----------------------------

* Rec #0x2e  slt: 0x0a  objn: 4292866(0x00418102)  objd: 4293150  tblspc: 8(0x00000008)

*       Layer:  11 (Row)   opc: 1   rci 0x2d

Undo type:  Regular undo    User Undo Applied  Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

KDO undo record:

KTB Redo

op: 0x02  ver: 0x01

op: C  uba: 0x0084d40d.0ef6.04

KDO Op code: URP row dependencies Disabled

xtype: XA  bdba: 0x04c75402  hdba: 0x0413f7db

itli: 1  ispac: 0  maxfr: 4858

tabn: 0 slot: 4(0x4) flag: 0x2c lock: 0 ckix: 0

ncol: 234 nnew: 2 size: 0

col 41: [26]

bb aa ce aa a3 a8 b6 ab cb c4 a3 a9 5f bd a8 cd e2 53 4f 48 4f 28 4e 47 4e

29

col 42: [ 8]  bd a8 cd e2 53 4f 48 4f

*-----------------------------

* Rec #0x2f  slt: 0x0a  objn: 4292894(0x0041811e)  objd: 4293319  tblspc: 8(0x00000008)

*       Layer:  10 (Index)   opc: 22   rci 0x2e

Undo type:  Regular undo    User Undo Applied  Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

index undo for leaf key operations

KTB Redo

op: 0x02  ver: 0x01

op: C  uba: 0x0084d40d.0ef6.1a

Dump kdilk : itl=2, kdxlkflg=0x1 sdc=1 indexid=0x3635ce3 block=0x04cbc15b

restore leaf row (clear leaf delete flags)

key :(34):

1a bb aa ce aa a3 a8 b6 ab cb c4 a3 a9 5f bd a8 cd e2 53 4f 48 4f 28 4e 47

4e 29 06 04 c7 54 02 00 04

*-----------------------------

* Rec #0x30  slt: 0x0a  objn: 4292894(0x0041811e)  objd: 4293319  tblspc: 8(0x00000008)

*       Layer:  10 (Index)   opc: 22   rci 0x2f

Undo type:  Regular undo    User Undo Applied  Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

index undo for leaf key operations

KTB Redo

op: 0x02  ver: 0x01

op: C  uba: 0x0084d40d.0ef6.1b

Dump kdilk : itl=2, kdxlkflg=0x1 sdc=2 indexid=0x3635ce3 block=0x05a1b56b

purge leaf row

key :(34):

1a bb aa ce aa a3 a8 b6 ab cb c4 a3 a9 5f b1 b1 cc ab c6 bd d7 af 28 4e 47

4e 29 06 04 c7 54 02 00 04

*-----------------------------

* Rec #0x31  slt: 0x0a  objn: 4292902(0x00418126)  objd: 4293312  tblspc: 8(0x00000008)

*       Layer:  10 (Index)   opc: 22   rci 0x30

Undo type:  Regular undo    User Undo Applied  Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

index undo for leaf key operations

KTB Redo

op: 0x02  ver: 0x01

op: C  uba: 0x0084d40a.0ef6.2d

Dump kdilk : itl=2, kdxlkflg=0x1 sdc=1 indexid=0x41590cb block=0x04cba52f

restore leaf row (clear leaf delete flags)

key :(25):

06 d2 d1 cd cb bb d8 08 bd a8 cd e2 53 4f 48 4f 01 4e 06 04 c7 54 02 00 04

*-----------------------------

* Rec #0x32  slt: 0x0a  objn: 4292902(0x00418126)  objd: 4293312  tblspc: 8(0x00000008)

*       Layer:  10 (Index)   opc: 22   rci 0x31

Undo type:  Regular undo    User Undo Applied  Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

index undo for leaf key operations

KTB Redo

op: 0x02  ver: 0x01

op: C  uba: 0x0084d40d.0ef6.07

Dump kdilk : itl=2, kdxlkflg=0x1 sdc=2 indexid=0x41590cb block=0x049db388

purge leaf row

key :(25):

06 d2 d1 cd cb bb d8 08 b1 b1 cc ab c6 bd d7 af 01 4e 06 04 c7 54 02 00 04

*-----------------------------

* Rec #0x33  slt: 0x0a  objn: 4909866(0x004aeb2a)  objd: 4909866  tblspc: 8(0x00000008)

*       Layer:  10 (Index)   opc: 22   rci 0x32

Undo type:  Regular undo    User Undo Applied  Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

index undo for leaf key operations

KTB Redo

op: 0x02  ver: 0x01

op: C  uba: 0x0084d40d.0ef6.1e

Dump kdilk : itl=2, kdxlkflg=0x1 sdc=0 indexid=0x4a4fd03 block=0x0511fe0b

restore leaf row (clear leaf delete flags)

key :(16):  08 bd a8 cd e2 53 4f 48 4f 06 04 c7 54 02 00 04

*-----------------------------

* Rec #0x34  slt: 0x0a  objn: 4909866(0x004aeb2a)  objd: 4909866  tblspc: 8(0x00000008)

*       Layer:  10 (Index)   opc: 22   rci 0x33

Undo type:  Regular undo    User Undo Applied  Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

index undo for leaf key operations

KTB Redo

op: 0x02  ver: 0x01

op: C  uba: 0x0084d40d.0ef6.09

Dump kdilk : itl=2, kdxlkflg=0x1 sdc=2 indexid=0x4a4fd03 block=0x0511fd9b

purge leaf row

key :(16):  08 b1 b1 cc ab c6 bd d7 af 06 04 c7 54 02 00 04

*-----------------------------

* Rec #0x35  slt: 0x0a  objn: 4292866(0x00418102)  objd: 4293150  tblspc: 8(0x00000008)

*       Layer:  11 (Row)   opc: 1   rci 0x34

Undo type:  Regular undo    User Undo Applied  Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

KDO undo record:

KTB Redo

op: 0x03  ver: 0x01

op: Z

KDO Op code: URP row dependencies Disabled

xtype: XA  bdba: 0x04c75424  hdba: 0x0413f7db

itli: 3  ispac: 0  maxfr: 4858

tabn: 0 slot: 1(0x1) flag: 0x2c lock: 0 ckix: 0

ncol: 234 nnew: 2 size: 0

col 41: [26]

bb aa ce aa a3 a8 b6 ab cb c4 a3 a9 5f bd a8 cd e2 53 4f 48 4f 28 4e 47 4e

29

col 42: [ 8]  bd a8 cd e2 53 4f 48 4f

*-----------------------------

* Rec #0x36  slt: 0x0a  objn: 4292894(0x0041811e)  objd: 4293319  tblspc: 8(0x00000008)

*       Layer:  10 (Index)   opc: 22   rci 0x35

Undo type:  Regular undo    User Undo Applied  Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

index undo for leaf key operations

KTB Redo

op: 0x02  ver: 0x01

op: C  uba: 0x0084d40d.0ef6.2f

Dump kdilk : itl=2, kdxlkflg=0x1 sdc=1 indexid=0x3635ce3 block=0x04cbc15b

restore leaf row (clear leaf delete flags)

key :(34):

1a bb aa ce aa a3 a8 b6 ab cb c4 a3 a9 5f bd a8 cd e2 53 4f 48 4f 28 4e 47

4e 29 06 04 c7 54 24 00 01

*-----------------------------

* Rec #0x37  slt: 0x0a  objn: 4292894(0x0041811e)  objd: 4293319  tblspc: 8(0x00000008)

*       Layer:  10 (Index)   opc: 22   rci 0x36

Undo type:  Regular undo    User Undo Applied  Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

index undo for leaf key operations

KTB Redo

op: 0x02  ver: 0x01

op: C  uba: 0x0084d40d.0ef6.30

Dump kdilk : itl=2, kdxlkflg=0x1 sdc=2 indexid=0x3635ce3 block=0x05a1b56b

purge leaf row

key :(34):

1a bb aa ce aa a3 a8 b6 ab cb c4 a3 a9 5f b1 b1 cc ab c6 bd d7 af 28 4e 47

4e 29 06 04 c7 54 24 00 01

*-----------------------------

* Rec #0x38  slt: 0x0a  objn: 4292902(0x00418126)  objd: 4293312  tblspc: 8(0x00000008)

*       Layer:  10 (Index)   opc: 22   rci 0x37

Undo type:  Regular undo    User Undo Applied  Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

index undo for leaf key operations

KTB Redo

op: 0x02  ver: 0x01

op: C  uba: 0x0084d40d.0ef6.31

Dump kdilk : itl=2, kdxlkflg=0x1 sdc=1 indexid=0x41590cb block=0x04cba52f

restore leaf row (clear leaf delete flags)

key :(25):

06 d2 d1 cd cb bb d8 08 bd a8 cd e2 53 4f 48 4f 01 4e 06 04 c7 54 24 00 01

*-----------------------------

* Rec #0x39  slt: 0x0a  objn: 4292902(0x00418126)  objd: 4293312  tblspc: 8(0x00000008)

*       Layer:  10 (Index)   opc: 22   rci 0x38

Undo type:  Regular undo    User Undo Applied  Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

index undo for leaf key operations

KTB Redo

op: 0x02  ver: 0x01

op: C  uba: 0x0084d40a.0ef6.20

Dump kdilk : itl=2, kdxlkflg=0x1 sdc=2 indexid=0x41590cb block=0x054aa5a7

purge leaf row

key :(25):

06 d2 d1 cd cb bb d8 08 b1 b1 cc ab c6 bd d7 af 01 4e 06 04 c7 54 24 00 01

*-----------------------------

* Rec #0x3a  slt: 0x0a  objn: 4909866(0x004aeb2a)  objd: 4909866  tblspc: 8(0x00000008)

*       Layer:  10 (Index)   opc: 22   rci 0x39

Undo type:  Regular undo    User Undo Applied  Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

index undo for leaf key operations

KTB Redo

op: 0x02  ver: 0x01

op: C  uba: 0x0084d40d.0ef6.33

Dump kdilk : itl=2, kdxlkflg=0x1 sdc=0 indexid=0x4a4fd03 block=0x0511fe0b

restore leaf row (clear leaf delete flags)

key :(16):  08 bd a8 cd e2 53 4f 48 4f 06 04 c7 54 24 00 01

*-----------------------------

* Rec #0x3b  slt: 0x0a  objn: 4909866(0x004aeb2a)  objd: 4909866  tblspc: 8(0x00000008)

*       Layer:  10 (Index)   opc: 22   rci 0x3a

Undo type:  Regular undo    User Undo Applied  Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

index undo for leaf key operations

KTB Redo

op: 0x02  ver: 0x01

op: C  uba: 0x0084d40a.0ef6.22

Dump kdilk : itl=2, kdxlkflg=0x1 sdc=2 indexid=0x4a4fd03 block=0x054aa13f

purge leaf row

key :(16):  08 b1 b1 cc ab c6 bd d7 af 06 04 c7 54 24 00 01

*-----------------------------

* Rec #0x3c  slt: 0x0a  objn: 4292867(0x00418103)  objd: 4293151  tblspc: 8(0x00000008)

*       Layer:  11 (Row)   opc: 1   rci 0x3b

Undo type:  Regular undo    User Undo Applied  Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

KDO undo record:

KTB Redo

op: 0x04  ver: 0x01

op: L  itl: xid:  0x0003.01b.000d5d88 uba: 0x00816a59.87dd.44

flg: C---    lkc:  0     scn: 0x0b06.c2f742de

KDO Op code: URP row dependencies Disabled

xtype: XA  bdba: 0x0464704d  hdba: 0x0413f7e3

itli: 2  ispac: 0  maxfr: 4858

tabn: 0 slot: 2(0x2) flag: 0x2c lock: 0 ckix: 0

ncol: 234 nnew: 2 size: 0

col 41: [26]

bb aa ce aa a3 a8 b6 ab cb c4 a3 a9 5f bd a8 cd e2 53 4f 48 4f 28 4e 47 4e

29

col 42: [ 8]  bd a8 cd e2 53 4f 48 4f

*-----------------------------

* Rec #0x3d  slt: 0x0a  objn: 4292895(0x0041811f)  objd: 4293320  tblspc: 8(0x00000008)

*       Layer:  10 (Index)   opc: 22   rci 0x3c

Undo type:  Regular undo    User Undo Applied  Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

index undo for leaf key operations

KTB Redo

op: 0x02  ver: 0x01

op: C  uba: 0x0084d40a.0ef6.01

Dump kdilk : itl=2, kdxlkflg=0x1 sdc=1 indexid=0x3635ceb block=0x04667afe

restore leaf row (clear leaf delete flags)

key :(34):

1a bb aa ce aa a3 a8 b6 ab cb c4 a3 a9 5f bd a8 cd e2 53 4f 48 4f 28 4e 47

4e 29 06 04 64 70 4d 00 02

*-----------------------------

* Rec #0x3e  slt: 0x0a  objn: 4292895(0x0041811f)  objd: 4293320  tblspc: 8(0x00000008)

*       Layer:  10 (Index)   opc: 22   rci 0x3d

Undo type:  Regular undo    User Undo Applied  Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

index undo for leaf key operations

KTB Redo

op: 0x02  ver: 0x01

op: C  uba: 0x0084d40a.0ef6.02

Dump kdilk : itl=2, kdxlkflg=0x1 sdc=2 indexid=0x3635ceb block=0x049dd96e

purge leaf row

key :(34):

1a bb aa ce aa a3 a8 b6 ab cb c4 a3 a9 5f b1 b1 cc ab c6 bd d7 af 28 4e 47

4e 29 06 04 64 70 4d 00 02

*-----------------------------

* Rec #0x3f  slt: 0x0a  objn: 4292903(0x00418127)  objd: 4293313  tblspc: 8(0x00000008)

*       Layer:  10 (Index)   opc: 22   rci 0x3e

Undo type:  Regular undo    User Undo Applied  Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

index undo for leaf key operations

KTB Redo

op: 0x04  ver: 0x01

op: L  itl: xid:  0x0009.009.000bebfc uba: 0x00814ed0.65d0.03

flg: C-U-    lkc:  0     scn: 0x0b06.dc4fa8cf

Dump kdilk : itl=2, kdxlkflg=0x1 sdc=1 indexid=0x41590d3 block=0x04666316

restore leaf row (clear leaf delete flags)

key :(25):

06 d2 d1 cd ea b3 c9 08 bd a8 cd e2 53 4f 48 4f 01 4e 06 04 64 70 4d 00 02

*-----------------------------

* Rec #0x40  slt: 0x0a  objn: 4292903(0x00418127)  objd: 4293313  tblspc: 8(0x00000008)

*       Layer:  10 (Index)   opc: 22   rci 0x3f

Undo type:  Regular undo    User Undo Applied  Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

index undo for leaf key operations

KTB Redo

op: 0x04  ver: 0x01

op: L  itl: xid:  0x0009.009.000bebfc uba: 0x00816325.65d5.04

flg: C-U-    lkc:  0     scn: 0x0b06.dc5fcb96

Dump kdilk : itl=2, kdxlkflg=0x1 sdc=2 indexid=0x41590d3 block=0x04665c01

purge leaf row

key :(25):

06 d2 d1 cd ea b3 c9 08 b1 b1 cc ab c6 bd d7 af 01 4e 06 04 64 70 4d 00 02

*-----------------------------

* Rec #0x41  slt: 0x0a  objn: 4909867(0x004aeb2b)  objd: 4909867  tblspc: 8(0x00000008)

*       Layer:  10 (Index)   opc: 22   rci 0x40

Undo type:  Regular undo    User Undo Applied  Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

index undo for leaf key operations

KTB Redo

op: 0x04  ver: 0x01

op: L  itl: xid:  0x0009.009.000bebfc uba: 0x008101d6.65c1.07

flg: C-U-    lkc:  0     scn: 0x0b06.dc4f9c5d

Dump kdilk : itl=2, kdxlkflg=0x1 sdc=0 indexid=0x4a4fe33 block=0x05120686

restore leaf row (clear leaf delete flags)

key :(16):  08 bd a8 cd e2 53 4f 48 4f 06 04 64 70 4d 00 02

*-----------------------------

* Rec #0x42  slt: 0x0a  objn: 4909867(0x004aeb2b)  objd: 4909867  tblspc: 8(0x00000008)

*       Layer:  10 (Index)   opc: 22   rci 0x41

Undo type:  Regular undo    User Undo Applied  Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

index undo for leaf key operations

KTB Redo

op: 0x04  ver: 0x01

op: L  itl: xid:  0x0009.009.000bebfc uba: 0x00811bfb.65c5.0a

flg: C-U-    lkc:  0     scn: 0x0b06.dc4e77ad

Dump kdilk : itl=2, kdxlkflg=0x1 sdc=2 indexid=0x4a4fe33 block=0x04d4544d

purge leaf row

key :(16):  08 b1 b1 cc ab c6 bd d7 af 06 04 64 70 4d 00 02

*-----------------------------

* Rec #0x43  slt: 0x0a  objn: 4292867(0x00418103)  objd: 4293151  tblspc: 8(0x00000008)

*       Layer:  11 (Row)   opc: 1   rci 0x42

Undo type:  Regular undo    User Undo Applied  Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

KDO undo record:

KTB Redo

op: 0x04  ver: 0x01

op: L  itl: xid:  0x0003.01b.000d5d88 uba: 0x00812a88.87cf.29

flg: C-U-    lkc:  0     scn: 0x0b06.c2fa0308

KDO Op code: URP row dependencies Disabled

xtype: XA  bdba: 0x04c75f91  hdba: 0x0413f7e3

itli: 2  ispac: 0  maxfr: 4858

tabn: 0 slot: 1(0x1) flag: 0x2c lock: 0 ckix: 0

ncol: 234 nnew: 2 size: 0

col 41: [26]

bb aa ce aa a3 a8 b6 ab cb c4 a3 a9 5f bd a8 cd e2 53 4f 48 4f 28 4e 47 4e

29

col 42: [ 8]  bd a8 cd e2 53 4f 48 4f

*-----------------------------

* Rec #0x44  slt: 0x0a  objn: 4292895(0x0041811f)  objd: 4293320  tblspc: 8(0x00000008)

*       Layer:  10 (Index)   opc: 22   rci 0x43

Undo type:  Regular undo    User Undo Applied  Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

index undo for leaf key operations

KTB Redo

op: 0x04  ver: 0x01

op: L  itl: xid:  0x0001.020.00347010 uba: 0x008fff71.ca78.01

flg: C-U-    lkc:  0     scn: 0x0b06.b7f1e167

Dump kdilk : itl=2, kdxlkflg=0x1 sdc=1 indexid=0x3635ceb block=0x04cbcad8

restore leaf row (clear leaf delete flags)

key :(34):

1a bb aa ce aa a3 a8 b6 ab cb c4 a3 a9 5f bd a8 cd e2 53 4f 48 4f 28 4e 47

4e 29 06 04 c7 5f 91 00 01

*-----------------------------

* Rec #0x45  slt: 0x0a  objn: 4292895(0x0041811f)  objd: 4293320  tblspc: 8(0x00000008)

*       Layer:  10 (Index)   opc: 22   rci 0x44

Undo type:  Regular undo    User Undo Applied  Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

index undo for leaf key operations

KTB Redo

op: 0x02  ver: 0x01

op: C  uba: 0x0084d40d.0ef6.29

Dump kdilk : itl=2, kdxlkflg=0x1 sdc=2 indexid=0x3635ceb block=0x0217f7d5

purge leaf row

key :(34):

1a bb aa ce aa a3 a8 b6 ab cb c4 a3 a9 5f b1 b1 cc ab c6 bd d7 af 28 4e 47

4e 29 06 04 c7 5f 91 00 01

*-----------------------------

* Rec #0x46  slt: 0x0a  objn: 4292903(0x00418127)  objd: 4293313  tblspc: 8(0x00000008)

*       Layer:  10 (Index)   opc: 22   rci 0x45

Undo type:  Regular undo    User Undo Applied  Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

index undo for leaf key operations

KTB Redo

op: 0x04  ver: 0x01

op: L  itl: xid:  0x0009.009.000bebfc uba: 0x00815134.65d0.03

flg: C-U-    lkc:  0     scn: 0x0b06.dc4fa8cf

Dump kdilk : itl=2, kdxlkflg=0x1 sdc=1 indexid=0x41590d3 block=0x04666821

restore leaf row (clear leaf delete flags)

key :(25):

06 d2 d1 cd ea b3 c9 08 bd a8 cd e2 53 4f 48 4f 01 4e 06 04 c7 5f 91 00 01

*-----------------------------

* Rec #0x47  slt: 0x0a  objn: 4292903(0x00418127)  objd: 4293313  tblspc: 8(0x00000008)

*       Layer:  10 (Index)   opc: 22   rci 0x46

Undo type:  Regular undo    User Undo Applied  Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

index undo for leaf key operations

KTB Redo

op: 0x04  ver: 0x01

op: L  itl: xid:  0x0009.009.000bebfc uba: 0x00817ae1.65da.05

flg: C-U-    lkc:  0     scn: 0x0b06.dc5fcc52

Dump kdilk : itl=2, kdxlkflg=0x1 sdc=2 indexid=0x41590d3 block=0x054aaa55

purge leaf row

key :(25):

06 d2 d1 cd ea b3 c9 08 b1 b1 cc ab c6 bd d7 af 01 4e 06 04 c7 5f 91 00 01

*-----------------------------

* Rec #0x48  slt: 0x0a  objn: 4909867(0x004aeb2b)  objd: 4909867  tblspc: 8(0x00000008)

*       Layer:  10 (Index)   opc: 22   rci 0x47

Undo type:  Regular undo    User Undo Applied  Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

index undo for leaf key operations

KTB Redo

op: 0x04  ver: 0x01

op: L  itl: xid:  0x0009.009.000bebfc uba: 0x0081036e.65c1.01

flg: C-U-    lkc:  0     scn: 0x0b06.dc4f9d46

Dump kdilk : itl=2, kdxlkflg=0x1 sdc=0 indexid=0x4a4fe33 block=0x05120c71

restore leaf row (clear leaf delete flags)

key :(16):  08 bd a8 cd e2 53 4f 48 4f 06 04 c7 5f 91 00 01

*-----------------------------

* Rec #0x49  slt: 0x0a  objn: 4909867(0x004aeb2b)  objd: 4909867  tblspc: 8(0x00000008)

*       Layer:  10 (Index)   opc: 22   rci 0x48

Undo type:  Regular undo    User Undo Applied  Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

rdba: 0x00000000

*-----------------------------

index undo for leaf key operations

KTB Redo

op: 0x04  ver: 0x01

op: L  itl: xid:  0x0009.009.000bebfc uba: 0x00812c10.65c9.0d

flg: C-U-    lkc:  0     scn: 0x0b06.dc4e77ad

Dump kdilk : itl=2, kdxlkflg=0x1 sdc=2 indexid=0x4a4fe33 block=0x054aa2dd

purge leaf row

key :(16):  08 b1 b1 cc ab c6 bd d7 af 06 04 c7 5f 91 00 01

End dump data blocks tsn: 1 file#: 2 minblk 316429 maxblk 316429

结束！

weixin_39626745
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
seata-分布式事务
zhanglide0526的博客
09-26 179
一、seata介绍 Seata 是一款开源的分布式事务解决方案，致力于提供高性能和简单易用的分布式事务服务。Seata 将为用户提供了 AT、TCC、SAGA 和 XA 事务模式，为用户打造一站式的分布式解决方案。 2019 年 1 月，阿里巴巴中间件团队发起了开源项目 Fescar（Fast & EaSy Commit And Rollback），和社区一起共建开源分布式事务解决方案。Fescar 的愿景是让分布式事务的使用像本地事务的使用一样，简单和高效，并逐步解决开发者们遇到的分布式事
oracle长事物,定时kill长事务脚本kill_long_session.sh
weixin_31480911的博客
04-05 383
定时kill长事务因为ogg抽取进程需要一定的归档，防止归档被删除，所以定时kill长事务，防止抽取进程abend--kill_long_session.sh#!/bin/shtmpfile0=/oracle/temp/monitor/kill_0.logtmpfile1=/oracle/temp/monitor/kill_1.logtmpfile2=/oracle/temp/monitor/ki...
oracle 进程已经Kill,但仍然存在的孤立会话(orphan session)的彻底清理
最新发布
weixin_43230594的博客
07-13 2349
oracle 进程已经Kill,但仍然存在的孤立会话(orphan session)的彻底清理
Oracle—undo回滚段长时间不释放
热门推荐
u011822980的博客
03-01 1万+
Undo回滚段中Unexpired Block迟迟不释放掉，占用90%以上的undo表空间. 导致数据库事务等待严重. DML运行异常缓慢. JOB运行也有ora-01555错误. 详细询问了下UNDO表空间的具体设置，如下：    1、undo_retention=3600；    2、未设置表空间的retention guarantee；    3、UND
(转）oracle killed会话不释放的问题
bantaoti1130的博客
07-13 870
原文连接：　　http://www.2cto.com/database/201204/127239.html 一般情况下，在杀一个会话的时候，直接执行alter system kill session ‘sid,serial#’; Administrator's Guide说，当session是active的时候，alter system kill session 只是将ses...
seata-oracle版undolog.sql
09-05
oracle版本的undolog建表语句。 2019 年 1 月，阿里巴巴中间件团队发起了开源项目 Fescar（Fast & EaSy Commit And Rollback），和社区一起共建开源分布式事务解决方案。Fescar 的愿景是让分布式事务的使用像本地...
行业-45 如果事务执行到一半要回滚怎么办？再探undo log回滚日志原理！l.rar
09-14
除了回滚事务之外，undo log还用于多版本并发控制（MVCC，Multi-Version Concurrency Control），这是许多数据库系统（如Oracle、PostgreSQL和InnoDB）采用的并发控制策略。MVCC允许多个事务同时访问同一数据，而...
45 如果事务执行到一半要回滚怎么办？再探undo log回滚日志原理！l.pdf
04-15
45 如果事务执行到一半要回滚怎么办？再探undo log回滚日志原理！l.pdf
Oracle 面试宝典-undo.docx
06-21
ORA-01555错误通常是因为Undo信息在需要时已被重用或删除，解决方法包括增加Undo表空间大小、调整undo_retention或优化事务处理以减少Undo使用。 LOB字段可能导致ORA-01555错误，因为LOB数据的大小可能超出常规行...
ORACLE redo undo.docx
08-20
Oracle redo undo 是 Oracle 数据库中的一种机制，用于确保事务的可恢复性和撤销性。下面是对 redo undo 机制的详细解释。 redo 机制 redo 机制是 Oracle 数据库中的一种机制，用于记录事务的所有操作，以便在...
脚本-Oracle释放过度使用的Undo表空间
12-23
Oracle释放过度使用的Undo表空间，脚本
undo 练习学习笔记。
Rhys learn oracle！
08-24 1143
今天是2013-08-24，我把自己学习的内容贴一下，做个笔记。 SQL> select obj#,name from t where rownum       OBJ# NAME ---------- --------------------------------------------------         20 RHYS         46 I_USER1       
oracle清理undo空间,删除Oracle Undo表空间
weixin_36488954的博客
04-10 3228
近期处理了一次删除、重建Undo表空间的事情，有些细节还是值得记下来备忘。事情的起因是工程师需要将分布在不同ASM磁盘组里的Oracle数据库文件，迁移到新建的ASM磁盘组，操作过程中，错误的删除了Undo磁盘组的所有文件。版本 11.2.0.4， RAC环境——测试、准生产环境；下文操作不保证在“生产环境”无害。Step 1：考虑新建Undo Tablespace，然后修改各个实例(Instan...
oracle的回滚和撤销机制
雅冰石的专栏
06-18 2350
为了保证数据库中多个用户间的读一致性和能够回退事务。 一、在一个简单的更新语句中，对于回滚段的操作存在多处，在事务开始时，首 先需要在回滚表空间获得一个事务槽，分配空间，然后创建前镜像，此后事务的 修改才能进行，oracle必须以此来保证事务是可以回滚的。如果用户提交了事务 ，oracle会在日志文件记录提交，并且写出日志，同时会在回滚段中把事务标记 为已提交；如果用户回
oracle 撤销回退,Oracle 回滚(ROLLBACK)和撤销(UNDO)
weixin_35737757的博客
04-03 768
五、计算UNDO表空间的大小计算公式：MAX(undoblks)/600 * MAX(maxquerylen)位于v$undostat* db_block_size位于v$parameter--创建演示环境SQL> INSERT INTO tb_test SELECT employee_id,first_name FROM hr.employees;107 rows createdSQL&g...
Oracle 的异常和回滚
陶二先生的专栏
07-18 6162
Oracle 的异常和回滚
oracle结束事物语句,Oracle中死事务的检查语句
weixin_42403771的博客
04-03 130
SQL> SELECT KTUXEUSN, KTUXESLT, KTUXESQN, /* Transaction ID */2 KTUXESTA Status, KTUXECFL Flags ,KTUXESIZ3 FROM x$ktuxe4 WHERE ktuxesta!='INACTIVE';KTUXEUSN KTUXESLT KTUXESQN STATUS FLAGS KTUXESIZ-...
oracle的事务的停止方法,oracle学习笔记(十)事务控制语句
weixin_36060412的博客
04-03 665
一个事务起始于dml 语句. 1 rollback: 假设 依次执行以下语句 : update emp2 set sal =sal *2; delete from dept2; 以上被认为是同一个事务. 若此时rollback , 那么以上两个改动都将修复. 2 commit: 提交语句将终止一个事务. 执行一条语句后使用 commit , 则一个事务起始于dml 语句.1 rollback:假...
10.管理UNDO表空间.(笔记)
congsikuai0611的博客
04-15 519
10.管理UNDO表空间.UNDO表空间用于存放UNDO数据,当执行DML操作(INSERT,UPDATE和DELETE)时,oracle会将这些操作的旧数据写入到UNDO段,在oracle9i之前,管理UNDO数据时使用(Ro...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值