OERI 1158 - cheeyoung/sqlplus-public GitHub Wiki

Neither LocK MODe held nor LocK mode REQuested were initialized

  • ksqgtlctx
  • ktuGetTxForXcb
  • ktubnd
  • ktubgn
  • npibeg
  • kpnpre
  • upirtrc
  • kpurcsc
  • kpuexec
  • OCIStmtExecute
...
122280        ----------------------------------------
122281        SO: 0xc0000006ec621ba8, type: 58, owner: 0xc00000072a1243e8, flag: INIT/-/-/0x00 if: 0x3 c: 0x3
122282         proc=0xc0000007257af990, name=branch, file=ktccts.h LINE:420 ID:, pg=0
122283        (branch) trn = 0xc00000070be40bb8, flg = 0x40000, state = 0x00 bno=1 ser=30 evt=30
122284         creator = 0xc00000072a1243e8 uid = 0x3b serial# = 27173 ttl = 0x0 dtm = 0x0
122285         2PCrole = (nch = 0x0 flg = 0x0) DTP svc = 0xc000000723ff9de8
122286           gti.fmt: 0004ac1e  gti.tln: 28  gti.bln: 26
122287           gti.tid = ....f9dfa43b.786.6.193159
122288           gti.bid = ...[786.6.193159][1.17]
122289          ----------------------------------------
122290          SO: 0xc00000070be40bb8, type: 56, owner: 0xc0000006ec621ba8, flag: INIT/-/-/
0x00 if: 0x3 c: 0x3
122291           proc=0xc0000007257af990, name=transaction, file=ktccts.h LINE:410 ID:, pg=0
122292          (trans) flg = 0x00401203, flg2 = 0x04080000, flg3 = 0x00000000, prx = 0x0000000000000000, ros = 2147483647, crtses=0xc00000072a1243e8
122293          flg  = 0x00401203: ALC TRN VUS USN DTR
122294          flg2 = 0x04080000: NIP TMSG
122295          flg3 = 0x00000000:
122296          bsn = 0x3a bndsn = 0x116 spn = 0x128
122297          efd = 4 rfd = 0 DID:
122298          file:./ktdbas.h lineno:274
122299          parent xid: 0x0000.000.00000000
122300          env [0xc00000070be40fd0]: (scn: 0x0d12.9ae6fe32  xid: 0x07ac.00d.002fc4a4  uba: 0x00000000.0000.00  statement num=0  parent xid: 0x0000.000.00000000  st-scn: 0x0000.00000000  hi-scn: 0x0000.00000000  ma-scn: 0x0000.00000000  flg: 0x00000000)
122301          cev: (spc = 0  arsp = 0xc0000006ec8ffd90  ubkds (ubk:tsn: 2 rdba: 0x074be61b
 flag:0x48 hdl:0x0000000000000000 addr:0x0000000000000000)  useg tsn: 2 rdba: 0x00c13da0
122302                hwm uba: 0x00000000.0000.00  col uba: 0x00000000.0000.00
122303                num bl: 0 bk list: 0x0)
122304                cr opc: 0x1 spc: 5972 uba: 0x074be61b.810a.0b
122305          Begin scn:0x0000.00000000 uba:0x00000000.0000.00 ts:1492598510[04/19/2017 19:41:50]
122306          Undo blks: 0 recs: 0
122307          ccbstg: 0x00000000
122308          active session: 0x0000000000000000
122309          dtx: (dix = 0x32)
122310          (te.gtrid 0xc0000006f1949fc0) ....f9dfa43b.786.6.193159
122311            #branches = 1, type = 0x2, flg = 0x00
122312            branches     =  c0000006ec621ba8
122313            transactions =  c00000070be40bb8
122314            branch#0 #refs = 1, #prep'd = 0, flags = 0x200, npi = N, ltidx = 255
122315             bt.bid: ...[786.6.193159][1.17]
122316             gti.fmt: 0004ac1e  gti.tln: 28  gti.bln: 26
122317             gti.tid = ....f9dfa43b.786.6.193159
122318             gti.bid = ...[786.6.193159][1.17]
122319          (enqueue) TX-07AC000D-002FC4A4  DID: 0001-0154-031EF610
122320          lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  res_flag: 0x47
122321          mode: X, lock_flag: 0x0, lock: 0xc00000070be40c30, res: 0xc00000072327ab98
122322          own: 0xc00000072a1243e8, sess: 0xc00000072a1243e8, proc: 0xc0000007257af990, prv: 0xc00000072327aba8
122323          slk: 0x0000000000000000
122324           xga: 0x0000000000000000, heap: UGA
122325          tsnl:0xc0000006ab0c9058 nent:0 nxt:0x0000000000000000
122326          Trans IMU st: 0 Pool index 65535, Redo pool 0xc00000070be41378, Undo pool 0xc00000070be41460
122327          Redo pool range [0xc00000063897f818 0xc00000063897f818 0xc000000638982018]
122328          Undo pool range [0xc00000063897d018 0xc00000063897d018 0xc00000063897f818]
122329           chnf control flags 0x0           CHNF hwm uba uba: 0x00000000.0000.00
----------------------------------------
...