- 论坛徽章:
- 0
|
引起的原因是什么，会造成什么影响？？？
/oracle/product/9.2.1/admin/ccicdb/udump/ccicdb_ora_2228256.trc
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.1.0 - Production
ORACLE_HOME = /oracle/product/9.2.1
System name: AIX
Node name: ccicsrv1
Release: 1
Version: 5
Machine: 00529DFA4C00
Instance name: ccicdb
Redo thread mounted by this instance: 1
Oracle process number: 168
Unix process pid: 2228256, image: oracle@ccicsrv1 (TNS V1-V3)
*** 2004-06-07 09:38:44.555
*** SESSION ID 168.6) 2004-06-07 09:38:44.539
DEADLOCK DETECTED
Current SQL statement for this session:
Update PrpCmain Set PolicyNo = 'PDAA200451010702001021', ClassCode = 'D', RiskCode = 'DAA', ProposalNo = 'TDAA200451010702001038', ContractNo = '', PolicySort = '1', PrintNo = '0000019664', BusinessNature = '0', Language = 'C', PolicyType = '', AppliCode = '5101076000013021', AppliName = '**', AppliAddress = '', InsuredCode = '5101070000001798', InsuredName = '********', InsuredAddress = '', OperateDate = '2004-06-01', StartDate = '2004-06-10', StartHour = '0', EndDate = '2005-06-09', EndHour = '24', PureRate = '0.0', DisRate = '0.0', Discount = '0.0', Currency = 'CNY', SumValue = '0.0', SumAmount = '170000.0', SumDiscount = '794.3', SumPremium = '2150.96', SumSubPrem = '475.11', SumQuantity = '1', JudicalScope = 'Öйú(&Û°Ą̈³&Í& ˾·¨¹ÜϽ', AutoTransRenewFlag = '', ArgueSolution = '2', ArbitBoardName = '*****', PayTimes = '1', EndorseTimes = '0', ClaimTimes = '0', MakeCom = '51010702', OperateSite = '', ComCode = '51010702', HandlerCode = '5101000115', Handler1Code = '5101000115', ApproverCode = '5101000051', UnderWriteCode = '5101000070', UnderWriteName = '***', OperatorCode = '5101000050', InputDate = '2004-06-01', InputHour = '15', UnderWriteEndDate = '2004-06-01', StatisticsYM = '2004-06-10', AgentCode = '', CoinsFlag = '0', ReinsFlag = '0', AllinsFlag = '0', UnderWriteFlag = '1', OthFlag = '000000YY00', Flag = '' Where PolicyNo = 'PDAA200451010702001021'
The following deadlock is not an ORACLE error. It is a
deadlock due to user error in the design of an application
or from issuing incorrect ad-hoc SQL. The following
information may aid in determining the deadlock:
Deadlock graph:
---------Blocker(s)-------- ---------Waiter(s)---------
Resource Name process session holds waits process session holds waits
TM-0000976e-00000000 168 168 SX SSX 264 224 SX SSX
TM-0000976e-00000000 264 224 SX SSX 168 168 SX SSX
session 168: DID 0001-00A8-00000002 session 224: DID 0001-0108-00000002
session 224: DID 0001-0108-00000002 session 168: DID 0001-00A8-00000002
Rows waited on:
Session 224: obj - rowid = 00009710 - AAAAAAAAdAAAEVIAAA
(dictionary objn - 38672, file - 29, block - 17736, slot - 0)
Session 168: no row
Information on the OTHER waiting sessions:
Session 224:
pid=264 serial=13 audsid=150623 user: 43/CCIC
O/S info: user: weblogic, term: unknown, ospid: , machine: ccicsrv2
program: JDBC Thin Client
Current SQL Statement:
Update PrpCmain Set PolicyNo = 'PDAA200431010006010029', ClassCode = 'D', RiskCode = 'DAA', ProposalNo = 'TDAA200431010006009853', ContractNo = '', PolicySort = '1', PrintNo = '0000021627', BusinessNature = '3', Language = 'C', PolicyType = '99', AppliCode = '3101006000003731', AppliName = '**', AppliAddress = '', InsuredCode = '3101006000003731', InsuredName = '**', InsuredAddress = '', OperateDate = '2004-05-17', StartDate = '2005-05-18', StartHour = '0', EndDate = '2006-05-17', EndHour = '24', PureRate = '0.0', DisRate = '0.0', Discount = '0.0', Currency = 'CNY', SumValue = '0.0', SumAmount = '249300.0', SumDiscount = '-409.19', SumPremium = '3983.5699999999997', SumSubPrem = '2288.62', SumQuantity = '1', JudicalScope = '***', AutoTransRenewFlag = '', ArgueSolution = '1', ArbitBoardName = '', PayTimes = '1', EndorseTimes = '1', ClaimTimes = '0', MakeCom = '31010006', OperateSite = '', ComCode = '31010066', HandlerCode = '3101000030', Handler1Code = '3101000030', ApproverCode = '3101000021', UnderWriteCode = '3101000020', UnderWriteName = '***', OperatorCode = '3101000022', InputDate = '2004-05-17', InputHour = '16', UnderWriteEndDate = '2004-05-17', StatisticsYM = '2005-05-18', AgentCode = '310100000100', CoinsFlag = '0', ReinsFlag = '0', AllinsFlag = '0', UnderWriteFlag = '1', OthFlag = '000000YY00', Flag = '' Where PolicyNo = 'PDAA200431010006010029'
End of information on OTHER waiting sessions.
===================================================
PROCESS STATE
-------------
Process global information:
process: 700000052bd34f8, call: 7000000340fc4f0, xact: 700000050e95250, curses: 700000052d4d530, usrses: 700000052d4d530
----------------------------------------
SO: 700000052bd34f8, type: 2, owner: 0, flag: INIT/-/-/0x00
(process) Oracle pid=168, calls cur/top: 7000000340fc4f0/7000000340fc4f0, flag: (0) -
int error: 0, call error: 0, sess error: 0, txn error 0
(post info) last post received: 178 0 4
last post received-location: kslpsr
last process to post me: 700000052ba00f8 1 6
last post sent: 0 0 15
last post sent-location: ksasnd
last process posted by me: 700000052ba00f8 1 6
(latch info) wait_event=0 bits=10
holding 70000000000a4f8 Parent+children enqueue hash chains level=4
Location from where latch is held: ksqcmi: kslgpl:
Context saved from call: 0
state=busy
recovery area:
Dump of memory from 0x0700000052B9EBD0 to 0x0700000052B9EBE0
700000052B9EBD0 00000000 00000000 00000000 00000000 [................]
Process Group: DEFAULT, pseudo proc: 700000052cd7558
O/S info: user: oracle, term: UNKNOWN, ospid: 2228256
OSD pid info: Unix process pid: 2228256, image: oracle@ccicsrv1 (TNS V1-V3)
----------------------------------------
SO: 700000050338a70, type: 8, owner: 700000052bd34f8, flag: INIT/-/-/0x00
(FOB) flags=2 fib ptr=509f9f80 incno=1 pending i/o cnt=0
----------------------------------------
SO: 700000050338848, type: 8, owner: 700000052bd34f8, flag: INIT/-/-/0x00
(FOB) flags=2 fib ptr=509f9be0 incno=1 pending i/o cnt=0
----------------------------------------
SO: 700000050332a00, type: 8, owner: 700000052bd34f8, flag: INIT/-/-/0x00
(FOB) flags=2 fib ptr=509f7eb0 incno=1 pending i/o cnt=0
----------------------------------------
SO: 70000005032fa30, type: 8, owner: 700000052bd34f8, flag: INIT/-/-/0x00
(FOB) flags=2 fib ptr=509fa150 incno=1 pending i/o cnt=0
----------------------------------------
SO: 70000005032ede0, type: 8, owner: 700000052bd34f8, flag: INIT/-/-/0x00
(FOB) flags=2 fib ptr=509f9db0 incno=1 pending i/o cnt=0
----------------------------------------
SO: 700000050323dd0, type: 8, owner: 700000052bd34f8, flag: INIT/-/-/0x00
(FOB) flags=2 fib ptr=509fb3a0 incno=1 pending i/o cnt=0
----------------------------------------
SO: 700000050323d18, type: 8, owner: 700000052bd34f8, flag: INIT/-/-/0x00
(FOB) flags=2 fib ptr=509fb1d0 incno=1 pending i/o cnt=0
----------------------------------------
SO: 700000050323c60, type: 8, owner: 700000052bd34f8, flag: INIT/-/-/0x00
(FOB) flags=2 fib ptr=509fafe8 incno=1 pending i/o cnt=0
----------------------------------------
SO: 70000005031a2c8, type: 8, owner: 700000052bd34f8, flag: INIT/-/-/0x00
(FOB) flags=2 fib ptr=509fb570 incno=1 pending i/o cnt=0
----------------------------------------
SO: 700000050319958, type: 8, owner: 700000052bd34f8, flag: INIT/-/-/0x00
(FOB) flags=2 fib ptr=509fae18 incno=1 pending i/o cnt=0
----------------------------------------
SO: 7000000503198a0, type: 8, owner: 700000052bd34f8, flag: INIT/-/-/0x00
(FOB) flags=2 fib ptr=509fac48 incno=1 pending i/o cnt=0
----------------------------------------
SO: 700000050317000, type: 8, owner: 700000052bd34f8, flag: INIT/-/-/0x00
(FOB) flags=2 fib ptr=509faa78 incno=1 pending i/o cnt=0
----------------------------------------
SO: 7000000502d3b38, type: 8, owner: 700000052bd34f8, flag: INIT/-/-/0x00
(FOB) flags=2 fib ptr=509f8b78 incno=1 pending i/o cnt=0
----------------------------------------
SO: 700000052d4d530, type: 4, owner: 700000052bd34f8, flag: INIT/-/-/0x00
(session) trans: 700000050e95250, creator: 700000052bd34f8, flag: (8100041) USR/- BSY/-/-/-/-/-
DID: 0001-00A8-00000002, short-term DID: 0000-0000-00000000
txn branch: 0
oct: 0, prv: 0, sql: 700000026536678, psql: 0, user: 43/CCIC
O/S info: user: weblogic, term: unknown, ospid: , machine: ccicapp1
program: JDBC Thin Client
last wait for 'null event' blocking sess=0x52d724b0 seq=61335 wait_time=3000027
=544d0005, =976e, =0
temporary object counter: 0
----------------------------------------
SO: 70000002d193728, type: 52, owner: 700000052d4d530, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=70000002d193728 handle=700000017f66870 mode=S lock=700000052005fe0
user=700000052d4d530 session=700000052d4d530 count=1 mask=0041 savepoint=1175 flags=[00]
----------------------------------------
SO: 700000052005fe0, type: 51, owner: 700000052d4d530, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=700000052005fe0 handle=700000017f66870 mode=N
call pin=0 session pin=70000002d193728
user=700000052d4d530 session=700000052d4d530 count=1 flags=PNS/[08] savepoint=1066
LIBRARY OBJECT HANDLE: handle=700000017f66870
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=S latch#=1
lwt=700000017f668a0[700000017f668a0,700000017f668a0] ltm=700000017f668b0[700000017f668b0,700000017f668b0]
pwt=700000017f668d0[700000017f668d0,700000017f668d0] ptm=700000017f66960[700000017f66960,700000017f66960]
ref=700000017f66880[70000002f681b38, 70000002f681b38] lnd=700000017f66978[700000017f66978,700000017f66978]
LIBRARY OBJECT: object=700000045fcb5a8
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
DEPENDENCIES: count=32 size=32
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change
----- -------- -------- ------ ---- ------
0 70000003227b288 7000000475c0cf8 I/P/A 0 NONE
6 700000045fcb6c8 70000002a637a98 I/P/A 1 NONE
----------------------------------------
SO: 70000001ffa8d50, type: 51, owner: 700000052d4d530, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=70000001ffa8d50 handle=700000026536678 mode=N
call pin=70000002d1935a8 session pin=0
user=700000052d4d530 session=700000052d4d530 count=1 flags=[00] savepoint=1065
LIBRARY OBJECT HANDLE: handle=700000026536678
name=
Update PrpCmain Set PolicyNo = 'PDAA200451010702001021', ClassCode = 'D', RiskCode = 'DAA', ProposalNo = 'TDAA200451010702001038', ContractNo = '', PolicySort = '1', PrintNo = '0000019664', BusinessNature = '0', Language = 'C', PolicyType = '', AppliCode = '5101076000013021', AppliName = '**', AppliAddress = '', InsuredCode = '5101070000001798', InsuredName = '***', InsuredAddress = '', OperateDate = '2004-06-01', StartDate = '2004-06-10', StartHour = '0', EndDate = '2005-06-09', EndHour
hash=e819c84c timestamp=06-07-2004 09:38:41
namespace=CRSR flags=RON/KGHP/TIM/PN0/[10010000]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch#=1
lwt=7000000265366a8[7000000265366a8,7000000265366a8] ltm=7000000265366b8[7000000265366b8,7000000265366b8]
pwt=7000000265366d8[7000000265366d8,7000000265366d8] ptm=700000026536768[700000026536768,700000026536768]
ref=700000026536688[700000026536688, 700000026536688] lnd=700000026536780[700000026536780,700000026536780]
LIBRARY OBJECT: object=7000000356f8ef8
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
CHILDREN: size=16
child# table reference handle
------ -------- --------- --------
0 7000000356f9130 70000002f681b38 700000017f66870
DATA BLOCKS:
data# heap pointer status pins change
----- -------- -------- ------ ---- ------
0 7000000356f91d8 7000000356f8ff0 I/P/A 0 NONE
----------------------------------------
SO: 700000050e95250, type: 38, owner: 700000052d4d530, flag: INIT/-/-/0x00
(trans) bsn = 6, flg = 0x1e03, flg2 = 0x00, prx = 0x0, ros = 2147483647, spn = 1177
efd = 5
parent xid: 0x0000.000.00000000
env: (scn: 0x0000.0324b447 xid: 0x0007.008.000092ae uba: 0x04c0103e.1bec.0c statement num=0 parent xid: xid: 0x0000.000.00000000 scn: 0x0000.0324b44a 0sch: scn: 0x0000.00000000)
cev: (spc = 4542 arsp = 70000004f0cd820 ubk tsn: 1 rdba: 0x04c0103e useg tsn: 1 rdba: 0x00800069
hwm uba: 0x04c0103e.1bec.0c col uba: 0x00000000.0000.00
num bl: 2 bk list: 0x700000050c93cc0)
(enqueue) TX-00070008-000092AE DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051356580, mode: X, prv: 700000051356590, sess: 700000052d4d530, proc: 700000052bd34f8
xga: 0x0, heap: UGA
----------------------------------------
SO: 700000050b84eb0, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38696 flg=01 chi=0
his[0]: mod=2 spn=1176
(enqueue) TM-00009728-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051358460, mode: SS, prv: 700000050b85980, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b84df0, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38642 flg=01 chi=0
his[0]: mod=3 spn=1061
(enqueue) TM-000096F2-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051312358, mode: SX, prv: 700000050b867d8, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b84d30, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38638 flg=01 chi=0
his[0]: mod=3 spn=1054
(enqueue) TM-000096EE-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 70000005133b270, mode: SX, prv: 700000050b85428, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b84c70, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=43661 flg=01 chi=0
his[0]: mod=3 spn=1047
(enqueue) TM-0000AA8D-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 70000005131c638, mode: SX, prv: 700000050b86658, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b84af0, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38634 flg=01 chi=0
his[0]: mod=3 spn=1040
(enqueue) TM-000096EA-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051323a20, mode: SX, prv: 700000050b85368, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b84a30, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38632 flg=01 chi=0
his[0]: mod=3 spn=1033
(enqueue) TM-000096E8-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051351490, mode: SX, prv: 700000050b852a8, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b84898, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38630 flg=01 chi=0
his[0]: mod=3 spn=1026
(enqueue) TM-000096E6-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051355238, mode: SX, prv: 700000050b851e8, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b84718, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38628 flg=01 chi=0
his[0]: mod=3 spn=1019
(enqueue) TM-000096E4-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 70000005131d900, mode: SX, prv: 700000050b85128, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b84598, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38624 flg=01 chi=0
his[0]: mod=3 spn=1012
(enqueue) TM-000096E0-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 70000005131dc00, mode: SX, prv: 700000050b85068, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b84418, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38607 flg=01 chi=0
his[0]: mod=3 spn=1005
(enqueue) TM-000096CF-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 7000000513257e8, mode: SX, prv: 700000050b861c0, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b84298, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38605 flg=01 chi=0
his[0]: mod=3 spn=998
(enqueue) TM-000096CD-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 70000005134b570, mode: SX, prv: 700000050b86100, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b84058, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38603 flg=01 chi=0
his[0]: mod=3 spn=991
(enqueue) TM-000096CB-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 7000000513256e8, mode: SX, prv: 700000050b86040, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b83ed8, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38601 flg=01 chi=0
his[0]: mod=3 spn=984
(enqueue) TM-000096C9-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051349790, mode: SX, prv: 700000050b85f80, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b83bc0, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38599 flg=01 chi=0
his[0]: mod=3 spn=977
(enqueue) TM-000096C7-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 70000005130ca50, mode: SX, prv: 700000050b85ec0, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b83a40, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=43655 flg=01 chi=0
his[0]: mod=3 spn=970
(enqueue) TM-0000AA87-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051325668, mode: SX, prv: 700000050b85e00, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b83800, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38640 flg=01 chi=0
his[0]: mod=3 spn=963
(enqueue) TM-000096F0-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051351aa8, mode: SX, prv: 700000050b854e8, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b835c0, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38644 flg=01 chi=0
his[0]: mod=3 spn=956
(enqueue) TM-000096F4-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051311b40, mode: SX, prv: 700000050b855a8, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b83500, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38955 flg=01 chi=0
his[0]: mod=3 spn=877
(enqueue) TM-0000982B-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 7000000513255e8, mode: SX, prv: 700000050b85bc0, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b83440, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38660 flg=01 chi=0
his[0]: mod=3 spn=870
(enqueue) TM-00009704-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051356480, mode: SX, prv: 700000050b858c0, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b83380, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38953 flg=01 chi=0
his[0]: mod=3 spn=863
(enqueue) TM-00009829-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051318e90, mode: SX, prv: 700000050b84be8, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b832c0, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38656 flg=01 chi=0
his[0]: mod=3 spn=856
(enqueue) TM-00009700-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051357ab0, mode: SX, prv: 700000050b84990, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b83200, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38652 flg=01 chi=0
his[0]: mod=3 spn=823
(enqueue) TM-000096FC-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 7000000513122d8, mode: SX, prv: 700000050b84810, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b83128, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38650 flg=01 chi=0
his[0]: mod=3 spn=807
(enqueue) TM-000096FA-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051317be0, mode: SX, prv: 700000050b84690, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b83068, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38957 flg=01 chi=0
his[0]: mod=3 spn=779
(enqueue) TM-0000982D-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051325568, mode: SX, prv: 700000050b84510, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b82fa8, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38959 flg=01 chi=0
his[0]: mod=3 spn=770
(enqueue) TM-0000982F-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 7000000513254e8, mode: SX, prv: 700000050b84210, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b82ee8, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38951 flg=01 chi=0
his[0]: mod=3 spn=763
(enqueue) TM-00009827-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051325468, mode: SX, prv: 700000050b84150, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050c93cc0, type: 37, owner: 700000050e95250, flag: -/-/-/0x00
(List of Blocks) next index = 13
index savepoint itli buffer hint rdba
--------------------------------------------------
0 745 2 0x700000080fd2900 0x70056b7
1 749 2 0x7000000bdfa0300 0x78025df
2 757 2 0x7000000a7fea200 0x700703c
3 758 2 0x7000000c2fa8a00 0x6c07e24
4 773 2 0x700000098ff2800 0x6c07b5b
5 774 2 0x700000067fe1600 0x6c07fbb
6 782 1 0x7000000bffa3300 0x7c0430a
7 802 2 0x7000000bdf9a400 0x7006294
8 810 1 0x7000000bdf83c00 0x740611e
9 818 2 0x7000000bdf9c800 0x7005ace
10 826 2 0x7000000b8fc0900 0x7c0364d
11 850 2 0x7000000bdf99a00 0x74036a7
12 851 2 0x7000000bdf9a200 0x74036c8
----------------------------------------
SO: 700000050b82e28, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38949 flg=01 chi=0
his[0]: mod=3 spn=742
(enqueue) TM-00009825-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 7000000513253e8, mode: SX, prv: 700000050b83fd0, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b82d68, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38995 flg=01 chi=0
his[0]: mod=3 spn=663
(enqueue) TM-00009853-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051325368, mode: SX, prv: 700000050b83e50, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b82ca8, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38997 flg=01 chi=0
his[0]: mod=3 spn=656
(enqueue) TM-00009855-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 7000000513252e8, mode: SX, prv: 700000050b83d78, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b82be8, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38991 flg=01 chi=0
his[0]: mod=3 spn=645
(enqueue) TM-0000984F-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051325268, mode: SX, prv: 700000050b83cb8, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b82b28, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38929 flg=01 chi=0
his[0]: mod=3 spn=638
(enqueue) TM-00009811-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 7000000513251d0, mode: SX, prv: 700000050b83b38, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b828e8, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38965 flg=01 chi=0
his[0]: mod=3 spn=631
(enqueue) TM-00009835-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051325150, mode: SX, prv: 700000050b839b8, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b82828, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38967 flg=01 chi=0
his[0]: mod=3 spn=624
(enqueue) TM-00009837-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 7000000513250d0, mode: SX, prv: 700000050b838f8, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b82450, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38963 flg=01 chi=0
his[0]: mod=3 spn=614
(enqueue) TM-00009833-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051325050, mode: SX, prv: 700000050b83778, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b82390, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38658 flg=01 chi=0
his[0]: mod=3 spn=607
(enqueue) TM-00009702-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 70000005131d4e8, mode: SX, prv: 700000050b836b8, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b80ce0, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38648 flg=01 chi=0
his[0]: mod=3 spn=600
(enqueue) TM-000096F8-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051307c60, mode: SX, prv: 700000050b82aa0, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b80b60, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=44257 flg=01 chi=0
his[0]: mod=3 spn=593
(enqueue) TM-0000ACE1-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051315468, mode: SX, prv: 700000050b829e0, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b80920, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38983 flg=01 chi=0
his[0]: mod=2 spn=583
(enqueue) TM-00009847-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051324fd0, mode: SS, prv: 700000050b827a0, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b80860, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38971 flg=01 chi=0
his[0]: mod=2 spn=583
(enqueue) TM-0000983B-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051324f50, mode: SS, prv: 700000050b826e0, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b807a0, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38792 flg=01 chi=0
his[0]: mod=2 spn=583
(enqueue) TM-00009788-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051324ed0, mode: SS, prv: 700000050b82620, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b806e0, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38609 flg=01 chi=1
his[0]: mod=2 spn=583
his[1]: mod=3 spn=1176
(enqueue) TM-000096D1-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051324e50, mode: SX, prv: 700000050b82548, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b803e0, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38975 flg=01 chi=0
his[0]: mod=3 spn=504
(enqueue) TM-0000983F-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051324dd0, mode: SX, prv: 700000050b82308, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b80320, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38788 flg=01 chi=0
his[0]: mod=3 spn=497
(enqueue) TM-00009784-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051324d50, mode: SX, prv: 700000050b82248, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b80260, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38784 flg=01 chi=0
his[0]: mod=3 spn=490
(enqueue) TM-00009780-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 7000000513120d8, mode: SX, prv: 700000050b82188, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b801a0, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38782 flg=01 chi=0
his[0]: mod=3 spn=483
(enqueue) TM-0000977E-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051324cd0, mode: SX, prv: 700000050b820c8, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b800c8, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38776 flg=01 chi=0
his[0]: mod=3 spn=476
(enqueue) TM-00009778-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051324c50, mode: SX, prv: 700000050b82008, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b80008, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38780 flg=01 chi=0
his[0]: mod=3 spn=469
(enqueue) TM-0000977C-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051318910, mode: SX, prv: 700000050b81f48, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b7ff48, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38822 flg=01 chi=0
his[0]: mod=3 spn=462
(enqueue) TM-000097A6-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051324bd0, mode: SX, prv: 700000050b81e88, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b7fe88, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38820 flg=01 chi=0
his[0]: mod=3 spn=455
(enqueue) TM-000097A4-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051324b50, mode: SX, prv: 700000050b81dc8, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b7fdc8, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38812 flg=01 chi=0
his[0]: mod=3 spn=448
(enqueue) TM-0000979C-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051351810, mode: SX, prv: 700000050b81d08, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b7fd08, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38798 flg=01 chi=0
his[0]: mod=3 spn=441
(enqueue) TM-0000978E-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051324a50, mode: SX, prv: 700000050b81c48, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b7fc48, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38804 flg=01 chi=0
his[0]: mod=3 spn=434
(enqueue) TM-00009794-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051312970, mode: SX, prv: 700000050b81b88, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b7fb88, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38802 flg=01 chi=0
his[0]: mod=3 spn=427
(enqueue) TM-00009792-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 7000000513249b8, mode: SX, prv: 700000050b81ac8, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b7fac8, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=43657 flg=01 chi=0
his[0]: mod=3 spn=413
(enqueue) TM-0000AA89-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051324938, mode: SX, prv: 700000050b81a08, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b7fa08, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=43663 flg=01 chi=0
his[0]: mod=3 spn=406
(enqueue) TM-0000AA8F-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 7000000513207f8, mode: SX, prv: 700000050b81930, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b7f948, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38814 flg=01 chi=0
his[0]: mod=3 spn=399
(enqueue) TM-0000979E-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 7000000513248b8, mode: SX, prv: 700000050b81870, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b7f888, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38808 flg=01 chi=0
his[0]: mod=3 spn=392
(enqueue) TM-00009798-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 7000000513558d0, mode: SX, prv: 700000050b817b0, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b7f7c8, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38806 flg=01 chi=1
his[0]: mod=2 spn=382
his[1]: mod=3 spn=420
(enqueue) TM-00009796-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 7000000513247b8, mode: SX, prv: 700000050b816f0, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b7f708, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38796 flg=01 chi=0
his[0]: mod=3 spn=382
(enqueue) TM-0000978C-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051324738, mode: SX, prv: 700000050b81630, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b7f648, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38828 flg=01 chi=0
his[0]: mod=3 spn=257
(enqueue) TM-000097AC-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 7000000513246b8, mode: SX, prv: 700000050b81570, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b7f588, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38818 flg=01 chi=0
his[0]: mod=3 spn=248
(enqueue) TM-000097A2-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051324638, mode: SX, prv: 700000050b814b0, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b7f4b0, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38981 flg=01 chi=0
his[0]: mod=3 spn=239
(enqueue) TM-00009845-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 70000005131cbd0, mode: SX, prv: 700000050b813f0, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b7f3f0, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38794 flg=01 chi=0
his[0]: mod=3 spn=232
(enqueue) TM-0000978A-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 7000000513531d8, mode: SX, prv: 700000050b81330, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b7f330, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38979 flg=01 chi=0
his[0]: mod=3 spn=225
(enqueue) TM-00009843-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051324538, mode: SX, prv: 700000050b81270, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b7f270, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38973 flg=01 chi=0
his[0]: mod=3 spn=218
(enqueue) TM-0000983D-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 7000000513244b8, mode: SX, prv: 700000050b811b0, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b7f1b0, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38826 flg=01 chi=0
his[0]: mod=3 spn=211
(enqueue) TM-000097AA-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051307df8, mode: SX, prv: 700000050b810f0, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b7f0f0, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38790 flg=01 chi=0
his[0]: mod=3 spn=204
(enqueue) TM-00009786-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051324438, mode: SX, prv: 700000050b81030, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b7f030, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38778 flg=01 chi=0
his[0]: mod=3 spn=195
(enqueue) TM-0000977A-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051351510, mode: SX, prv: 700000050b80f70, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b7ef70, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38786 flg=01 chi=0
his[0]: mod=3 spn=188
(enqueue) TM-00009782-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051357f48, mode: SX, prv: 700000050b80eb0, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b7eeb0, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38816 flg=01 chi=0
his[0]: mod=3 spn=109
(enqueue) TM-000097A0-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051324238, mode: SX, prv: 700000050b80df0, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b7edf0, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38969 flg=01 chi=0
his[0]: mod=3 spn=30
(enqueue) TM-00009839-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 7000000513241a0, mode: SX, prv: 700000050b80c58, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b7ed30, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38770 flg=01 chi=0
his[0]: mod=3 spn=23
(enqueue) TM-00009772-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051349a28, mode: SX, prv: 700000050b80ad8, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b7ec70, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38774 flg=01 chi=0
his[0]: mod=3 spn=16
(enqueue) TM-00009776-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 7000000513240a0, mode: SX, prv: 700000050b80a18, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050c82000, type: 37, owner: 700000050e95250, flag: -/-/-/0x00
(List of Blocks) next index = 20
index savepoint itli buffer hint rdba
--------------------------------------------------
0 9 2 0x700000086fb4800 0x680c979
1 11 2 0x700000092fd2800 0x6828693
2 198 1 0x700000086f9a000 0x6c09723
3 199 2 0x70000006dfd8300 0x682ff93
4 242 2 0x700000087fa9f00 0x6c0a39a
5 243 2 0x7000000a9fd8000 0x6c043c8
6 251 1 0x700000082f8ff00 0x7007a20
7 252 2 0x700000079fb4b00 0x6c050c5
8 260 2 0x7000000b7f96f00 0x7804210
9 269 2 0x7000000a6fba800 0x7007c33
10 385 2 0x700000096fe6200 0x6c0a46d
11 387 2 0x700000090f8ab00 0x6c0760a
12 586 3 0x700000086fb9200 0x7405853
13 588 2 0x700000067fb8100 0x6c0758a
14 617 2 0x7000000b3f88000 0x6c0a349
15 619 2 0x70000007ffb5b00 0x7004deb
16 648 2 0x700000080fd2b00 0x7007f9b
17 649 3 0x7000000bafdd800 0x24256f6
18 650 2 0x7000000b6f8cb00 0x24332f8
19 651 2 0x70000006afb1700 0x6c071c8
----------------------------------------
SO: 700000050b7ebb0, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38772 flg=01 chi=0
his[0]: mod=2 spn=6
(enqueue) TM-00009774-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051348660, mode: SS, prv: 700000050b80658, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b7eaf0, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38768 flg=01 chi=0
his[0]: mod=3 spn=6
(enqueue) TM-00009770-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051323fa0, mode: SX, prv: 700000050b80598, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 700000050b7ea30, type: 34, owner: 700000050e95250, flag: INIT/-/-/0x00
DML LOCK: tab=38766 flg=01 chi=1
his[0]: mod=2 spn=6
his[1]: mod=3 spn=583
(enqueue) TM-0000976E-00000000 DID: 0001-00A8-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 700000051323f20, mode: SX, req: SSX, prv: 700000051323f50, sess: 700000052d4d530, proc: 700000052bd34f8
----------------------------------------
SO: 7000000340fb780, type: 51, owner: 700000052d4d530, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=7000000340fb780 handle=70000004ec89ff8 mode=N
call pin=70000004fd73bd8 session pin=0
user=700000052d4d530 session=700000052d4d530 count=1 flags=CBB/[02] savepoint=67
LIBRARY OBJECT HANDLE: handle=70000004ec89ff8
name=SYS.DATABASE
hash=aea96fa0 timestamp=12-31-4712 23:59:59
namespace=EVNT flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0009-0009 lock=N pin=0 latch#=2
lwt=70000004ec8a028[70000004ec8a028,70000004ec8a028] ltm=70000004ec8a038[70000004ec8a038,70000004ec8a038]
pwt=70000004ec8a058[70000004ec8a058,70000004ec8a058] ptm=70000004ec8a0e8[70000004ec8a0e8,70000004ec8a0e8]
ref=70000004ec8a008[70000004ec8a008, 70000004ec8a008] lnd=70000004ec8a100[70000004ec8a100,70000004ec8a100]
LIBRARY OBJECT: object=700000043e7ca18
type=EVNT flags=EXS/LOC[0005] pflags= [00] status=VALD load=0
DATA BLOCKS:
data# heap pointer status pins change
----- -------- -------- ------ ---- ------
0 700000015ecef18 700000043e7cbc0 I/-/A 0 NONE
3 700000043e7cb38 7000000138b7bd8 I/-/A 0 NONE
----------------------------------------
SO: 70000004fd516b8, type: 51, owner: 700000052d4d530, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=70000004fd516b8 handle=70000004eba7c18 mode=N
call pin=70000004fd6c818 session pin=0
user=700000052d4d530 session=700000052d4d530 count=1 flags=CBB/[02] savepoint=67
LIBRARY OBJECT HANDLE: handle=70000004eba7c18
name=CCIC.CCIC
hash=76bb12a3 timestamp=12-31-4712 23:59:59
namespace=EVNT flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0009-0009 lock=N pin=0 latch#=1
lwt=70000004eba7c48[70000004eba7c48,70000004eba7c48] ltm=70000004eba7c58[70000004eba7c58,70000004eba7c58]
pwt=70000004eba7c78[70000004eba7c78,70000004eba7c78] ptm=70000004eba7d08[70000004eba7d08,70000004eba7d08]
ref=70000004eba7c28[70000004eba7c28, 70000004eba7c28] lnd=70000004eba7d20[70000004eba7d20,70000004eba7d20]
LIBRARY OBJECT: object=7000000154dfc78
type=EVNT flags=EXS/LOC[0005] pflags= [00] status=VALD load=0
DATA BLOCKS:
data# heap pointer status pins change
----- -------- -------- ------ ---- ------
0 7000000154dfe68 7000000108f5630 I/-/A 0 NONE
3 7000000154dfd98 70000002336d9e8 I/-/A 0 NONE
----------------------------------------
SO: 700000036e44030, type: 50, owner: 700000052d4d530, flag: INIT/-/-/0x00
user lock: lock=700000036e44030 mode=S
user resource: user=70000004fb193e8 uid=43 mode=S
----------------------------------------
SO: 700000036e38940, type: 50, owner: 700000052d4d530, flag: INIT/-/-/0x00
user lock: lock=700000036e38940 mode=S
user resource: user=70000004fb193e8 uid=43 mode=S
----------------------------------------
SO: 700000050eec2a8, type: 39, owner: 700000052d4d530, flag: INIT/-/-/0x00
(dummy) nxc=1, nlb=0
----------------------------------------
SO: 700000050e9fee8, type: 38, owner: 700000050eec2a8, flag: INIT/-/-/0x00
(trans) bsn = 1988, flg = 0x04, flg2 = 0x00, prx = 0x700000050e95250, ros = 2147483647, spn = 1988
efd = 10
parent xid: 0x0000.000.00000000
env: (scn: 0x0000.0324ab79 xid: 0x0006.02b.00009327 uba: 0x054004e3.1b3d.03 statement num=0 parent xid: xid: 0x0000.000.00000000 scn: 0x0000.0324ab78 0sch: scn: 0x0000.00000000)
cev: (spc = 7852 arsp = 0 ubk tsn: 1 rdba: 0x054004e3 useg tsn: 2147483647 rdba: 0x00000000
hwm uba: 0x054004e3.1b3d.03 col uba: 0x00000000.0000.00
num bl: 0 bk list: 0x0)
(enqueue) TX-00060028-0000932A DID: 0001-00A8-00000002
lv: 03 24 b1 f3 00 00 82 a8 00 00 00 00 00 00 00 00
res: 700000051347ac8, prv: 700000051347ad8, sess: 700000052d4d530, proc: 700000052bd34f8
xga: 0x0, heap: UGA
----------------------------------------
SO: 7000000513ea488, type: 13, owner: 700000052bd34f8, flag: INIT/-/-/0x00
(broadcast handle) flag: (2) ACTIVE SUBSCRIBER, owner: 700000052bd34f8,
event: 292, last message event: 292,
last message waited event: 292, messages read: 0
channel: (70000005141e670) system events broadcast channel
scope: 0, event: 1765, last mesage event: 0,
publishers/subscribers: 0/326,
messages published: 0
----------------------------------------
SO: 7000000340fc4f0, type: 3, owner: 700000052bd34f8, flag: INIT/-/-/0x00
(call) sess: cur 700000052d4d530, rec 0, usr 700000052d4d530; depth: 0
===================================================
CURRENT SESSION'S INSTANTIATION STATE
-------------------------------------
current session=700000052d4d530
-------------------------------------
INSTANTIATION OBJECT: object=11050d708
type="KOKA open cursor"[3] lock=0 handle=0 body=0 level=0
flags=FST[60] executions=0
REST OF INSTANTIATION OBJECT:
address=11050d7a0 size=16
00000000 00000005 0000000a 00000000
-------------------------------------
INSTANTIATION OBJECT: object=11050d648
type="KOKA pseudo cursor"[4] lock=0 handle=0 body=0 level=0
flags=FST[60] executions=0
REST OF INSTANTIATION OBJECT:
address=11050d6e0 size=16
00000000 00000005 0000000a 00000000
-------------------------------------
INSTANTIATION OBJECT: object=11050b670
type="cursor"[2] lock=70000001ffa8d50 handle=700000026536678 body=0 level=0
flags=FST[60] executions=0
REST OF INSTANTIATION OBJECT:
address=11050b708 size=720
07000000 17f66870 07000000 52005fe0 07000000 2d193728 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00100024 10040000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000002 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000001 10500380 00000006 06000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 0000002b 0000002b 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000
******************** Cursor Dump ************************
Current cursor: 1, pgadep: 0
Cursor Dump:
----------------------------------------
Cursor 1 (110500380): CURBOUND curiob: 11050b670
curflg: 4c curpar: 0 curusr: 0 curses 700000052d4d530
cursor name:
Update PrpCmain Set PolicyNo = 'PDAA200451010702001021', ClassCode = 'D', RiskCode = 'DAA', ProposalNo = 'TDAA200451010702001038', ContractNo = '', PolicySort = '1', PrintNo = '0000019664', BusinessNature = '0', Language = 'C', PolicyType = '', AppliCode = '5101076000013021', AppliName = '**', AppliAddress = '', InsuredCode = '5101070000001798', InsuredName = '***', InsuredAddress = '', OperateDate = '2004-06-01', StartDate = '2004-06-10', StartHour = '0', EndDate = '2005-06-09', EndHour = '24', PureRate = '0.0', DisRate = '0.0', Discount = '0.0', Currency = 'CNY', SumValue = '0.0', SumAmount = '170000.0', SumDiscount = '794.3', SumPremium = '2150.96', SumSubPrem = '475.11', SumQuantity = '1', JudicalScope = '***', AutoTransRenewFlag = '', ArgueSolution = '2', ArbitBoardName = '***', PayTimes = '1', EndorseTimes = '0', ClaimTimes = '0', MakeCom = '51010702', OperateSite = '', ComCode = '51010702', HandlerCode = '5101000115', Handler1Code = '5101000115', ApproverCode = '5101000051', UnderWriteCode = '5101000070', UnderWriteName = '***', OperatorCode = '5101000050', InputDate = '2004-06-01', InputHour = '15', UnderWriteEndDate = '2004-06-01', StatisticsYM = '2004-06-10', AgentCode = '', CoinsFlag = '0', ReinsFlag = '0', AllinsFlag = '0', UnderWriteFlag = '1', OthFlag = '000000YY00', Flag = '' Where PolicyNo = 'PDAA200451010702001021'
child pin: 70000002d193728, child lock: 700000052005fe0, parent lock: 70000001ffa8d50
xscflg: 100024, parent handle: 700000026536678, xscfl2: 10040000
nxt: 11.0x00000a10 nxt: 10.0x000004e8 nxt: 9.0x00000238 nxt: 8.0x00000780
nxt: 7.0x00000680 nxt: 6.0x000007d0 nxt: 5.0x000007c8 nxt: 4.0x000007c0
nxt: 3.0x000007c8 nxt: 2.0x000007c8 nxt: 1.0x000007d0
Cursor frame allocation dump:
frm: -------- Comment -------- Size Seg Off
End of cursor dump
END OF PROCESS STATE |
|
免费注册
发表于 2004-06-07 10:55