[Oracle]记录一个ORA-00600错
博客首页 » Oracle记录一个ORA-00600错
发布于 29 Aug 2014 23:52
标签 blog
记录一个ORA-00600错。
这是ORA-00600的Session与打开的游标的问题。
alert.log的内容
Wed Aug 27 18:08:21 2014
Errors in file /u01/oracle/app/admin/orcl/udump/orcl_ora_26789.trc:
ORA-00600: internal error code, arguments: [17281], [1001], [0x15CEBA048], [], [], [], [], []
ORA-01001: invalid cursor
Wed Aug 27 18:08:25 2014
Errors in file /u01/oracle/app/admin/orcl/udump/orcl_ora_26789.trc:
ORA-00600: internal error code, arguments: [17281], [1001], [0x15CEBA048], [], [], [], [], []
ORA-01001: invalid cursor
ORA-00600: internal error code, arguments: [17281], [1001], [0x15CEBA048], [], [], [], [], []
ORA-01001: invalid cursor
trace文件里可以看到调用堆栈。
/u01/oracle/app/admin/orcl01/udump/orcl01_ora_26789.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /u01/oracle/app/oracle/product/10.2.0/db_1
System name: Linux
Node name: srvtest
Release: 2.6.9-89.ELlargesmp
Version: #1 SMP Mon Apr 20 10:43:12 EDT 2009
Machine: x86_64
Instance name: orcl01
Redo thread mounted by this instance: 1
Oracle process number: 245
Unix process pid: 26789, image: oracle@srvtest
*** 2014-08-27 16:28:46.588
*** ACTION NAME:() 2014-08-27 16:28:46.574
*** MODULE NAME:(SQL Developer) 2014-08-27 16:28:46.574
*** SERVICE NAME:(SYS$USERS) 2014-08-27 16:28:46.574
*** SESSION ID:(878.43671) 2014-08-27 16:28:46.574
WARNING:io_submit failed due to kernel limitations MAXAIO for process=128 pending aio=0
WARNING:asynch I/O kernel limits is set at AIO-MAX-NR=65536 AIO-NR=39808
WARNING:Oracle process running out of OS kernel I/O resources (1)
*** 2014-08-27 16:29:42.401
WARNING:Oracle process running out of OS kernel I/O resources (1)
*** 2014-08-27 16:31:04.102
WARNING:Oracle process running out of OS kernel I/O resources (1)
*** 2014-08-27 16:32:29.866
WARNING:Oracle process running out of OS kernel I/O resources (1)
*** 2014-08-27 16:33:17.703
WARNING:Oracle process running out of OS kernel I/O resources (1)
*** 2014-08-27 18:08:21.238
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [17281], [1001], [0x15CEBA048], [], [], [], [], []
ORA-01001: invalid cursor
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
sdtcs_getexecname: using /u01/oracle/app/oracle/product/10.2.0/db_1/bin/oracle for executable
ksedst()+31 call ksedst1() 000000000 ? 000000001 ?
7FBFFF9F50 ? 7FBFFF9FB0 ?
7FBFFF9EF0 ? 000000000 ?
ksedmp()+610 call ksedst() 000000000 ? 000000001 ?
7FBFFF9F50 ? 7FBFFF9FB0 ?
7FBFFF9EF0 ? 000000000 ?
ksfdmp()+21 call ksedmp() 000000003 ? 000000001 ?
7FBFFF9F50 ? 7FBFFF9FB0 ?
7FBFFF9EF0 ? 000000000 ?
kgeriv()+176 call ksfdmp() 000000003 ? 000000001 ?
7FBFFF9F50 ? 7FBFFF9FB0 ?
7FBFFF9EF0 ? 000000000 ?
kgeasi()+263 call kgeriv() 0066876E0 ? 006707380 ?
000000000 ? 15B7F2848 ?
7FBFFF9EF0 ? 000000000 ?
kgicli()+706 call kgeasi() 0066876E0 ? 006707380 ?
000004381 ? 000000002 ?
000000002 ? 000000000 ?
kgiscl()+110 call kgicli() 2A9739E920 ? 000000001 ?
000004381 ? 000000002 ?
000000002 ? 000000000 ?
ksuxds()+590 call kgiscl() 2A9739E920 ? 000004381 ?
000004381 ? 000000002 ?
000000002 ? 000000000 ?
ksudel()+56 call ksuxds() 000004381 ? 000000001 ?
000004381 ? 000000002 ?
000000002 ?
3D10AA3200000000 ?
opilof()+1767 call ksudel() 15A688E88 ? 000000001 ?
000004381 ? 000000002 ?
000000002 ?
3D10AA3200000000 ?
opiodr()+984 call opilof() 000000009 ? 000000000 ?
7FBFFFE2F0 ? 000000002 ?
000000002 ?
3D10AA3200000000 ?
ttcpip()+1012 call opiodr() 000000009 ? 000000000 ?
7FBFFFE2F0 ? 000000000 ?
0059B0568 ?
3D10AA3200000000 ?
opitsk()+1322 call ttcpip() 00668F3B0 ? 7FBFFFE458 ?
7FBFFFE2F0 ? 000000000 ?
7FBFFFDDE8 ? 7FBFFFE458 ?
opiino()+1026 call opitsk() 000000003 ? 000000000 ?
7FBFFFE2F0 ? 000000001 ?
000000000 ? 67107F500000000 ?
opiodr()+984 call opiino() 00000003C ? 000000004 ?
7FBFFFF4B8 ? 000000000 ?
000000000 ? 67107F500000000 ?
opidrv()+547 call opiodr() 00000003C ? 000000004 ?
7FBFFFF4B8 ? 000000000 ?
0059B0D60 ? 67107F500000000 ?
sou2o()+114 call opidrv() 00000003C ? 000000004 ?
7FBFFFF4B8 ? 000000000 ?
0059B0D60 ? 67107F500000000 ?
opimai_real()+163 call sou2o() 7FBFFFF490 ? 00000003C ?
000000004 ? 7FBFFFF4B8 ?
0059B0D60 ? 67107F500000000 ?
main()+116 call opimai_real() 000000002 ? 7FBFFFF520 ?
000000004 ? 7FBFFFF4B8 ?
0059B0D60 ? 67107F500000000 ?
__libc_start_main() call main() 000000002 ? 7FBFFFF520 ?
+219 000000004 ? 7FBFFFF4B8 ?
0059B0D60 ? 67107F500000000 ?
_start()+42 call __libc_start_main() 000713988 ? 000000002 ?
7FBFFFF668 ? 005288D00 ?
000000000 ? 000000002 ?
--------------------- Binary Stack Dump ---------------------
========== FRAME [1] (ksedst()+31 -> ksedst1()) ==========
RDI 0000000000000000 RSI 0000000000000001 RDX 0000007FBFFF9F50
RCX 0000007FBFFF9FB0 R8 0000007FBFFF9EF0 R9 0000000000000000
RAX 000000015B7F2848 RBX 0000000000000000 RBP 0000007FBFFFAA20
R10 000000000669A52C R11 0000000000000001 R12 00000000052EBEA0
R13 00000000066876E0 R14 0000000000000002 R15 0000000006707380
RSP 0000007FBFFFAA20 RIP 0000000000753B19
Dump of memory from 0x0000007FBFFF5940 to 0x0000007FBFFF5D40
7FBFFF5940 052DF830 00000000 0000001C 00000000 [0.-.............]
7FBFFF5950 052DF854 00000000 5A966AD0 00000001 [T.-......j.Z....]
7FBFFF5960 BFFF9F50 0000007F BFFF9FB0 0000007F [P...............]
7FBFFF5970 BFFF9EF0 0000007F 066876E0 00000000 [.........vh.....]
7FBFFF5980 06707380 00000000 5B7F2848 00000001 [.sp.....H(.[....]
7FBFFF5990 9739E920 0000002A 5A688E88 00000001 [ .9.*.....hZ....]
.....
========== FRAME [2] (ksedmp()+610 -> ksedst()) ==========
RDI 0000000000000000 RSI 0000000000000001 RDX 0000007FBFFF9F50
RCX 0000007FBFFF9FB0 R8 0000007FBFFF9EF0 R9 0000000000000000
RAX 000000015B7F2848 RBX 0000000000000000 RBP 0000007FBFFFAC40
R10 000000000669A52C R11 0000000000000001 R12 00000000052EBEA0
R13 00000000066876E0 R14 0000000000000002 R15 0000000006707380
RSP 0000007FBFFFAA30 RIP 0000000000752356
Dump of memory from 0x0000007FBFFFAA20 to 0x0000007FBFFFAA30
7FBFFFAA20 BFFFAC40 0000007F 00752356 00000000 [@.......V#u.....]
========== FRAME [3] (ksfdmp()+21 -> ksedmp()) ==========
RDI 0000000000000003 RSI 0000000000000001 RDX 0000007FBFFF9F50
RCX 0000007FBFFF9FB0 R8 0000007FBFFF9EF0 R9 0000000000000000
RAX 000000015B7F2848 RBX 00000000066876E0 RBP 0000007FBFFFAC50
R10 000000000669A52C R11 0000000000000001 R12 00000000052EBEA0
R13 00000000066876E0 R14 0000000000000002 R15 0000000006707380
RSP 0000007FBFFFAC50 RIP 000000000079B93F
Dump of memory from 0x0000007FBFFFAA30 to 0x0000007FBFFFAC50
7FBFFFAA30 00000001 00000000 5CEBA048 00000000 [........H..\....]
7FBFFFAA40 FFFFFFFF 00000000 FFFFFFFF 00000000 [................]
7FBFFFAA50 06687860 00000000 066876E0 00000000 [`xh......vh.....]
.....
Argument/Register addr=0x00000000013284C4.
Dump of memory from 0x0000000001328484 to 0x00000000013285C4
001328480 C7C7486A 0668E428 89C2894C [jH..(.h.L...]
001328490 C03345C1 CDE8C033 480090F4 FF70B58B [.E3.3......H..p.]
0013284A0 458BFFFF 7D8B4898 D0634888 2DE8C933 [...E.H.}.Hc.3..-]
0013284B0 48000008 48C0558B 33107A8B E8C033F6 [...H.U.H.z.3.3..]
0013284C0 FFFFCBB6 85B04589 4C1975C0 4CD07D8B [.....E...u.L.}.L]
0013284D0 4CD8758B 4CE06D8B 48E8658B 48F05D8B [.u.L.m.L.e.H.].H]
0013284E0 C35DEC89 C033C789 4275A3E8 0FDCEBFF [..]...3...uB....]
0013284F0 F6615BB6 8D7440C3 091D8B48 4805370E [.[a..@t.H....7.H]
001328500 48087B8B 06E8C781 80EB0000 C0458B48 [.{.H........H.E.]
001328510 8B008B4C 894C0840 FFFF7085 984589FF [L...@.L..p....E.]
001328520 FFFF54E9 C6C748FF 054D2540 70B58948 [.T...H..@%M.H..p]
001328530 B8FFFFFF 00000003 E9984589 FFFFFF65 [.........E..e...]
001328540 14C7C748 48054D25 C033CA89 471B77E8 [H...%M.H..3..w.G]
001328550 947D8BFF 75358B48 BA053710 00000261 [..}.H.5u.7..a...]
001328560 3FE8C033 E901139B FFFFFEC4 608D8B48 [3..?........H..`]
001328570 EBFFFFFF 33C789CB 7512E8C0 82E9FF42 [.......3...uB...]
001328580 8BFFFFFE FFFF78BD C2C748FF 054D2508 [.....x...H...%M.]
001328590 C033F633 1396C1E8 FE35E901 8B48FFFF [3.3.......5...H.]
0013285A0 08838845 158B4810 0537028C 0FD28548 [E....H....7.H...]
0013285B0 FFFDEB84 D0828BFF 0D000000 00001000 [................]
0013285C0 00D08289 [....]
----- End of Call Stack Trace -----
******************* Dumping process map ****************
00400000-06600000 r-xp 00000000 08:03 389522 /u01/oracle/app/oracle/product/10.2.0/db_1/bin/oracle
06600000-06688000 rw-p 06200000 08:03 389522 /u01/oracle/app/oracle/product/10.2.0/db_1/bin/oracle
06688000-0675a000 rwxp 06688000 00:00 0
60000000-160200000 rw-s 00000000 00:06 131073 /SYSV4aa5bb78 (deleted)
2a95556000-2a95557000 rw-p 2a95556000 00:00 0
.....
ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0
******************* End of process map dump ****************
===================================================
PROCESS STATE
-------------
Process global information:
process: 0x15b49ede0, call: 0x153c52cc8, xact: (nil), curses: 0x15a688e88, usrses: 0x15a688e88
----------------------------------------
SO: 0x15b49ede0, type: 2, owner: (nil), flag: INIT/-/-/0x00
(process) Oracle pid=245, calls cur/top: 0x153c52cc8/0x153c52cc8, flag: (0) -
int error: 0, call error: 0, sess error: 0, txn error 0
(post info) last post received: 0 0 25
last post received-location: ksasnr
last process to post me: 15b477560 1 6
last post sent: 0 0 24
last post sent-location: ksasnd
last process posted by me: 15f4736e0 1 6
(latch info) wait_event=0 bits=0
Process Group: DEFAULT, pseudo proc: 0x15f5171b0
O/S info: user: ora_orcl01_ar, term: UNKNOWN, ospid: 26789
OSD pid info: Unix process pid: 26789, image: oracle@srvtest
Dump of memory from 0x000000015F452730 to 0x000000015F452938
15F452730 0000000D 00000000 598E3FB8 00000001 [.........?.Y....]
15F452740 00000007 000313A7 5785EC80 00000001 [...........W....]
15F452750 00000006 000313A7 5785F020 00000001 [........ ..W....]
.....
(FOB) flags=2 fib=0x15781a5f8 incno=0 pending i/o cnt=0
fname=/u02/oradata/orcl01/undotbs_01.dbf
fno=2 lblksz=8192 fsiz=1310720
----------------------------------------
SO: 0x15b868118, type: 11, owner: 0x15b49ede0, flag: INIT/-/-/0x00
(broadcast handle) flag: (1) PUBLISHER, owner: 0x15b49ede0,
event: 7107, last message event: 0,
last message waited event: 0, messages published: 1
channel: (0x15f973e60) obj broadcast channel
scope: 7, event: 7108, last mesage event: 7108,
publishers/subscribers: 1/1,
messages published: 6849
(FOB) flags=2 fib=0x15781b830 incno=0 pending i/o cnt=0
fname=/u02/oradata/orcl01/sysaux01.dbf
fno=7 lblksz=8192 fsiz=1284608
.....
(FOB) flags=2 fib=0x15781a258 incno=0 pending i/o cnt=0
fname=/u02/oradata/orcl01/system01.dbf
fno=1 lblksz=8192 fsiz=78080
----------------------------------------
SO: 0x15a688e88, type: 4, owner: 0x15b49ede0, flag: INIT/-/-/0x00
(session) sid: 878 trans: (nil), creator: 0x15b49ede0, flag: (100041) USR/- BSY/-/-/DEL/-/-
DID: 0001-00F5-001D6965, short-term DID: 0000-0000-00000000
txn branch: (nil)
oct: 0, prv: 0, sql: (nil), psql: 0x15c8d8240, user: 28/PAD_CD_USR
service name: SYS$USERS
O/S info: user: cyber-go, term: unknown, ospid: 4204, machine: D051846
program: SQL Developer
last wait for 'SQL*Net message from client' blocking sess=0x(nil) seq=55779 wait_time=1432 seconds since wait started=1
driver id=74637000, #bytes=1, =0
Dumping Session Wait History
for 'SQL*Net message from client' count=1 wait_time=1432
driver id=74637000, #bytes=1, =0
for 'SQL*Net message to client' count=1 wait_time=1
driver id=74637000, #bytes=1, =0
.....
temporary object counter: 3
----------------------------------------
Virtual Thread:
kgskvt: 0x15d99e460, sess: 0x15a688e88, vc: (nil), proc: 0x15b49ede0, numapg: 1
consumer group cur: OTHER_GROUPS (upd? 0), mapped: DEFAULT_CONSUMER_GROUP, orig:
vt_state: 0x200, vt_flags: 0x8030, blkrun: 0
is_assigned: 1, in_sched: 0 (0)
vt_active: 0 (pending: 1)
used quanta: 0 (cg: 0)
cpu start time: 0, quantum status: 0x0
quantum checks to skip: 0, check thresh: 0
idle time: 0, active time: 0 (cg: 0)
cpu yields: 0 (cg: 0), waits: 0 (cg: 0), wait time: 0 (cg: 0)
queued time outs: 0, time: 0 (cur 0, cg 0)
calls aborted: 0, num est exec limit hit: 0
undo current: 0k max: 0k
----------------------------------------
UOL used : 0 locks(used=4, free=5)
KGX Atomic Operation Log 0x15cb397d0
Mutex (nil)(0, 0) idn 0 oper NONE
Cursor Parent uid 878 efd 5 whr 22 slp 0
oper=NONE pt1=0x13fc63158 pt2=0x13fc63340 pt3=0x13fc63860
pt4=(nil) u41=0 stt=0
KGX Atomic Operation Log 0x15cb39818
Mutex 0x15dc32d70(0, 0) idn 0 oper NONE
Cursor Stat uid 878 efd 8 whr 2 slp 0
oper=NONE pt1=(nil) pt2=(nil) pt3=(nil)
pt4=(nil) u41=0 stt=8
KGX Atomic Operation Log 0x15cb39860
Mutex (nil)(0, 0) idn 0 oper NONE
Library Cache uid 878 efd 0 whr 0 slp 0
----------------------------------------
SO: 0x153796b70, type: 53, owner: 0x15a688e88, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=153796b70 handle=15c2fe458 mode=N
call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
htl=0x153796bf0[0x153f9b520,0x15263a7a0] htb=0x15263a7a0 ssga=0x152639728
user=15a688e88 session=15a688e88 count=1 flags=[0000] savepoint=0x0
LIBRARY OBJECT HANDLE: handle=15c2fe458 mtx=0x15c2fe588(0) cdp=0
namespace=CRSR flags=RON/KGHP/PN0/EXP/[10010100]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch#=1 hpc=ffd2 hlc=ffd2
lwt=0x15c2fe500[0x15c2fe500,0x15c2fe500] ltm=0x15c2fe510[0x15c2fe510,0x15c2fe510]
pwt=0x15c2fe4c8[0x15c2fe4c8,0x15c2fe4c8] ptm=0x15c2fe4d8[0x15c2fe4d8,0x15c2fe4d8]
ref=0x15c2fe530[0x13fef1570,0x13fef1570] lnd=0x15c2fe548[0x15c2fe548,0x15c2fe548]
LIBRARY OBJECT: object=13fef1130
type=CRSR flags=EXS[0001] pflags=NST[0001] status=VALD load=0
DEPENDENCIES: count=7 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=2 size=16
TRANSLATIONS: count=2 size=16
SCHEMA: count=6 size=262144
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 15cc85dc8 13fef1248 I/P/A/-/- 0 NONE 00
6 150dc9120 1468183f0 I/-/A/-/E 0 NONE 00
----------------------------------------
SO: 0x153f9b4a0, type: 53, owner: 0x15a688e88, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=153f9b4a0 handle=15c8d8240 mode=N
call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
htl=0x153f9b520[0x15263a7a0,0x153796bf0] htb=0x15263a7a0 ssga=0x152639728
user=15a688e88 session=15a688e88 count=1 flags=[0000] savepoint=0x53fda005
LIBRARY OBJECT HANDLE: handle=15c8d8240 mtx=0x15c8d8370(1) cdp=1
name=/*+ no_sql_translation */
SELECT dbms_transaction.local_transaction_id FROM dual
hash=e91272eadc5fb3feb01835516a33e1f6 timestamp=08-22-2014 09:40:16
namespace=CRSR flags=RON/KGHP/TIM/PN0/MED/KST/DBN/MTX/[500100d0]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch#=1 hpc=0058 hlc=0058
lwt=0x15c8d82e8[0x15c8d82e8,0x15c8d82e8] ltm=0x15c8d82f8[0x15c8d82f8,0x15c8d82f8]
pwt=0x15c8d82b0[0x15c8d82b0,0x15c8d82b0] ptm=0x15c8d82c0[0x15c8d82c0,0x15c8d82c0]
ref=0x15c8d8318[0x15c8d8318,0x15c8d8318] lnd=0x15c8d8330[0x15c8d8330,0x15c8d8330]
LIBRARY OBJECT: object=150dc9300
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
CHILDREN: size=16
child# table reference handle
------ -------- --------- --------
0 13fef1900 13fef1570 15c2fe458
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 15c9c16e8 150dc9418 I/P/A/-/- 0 NONE 00
----------------------------------------
SO: 0x153d54e60, type: 53, owner: 0x15a688e88, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=153d54e60 handle=144bf6f18 mode=N
call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
htl=0x153d54ee0[0x153d553e8,0x15263a6b0] htb=0x15263a6b0 ssga=0x152639728
user=15a688e88 session=15a688e88 count=1 flags=[0000] savepoint=0x0
LIBRARY OBJECT HANDLE: handle=144bf6f18 mtx=0x144bf7048(0) cdp=0
namespace=CRSR flags=RON/KGHP/PN0/EXP/[10010100]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch#=8 hpc=ff0c hlc=ff0c
lwt=0x144bf6fc0[0x144bf6fc0,0x144bf6fc0] ltm=0x144bf6fd0[0x144bf6fd0,0x144bf6fd0]
pwt=0x144bf6f88[0x144bf6f88,0x144bf6f88] ptm=0x144bf6f98[0x144bf6f98,0x144bf6f98]
ref=0x144bf6ff0[0x14c2060b0,0x14c2060b0] lnd=0x144bf7008[0x144bf7008,0x144bf7008]
LIBRARY OBJECT: object=13b6ada18
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
DEPENDENCIES: count=3 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
SCHEMA: count=5 size=262144
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 144d5c680 13b6adb30 I/P/A/-/- 0 NONE 00
6 14c206798 14b9967d8 I/-/A/-/E 0 NONE 00
----------------------------------------
SO: 0x153d55368, type: 53, owner: 0x15a688e88, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=153d55368 handle=144bf7140 mode=N
call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
htl=0x153d553e8[0x153df6480,0x153d54ee0] htb=0x15263a6b0 ssga=0x152639728
user=15a688e88 session=15a688e88 count=1 flags=[0000] savepoint=0x53fda005
LIBRARY OBJECT HANDLE: handle=144bf7140 mtx=0x144bf7270(1) cdp=1
name=/*+ no_sql_translation */
SELECT 1 FROM dual
hash=ae6aa451a1768992dc63861082188de7 timestamp=07-22-2014 09:17:48
namespace=CRSR flags=RON/KGHP/TIM/PN0/SML/KST/DBN/MTX/[120100d0]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch#=8 hpc=00ce hlc=00ce
lwt=0x144bf71e8[0x144bf71e8,0x144bf71e8] ltm=0x144bf71f8[0x144bf71f8,0x144bf71f8]
pwt=0x144bf71b0[0x144bf71b0,0x144bf71b0] ptm=0x144bf71c0[0x144bf71c0,0x144bf71c0]
ref=0x144bf7218[0x144bf7218,0x144bf7218] lnd=0x144bf7230[0x144bf7230,0x144bf7230]
LIBRARY OBJECT: object=14c206978
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
CHILDREN: size=16
child# table reference handle
------ -------- --------- --------
0 14c206440 14c2060b0 144bf6f18
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 144bf7080 14c206a90 I/P/A/-/- 0 NONE 00
----------------------------------------
.....
----------------------------------------
SO: 0x153c52cc8, type: 3, owner: 0x15b49ede0, flag: INIT/-/-/0x00
(call) sess: cur 15a688e88, rec 0, usr 15a688e88; depth: 0
----------------------------------------
SO: 0x152a15668, type: 16, owner: 0x15b49ede0, flag: INIT/-/-/0x00
(osp req holder)
===================================================
CURRENT SESSION'S INSTANTIATION STATE
-------------------------------------
current session=0x15a688e88
KGI STATE DUMP for session=0x15a688e88
-------------------------------------
INSTANTIATION OBJECT: object=0x2aa0218f10
type="PL/SQL"[0] lock=0x153a87808 handle=0x15df23dd8 body=(nil) level=0
flags=SHR/NST/LRU[1045] executions=2
REST OF INSTANTIATION OBJECT:
address=0x2aa0218fd8 size=184
0x00000d (nil) 0xa0218f10 0x00002a 0x668f3b0 (nil) (nil) (nil)
0xa0443f40 0x00002a (nil) (nil) 0x2a0022 0x00002a 0x4ddc28e0 0x000001
(nil) (nil) (nil) (nil) (nil) (nil) (nil) (nil)
(nil) (nil) (nil) (nil) (nil) (nil) (nil) (nil)
(nil) (nil) (nil) (nil) 0x000fa9 (nil) (nil) (nil)
(nil) (nil) (nil) (nil) (nil) (nil)
-------------------------------------
INSTANTIATION OBJECT: object=0x2a97407188
type="PL/SQL"[0] lock=0x1538b3198 handle=0x15ddd5bd0 spec=0x2aa02986f0 level=0
flags=SHR/BDY/[43] executions=1
REST OF INSTANTIATION OBJECT:
address=0x2a97407250 size=184
0xffffffff (nil) 0xa02986f0 0x00002a 0x668f3b0 (nil) (nil) (nil)
0xa0295598 0x00002a (nil) (nil) 0x290020 0x000029 0x4d497530 0x000001
(nil) (nil) (nil) (nil) (nil) (nil) (nil) (nil)
(nil) (nil) (nil) (nil) (nil) (nil) (nil) (nil)
(nil) (nil) (nil) (nil) 0x00478d (nil) (nil) (nil)
(nil) (nil) (nil) (nil) (nil) (nil)
-------------------------------------
.....
-------------------------------------
INSTANTIATION OBJECT: object=0x2a9721b208
type="KOKA pseudo cursor"[2] lock=(nil) handle=(nil) body=(nil) level=0
flags=[40] executions=0
CURSORS: size=4 count=4 next=5
index cursor tag context flags
----- ------ -------- -------- ---------------
1 8 (nil) 0x2a973a7eb8 LRU/PRS/PST[07]
2 9 (nil) 0x2a973948e8 LRU/PRS/PST[07]
3 10 (nil) 0x2a9739e320 LRU/PRS/PST[07]
4 1 (nil) 0x2a9739b8e0 LRU/PRS/PST[07]
REST OF INSTANTIATION OBJECT:
address=0x2a9721b2d0 size=16
0x000004 0x000005 0x00000a (nil)
KGI STATE DUMP DONE for session=0x15a688e88
******************** Session Cursor Dump **********************
Current cursor: 0, pgadep: 0
Open cursors(pls, sys, hwm, max): 5(1, 4, 64, 300)
NULL 4 SYNTAX 0 PARSE 0 BOUND 1 FETCH 0 ROW 0
Cached frame pages(total, free):
4k(78, 78), 8k(9, 9), 16k(2, 2), 32k(0, 0)
----------------------------------------
Cursor#4(0x2a97211848) state=BOUND curiob=0x2a973e4208
curflg=c7 fl2=0 par=(nil) ses=0x15a688e88
sqltxt(0x15e662678)=SELECT COUNT(*) FROM ALL_USERS WHERE USER_ID = :B1
hash=be6dbbd4a42f33eeaf34efe4802499b9
parent=0x14cd41760 maxchild=02 plk=0x153e59250 ppn=n
cursor instantiation=0x2a973e4208 used=1409125312
child#0(0x15e65c108) pcs=0x14cd41370
clk=0x153b84f60 ci=0x13baaade8 pn=(nil) ctx=0x13d940988
kgsccflg=0 llk[0x2a973e4210,0x2a973e4210] idx=0
xscflg=80151436 fl2=5000001 fl3=8218c fl4=0
Bind bytecodes
Opcode = 1 Unoptimized
Offsi = 48, Offsi = 0
kkscoacd
Bind#0
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1206001 frm=00 csi=00 siz=24 off=0
No bind buffers allocated
Frames pfr 0x2a973e4170 siz=8224 efr 0x2a973e4088 siz=8176
Cursor frame dump
enxt: 5.0x00000010
pnxt: 2.0x00000020 pnxt: 1.0x00000010
kxscphp 0x2a97393ce8 siz=984 inu=728 nps=600
kxscdfhp 0x2a97393568 siz=984 inu=88 nps=0
----------------------------------------
Cursor#8(0x2a972119e8) state=NULL curiob=0x2a97406d40
curflg=1045 fl2=0 par=(nil) ses=0x15a688e88
sqltxt(0x15df314f8)=table_1_ff_14f_0_0_0
hash=aea003b000399a6247b4cb0dca3f6508
parent=0x14efcc690 maxchild=01 plk=0x1538b1b50 ppn=n
cursor instantiation=0x2a97406d40 used=1409125312
child#0(0x15df31378) pcs=0x14efa08a8
clk=0x153c49238 ci=0x14ef9ff90 pn=0x1448da1c8 ctx=0x14ef9cbe8
kgsccflg=0 llk[0x2a97406d48,0x2a97406d48] idx=0
xscflg=7e fl2=0 fl3=2000 fl4=100
Frames pfr (nil) siz=344 efr (nil) siz=328
Cursor frame dump
enxt: 1.0x00000148
pnxt: 1.0x00000010
----------------------------------------
.....
----------------------------------------
Cursor#1(0x2a97211710) state=NULL curiob=0x2aa0296698
curflg=1045 fl2=0 par=(nil) ses=0x15a688e88
sqltxt(0x15df314f8)=table_1_ff_14f_0_0_0
hash=aea003b000399a6247b4cb0dca3f6508
parent=0x14efcc690 maxchild=01 plk=0x1537520b0 ppn=n
cursor instantiation=0x2aa0296698 used=1409127516
child#0(0x15df31378) pcs=0x14efa08a8
clk=0x153d3bb80 ci=0x14ef9ff90 pn=0x1448da2a8 ctx=0x14ef9cbe8
kgsccflg=0 llk[0x2aa02966a0,0x2aa02966a0] idx=0
xscflg=7e fl2=0 fl3=2002000 fl4=100
Frames pfr (nil) siz=344 efr (nil) siz=328
Cursor frame dump
enxt: 1.0x00000148
pnxt: 1.0x00000010
Session cached cursors
-----------------------------------------------------------
-------------- Generic Session Cached Cursors Dump --------
-----------------------------------------------------------
hash table=0x2a97213290 cnt=20 LRU=0x2a97206bb0 cnt=20 hit=4868 max=20 NumberOfTypes=3
type#0 name=KQD count=2
type#1 name=KQD BUN count=0
type#2 name=KKS count=18
Bucket#001 seg=0x2a972132b0 nit=4 nal=4 ips=4 sz=24 flg=3 ucnt=0
0 cob=0x2a97229e00 0 flg=0 typ=2 idx=1 cur=(nil) lru=0 flg=0 hdl=(nil)
1 cob=0x2a97229e18 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
2 cob=0x2a97229e30 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
3 cob=0x2a97229e48 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
Bucket#003 seg=0x2a97213310 nit=4 nal=4 ips=4 sz=24 flg=3 ucnt=0
0 cob=0x2aa029b8e0 0 flg=0 typ=2 idx=3 cur=(nil) lru=0 flg=0 hdl=(nil)
1 cob=0x2aa029b8f8 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
2 cob=0x2aa029b910 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
3 cob=0x2aa029b928 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
Bucket#004 seg=0x2a97213340 nit=4 nal=4 ips=4 sz=24 flg=3 ucnt=0
0 cob=0x2a97230778 0 flg=0 typ=2 idx=4 cur=(nil) lru=0 flg=0 hdl=(nil)
1 cob=0x2a97230790 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
2 cob=0x2a972307a8 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
3 cob=0x2a972307c0 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
Bucket#007 seg=0x2a972133d0 nit=4 nal=4 ips=4 sz=24 flg=3 ucnt=0
0 cob=0x2a974070b0 0 flg=0 typ=2 idx=7 cur=(nil) lru=0 flg=0 hdl=(nil)
1 cob=0x2a974070c8 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
2 cob=0x2a974070e0 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
3 cob=0x2a974070f8 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
.....
Bucket#250 seg=0x2a97216160 nit=4 nal=4 ips=4 sz=24 flg=3 ucnt=0
0 cob=0x2a972258b8 0 flg=0 typ=0 idx=fa cur=(nil) lru=0 flg=0 hdl=(nil)
1 cob=0x2a972258d0 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
2 cob=0x2a972258e8 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
3 cob=0x2a97225900 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
-----------------------------------------------------------
------Finished Dumping Generic Session Cached Cursors------
-----------------------------------------------------------
----------------------------------------
sqltxt(0x15cec7338)=select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
hash=6d11d7de2049577d933d2385337fc737
parent=0x150f75490 maxchild=01 plk=0x153e19c88 ppn=n
cursor instantiation=0x2aa0214b90 used=1409127516
child#0(0x15cec7110) pcs=0x150f750a0
clk=0x153845898 ci=0x150f74788 pn=(nil) ctx=0x14fe5f868
kgsccflg=5 llk[0x2aa02a0268,0x2a97206bb0] idx=38
xscflg=a0141436 fl2=5000401 fl3=2210c fl4=0
Bind bytecodes
Opcode = 1 Unoptimized
Offsi = 48, Offsi = 0
Opcode = 1 Unoptimized
Offsi = 48, Offsi = 32
kkscoacd
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=2aa02a1b70 bln=22 avl=04 flg=05
value=30321
Bind#1
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=2aa02a1b40 bln=24 avl=02 flg=05
value=1
Frames pfr 0x2aa02a0930 siz=4328 efr 0x2aa02a1f30 siz=4304
Cursor frame dump
enxt: 4.0x00000010
pnxt: 2.0x00000008 pnxt: 1.0x00000010
kxscphp 0x2aa02940a8 siz=4432 inu=3528 nps=3464
kxscdfhp 0x2aa0293928 siz=984 inu=88 nps=0
kxscbhp 0x2a97394388 siz=984 inu=248 nps=96
----------------------------------------
.....
----------------------------------------
sqltxt(0x15cee8ed8)=COMMIT
hash=81c2e6552d15af7987bf89240f3df5a7
parent=0x150f12218 maxchild=00 plk=0x153a4b700 ppn=n
cursor instantiation=0x2a97409808 used=1409128866
child#0((nil)) pcs=(nil)
clk=(nil) ci=(nil) pn=(nil) ctx=(nil)
kgsccflg=1 llk[0x2a97206bb0,0x2a976130f0] idx=300a8
xscflg=100008 fl2=0 fl3=80080 fl4=40
Frames pfr (nil) siz=0 efr (nil) siz=0
Cursor frame dump
Memory dump of process state object:
Dump of memory from 0x000000015B49EDE0 to 0x000000015B49F5C8
15B49EDE0 00000102 00000000 00000000 00000000 [................]
15B49EDF0 00000000 00000000 00000000 00000000 [................]
15B49EE00 598E3FC8 00000001 52A15678 00000001 [.?.Y....xV.R....]
.....
15B49F5B0 00000000 00000000 2CEABE37 000013B2 [........7..,....]
15B49F5C0 001D6965 00000000 [ei......]
Symbolic dump of process state object:
KSUPRFLG = 0
KSUPRSER = 196
KSUPRIOC = 5042
KSLLALAQ = 0X0000000000000000
KSLLAWAT = 0X0000000000000000
KSLLAWHY = 0
KSLLAWER = 0
KSLLALOW = 0
KSLLAPSC = 367
KSLLAPRC = 29
KSLLAPRV = 25
KSLLAPSN = 24
KSLLID1R = 0
KSLLID2R = 0
KSLLRTYP = ''
KSLLRMTY = 0
KSUPRPID = <INVALID LENGTH SIZE OF 8>
KSUPRUNM = <INVALID LENGTH SIZE OF 8>
KSUPRMNM = <INVALID LENGTH SIZE OF 8>
KSUPRPNM = <INVALID LENGTH SIZE OF 8>
KSUPRTID = <INVALID LENGTH SIZE OF 8>
KSSRCOBJ = 0X0000000000000000
KSSRCFRE = 0X0000000000000000
KSSRCSRC = 0X0000000000000000
KSSRCDST = 0X0000000000000000
KSASTQNX = 0X000000015B49F190
KSASTQPR = 0X000000015B49F190
KSASTRPL = 0
KSUPRPUM = 2837501
KSUPRPNAM = 81341
KSUPRPRAM = 16646144
KSUPRPFM = 917504
KSUPRPMM = 525090237
KSFD PGA DUMPS
Number of completed I/O requests=0 flags=1
END OF PROCESS STATE
---------------------
PINNED BUFFER HISTORY (oldest pin first)
---------------------
BH (0xbdfa88a8) file#: 39 rdba: 0x09c6b02f (39/438319) class: 1 ba: 0xbd5f2000
set: 17 blksize: 8192 bsi: 0 set-flg: 0 pwbcnt: 0
dbwrid: 0 obj: 61377 objn: 61377 tsn: 20 afn: 39
hash: [15af350e8,15af350e8] lru: [110fbcd38,6cff0398]
lru-flags: hot_buffer
obj-flags: object_ckpt_list
ckptq: [71f78578,81fb30b8] fileq: [cbfd1fe8,116fc1648] objq: [1514560a8,6af9cc78]
st: XCURRENT md: NULL tch: 90
flags: buffer_dirty gotten_in_current_mode block_written_once
redo_since_read
LRBA: [0x7ab0.213c0.0] HSCN: [0x225.cebe76cf] HSUB: [6]
buffer tsn: 20 rdba: 0x09c6b02f (39/438319)
scn: 0x0225.cebe76cf seq: 0x01 flg: 0x00 tail: 0x76cf0601
frmt: 0x02 chkval: 0x0000 type: 0x06=trans data
Hex dump of block: st=0, typ_found=1
Dump of memory from 0x00000000BD5F2000 to 0x00000000BD5F4000
0BD5F2000 0000A206 09C6B02F CEBE76CF 00010225 [..../....v..%...]
0BD5F2010 00000000 00000002 0000EFC1 CEBE76CF [.............v..]
0BD5F2020 00000225 06320001 09C6AC09 000D0017 [%.....2.........]
.....
0BD5F3FF0 E6912934 31333032 868D3733 76CF0601 [4)..203137.....v]
Block header dump: 0x09c6b02f
Object id on Block? Y
seg/obj: 0xefc1 csc: 0x225.cebe76cf itc: 1 flg: E typ: 2 - INDEX
brn: 6 bdba: 0x9c6ac09 ver: 0x01 opc: 0
inc: 0 exflg: 0
Itl Xid Uba Flag Lck Scn/Fsc
0x01 0x0017.00d.000277d8 0x010068e3.40c7.02 C--- 0 scn 0x0225.cebe767d
Branch block dump
=================
header address 3177128012=0xbd5f204c
kdxcolev 1
KDXCOLEV Flags = - - -
kdxcolok 0
kdxcoopc 0x80: opcode=0: iot flags=--- is converted=Y
kdxconco 1
kdxcosdc 1
kdxconro 86
kdxcofbo 200=0xc8
kdxcofeo 7197=0x1c1d
kdxcoavs 6997
kdxbrlmc 164016183=0x9c6b037
kdxbrsno 85
kdxbrbksz 8056
kdxbr2urrc 0
row#0[8046] dba: 164016199=0x9c6b047
col 0; len 5; (5): c4 59 5f 1d 1e
row#1[8036] dba: 164016191=0x9c6b03f
col 0; len 5; (5): c4 59 5f 1f 1d
.....
row#85[7197] dba: 164016178=0x9c6b032
col 0; len 5; (5): c4 59 60 62 2d
----- end of branch block dump -----
BH (0x10efc22c8) file#: 39 rdba: 0x09c6b022 (39/438306) class: 1 ba: 0x10e8f6000
set: 17 blksize: 8192 bsi: 0 set-flg: 0 pwbcnt: 0
dbwrid: 0 obj: 61377 objn: 61377 tsn: 20 afn: 39
hash: [15aef3cf0,15aef3cf0] lru: [cdfab6d8,105f85a48]
ckptq: [NULL] fileq: [NULL] objq: [dcf91288,126fcb438]
st: XCURRENT md: NULL tch: 0
flags: gotten_in_current_mode block_written_once redo_since_read
LRBA: [0x0.0.0] HSCN: [0xffff.ffffffff] HSUB: [5]
buffer tsn: 20 rdba: 0x09c6b022 (39/438306)
scn: 0x0225.cebe06e1 seq: 0x04 flg: 0x04 tail: 0x06e10604
frmt: 0x02 chkval: 0xf9fc type: 0x06=trans data
Hex dump of block: st=0, typ_found=1
Dump of memory from 0x000000010E8F6000 to 0x000000010E8F8000
10E8F6000 0000A206 09C6B022 CEBE06E1 04040225 [....".......%...]
10E8F6010 0000F9FC 0001D402 0000EFC1 CEBE06E1 [................]
.....
10E8F7FF0 F90E0000 00740020 00A9FF01 06E10604 [.... .t.........]
Block header dump: 0x09c6b022
Object id on Block? Y
seg/obj: 0xefc1 csc: 0x225.cebe06e1 itc: 169 flg: E typ: 2 - INDEX
brn: 6 bdba: 0x9c6ac09 ver: 0x01 opc: 0
inc: 0 exflg: 0
Itl Xid Uba Flag Lck Scn/Fsc
0x01 0x0028.01b.00013baa 0x014015f0.2307.01 CB-- 0 scn 0x0225.cebcdb29
0x02 0x001b.013.00023ba8 0x00c054d4.3fab.42 C--- 0 scn 0x0225.cebcbb08
.....
0xa8 0x0000.000.00000000 0x00000000.0000.00 ---- 0 fsc 0x0000.00000000
0xa9 0x0000.000.00000000 0x00000000.0000.00 ---- 0 fsc 0x0000.00000000
Leaf block dump
===============
header address 4539248652=0x10e8f700c
kdxcolev 0
KDXCOLEV Flags = - - -
kdxcolok 0
kdxcoopc 0x80: opcode=0: iot flags=--- is converted=Y
kdxconco 1
kdxcosdc 2
kdxconro 199
kdxcofbo 434=0x1b2
kdxcofeo 444=0x1bc
kdxcoavs 10
kdxlespl 0
kdxlende 0
kdxlenxt 164016228=0x9c6b064
kdxleprv 164016154=0x9c6b01a
kdxledsz 10
kdxlebksz 4024
row#0[444] flag: ------, lock: 0, len=18, data:(10): 00 00 47 4d 09 49 75 e5 00 29
col 0; len 5; (5): c4 59 60 54 34
row#1[462] flag: ------, lock: 0, len=18, data:(10): 00 00 47 4d 09 49 75 e5 00 2a
col 0; len 5; (5): c4 59 60 54 35
row#2[480] flag: ------, lock: 0, len=18, data:(10): 00 00 47 4d 09 49 75 e5 00 2b
col 0; len 5; (5): c4 59 60 54 36
.....
0B884BFC0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
0B884BFE0 00000000 00000009 00000002 00000004 [................]
0B884BFF0 00000001 00000000 00000097 9AE02601 [.............&..]
Extent Control Header
-----------------------------------------------------------------
Extent Header:: spare1: 0 spare2: 0 #extents: 16 #blocks: 1807
last map 0x00000000 #maps: 0 offset: 4080
Highwater:: 0x01006b1a ext#: 9 blk#: 17 ext size: 128
#blocks in seg. hdr's freelists: 0
#blocks below: 0
mapblk 0x00000000 offset: 9
Unlocked
Map Header:: next 0x00000000 #extents: 16 obj#: 0 flag: 0x40000000
Extent Map
-----------------------------------------------------------------
0x010000da length: 7
0x01400149 length: 8
0x01801109 length: 128
0x00803689 length: 128
0x00c01089 length: 128
0x01001f89 length: 128
0x44802309 length: 128
0x00803909 length: 128
0x00c05489 length: 128
0x01006b09 length: 128
0x00802389 length: 128
0x00c02809 length: 128
0x01003209 length: 128
0x01403009 length: 128
0x01002089 length: 128
0x01402609 length: 128
Retention Table
-----------------------------------------------------------
Extent Number:0 Commit Time: 1409125193
Extent Number:1 Commit Time: 1409125355
Extent Number:2 Commit Time: 1409127573
Extent Number:3 Commit Time: 1409127573
Extent Number:4 Commit Time: 1409128326
Extent Number:5 Commit Time: 1409129339
Extent Number:6 Commit Time: 1409129339
Extent Number:7 Commit Time: 1409129339
Extent Number:8 Commit Time: 1409130092
Extent Number:9 Commit Time: 1409130092
Extent Number:10 Commit Time: 1409119557
Extent Number:11 Commit Time: 1409119830
Extent Number:12 Commit Time: 1409120198
Extent Number:13 Commit Time: 1409122415
Extent Number:14 Commit Time: 1409125066
Extent Number:15 Commit Time: 1409125067
TRN CTL:: seq: 0x3fac chd: 0x0027 ctl: 0x002c inc: 0x00000000 nfb: 0x0002
mgc: 0x8201 xts: 0x0068 flg: 0x0001 opt: 2147483646 (0x7ffffffe)
uba: 0x01006b1a.3fac.2c scn: 0x0225.cebe83ae
Version: 0x01
FREE BLOCK POOL::
uba: 0x01006b1a.3fac.2c ext: 0x9 spc: 0x7ae
uba: 0x01006b19.3fac.38 ext: 0x9 spc: 0x44a
uba: 0x00000000.3fa0.06 ext: 0x8 spc: 0x1d5a
uba: 0x00000000.382e.21 ext: 0xa spc: 0xd90
uba: 0x00000000.0000.00 ext: 0x0 spc: 0x0
TRN TBL::
index state cflags wrap# uel scn dba parent-xid nub stmt_num cmt
------------------------------------------------------------------------------------------------
0x00 9 0x00 0x23a23 0x002f 0x0225.cebe972d 0x01006b1a 0x0000.000.00000000 0x00000001 0x00000000 1409130487
0x01 9 0x00 0x23bd3 0x002e 0x0225.cebe910c 0x01006b1a 0x0000.000.00000000 0x00000001 0x00000000 1409130469
0x02 9 0x00 0x23bbb 0x0003 0x0225.cebe99d7 0x01006b1a 0x0000.000.00000000 0x00000001 0x00000000 1409130499
0x03 9 0x00 0x23b4c 0x002c 0x0225.cebe9a70 0x01006b1a 0x0000.000.00000000 0x00000001 0x00000000 1409130501
0x04 9 0x00 0x23bdf 0x0012 0x0225.cebe8ad7 0x01006b19 0x0000.000.00000000 0x00000001 0x00000000 1409130449
0x05 9 0x00 0x23ba7 0x0029 0x0225.cebe8f17 0x01006b19 0x0000.000.00000000 0x00000001 0x00000000 1409130462
0x06 9 0x00 0x23bcf 0x0026 0x0225.cebe8d72 0x01006b19 0x0000.000.00000000 0x00000001 0x00000000 1409130457
0x07 9 0x00 0x23bd7 0x002d 0x0225.cebe897a 0x01006b19 0x0000.000.00000000 0x00000001 0x00000000 1409130448
0x08 9 0x00 0x23ba4 0x0013 0x0225.cebe91a2 0x01006b1a 0x0000.000.00000000 0x00000001 0x00000000 1409130471
0x09 9 0x00 0x23bac 0x001e 0x0225.cebe8c49 0x01006b19 0x0000.000.00000000 0x00000001 0x00000000 1409130454
0x0a 9 0x00 0x23bd8 0x001b 0x0225.cebe92bf 0x01006b1a 0x0000.000.00000000 0x00000001 0x00000000 1409130473
0x0b 9 0x00 0x23bb3 0x0014 0x0225.cebe953c 0x01006b1a 0x0000.000.00000000 0x00000001 0x00000000 1409130480
0x0c 9 0x00 0x23a1c 0x000f 0x0225.cebe9843 0x01006b1a 0x0000.000.00000000 0x00000001 0x00000000 1409130491
0x0d 9 0x00 0x23ba9 0x0008 0x0225.cebe9150 0x01006b1a 0x0000.000.00000000 0x00000001 0x00000000 1409130470
0x0e 9 0x00 0x23bc0 0x0002 0x0225.cebe9954 0x01006b1a 0x0000.000.00000000 0x00000001 0x00000000 1409130495
0x0f 9 0x00 0x23b39 0x000e 0x0225.cebe990a 0x01006b1a 0x0000.000.00000000 0x00000001 0x00000000 1409130494
0x10 9 0x00 0x23bcd 0x001c 0x0225.cebe8e61 0x01006b19 0x0000.000.00000000 0x00000001 0x00000000 1409130460
0x11 9 0x00 0x23bda 0x0024 0x0225.cebe88ac 0x01006b18 0x0000.000.00000000 0x00000001 0x00000000 1409130446
0x12 9 0x00 0x23bde 0x0019 0x0225.cebe8b31 0x01006b19 0x0000.000.00000000 0x00000001 0x00000000 1409130451
0x13 9 0x00 0x23bbd 0x000a 0x0225.cebe921b 0x01006b1a 0x0000.000.00000000 0x00000001 0x00000000 1409130471
0x14 9 0x00 0x23b58 0x001a 0x0225.cebe9623 0x01006b1a 0x0000.000.00000000 0x00000001 0x00000000 1409130485
0x15 9 0x00 0x23bdf 0x002a 0x0225.cebe902a 0x01006b19 0x0000.000.00000000 0x00000001 0x00000000 1409130466
0x16 9 0x00 0x23bd0 0x001f 0x0225.cebe85a4 0x01006b18 0x0000.000.00000000 0x00000001 0x00000000 1409130437
0x17 9 0x00 0x23a18 0x000d 0x0225.cebe9115 0x01006b19 0x0000.000.00000000 0x00000001 0x00000000 1409130469
0x18 9 0x00 0x23bd2 0x0016 0x0225.cebe8592 0x01006b18 0x0000.000.00000000 0x00000001 0x00000000 1409130437
0x19 9 0x00 0x23bd2 0x0009 0x0225.cebe8be1 0x01006b19 0x0000.000.00000000 0x00000001 0x00000000 1409130453
0x1a 9 0x00 0x23bd2 0x0000 0x0225.cebe96da 0x01006b1a 0x0000.000.00000000 0x00000001 0x00000000 1409130486
0x1b 9 0x00 0x23bab 0x0028 0x0225.cebe93b9 0x01006b1a 0x0000.000.00000000 0x00000001 0x00000000 1409130478
0x1c 9 0x00 0x23bdf 0x0005 0x0225.cebe8ebd 0x01006b19 0x0000.000.00000000 0x00000001 0x00000000 1409130461
0x1d 9 0x00 0x23bd2 0x0021 0x0225.cebe8a4c 0x01006b19 0x0000.000.00000000 0x00000001 0x00000000 1409130449
0x1e 9 0x00 0x23bd1 0x0006 0x0225.cebe8d06 0x01006b19 0x0000.000.00000000 0x00000001 0x00000000 1409130455
0x1f 9 0x00 0x23b13 0x0011 0x0225.cebe8708 0x01006b18 0x0000.000.00000000 0x00000001 0x00000000 1409130439
0x20 9 0x00 0x2330d 0x000b 0x0225.cebe9486 0x01006b1a 0x0000.000.00000000 0x00000001 0x00000000 1409130480
0x21 9 0x00 0x23bd8 0x0004 0x0225.cebe8ab1 0x01006b19 0x0000.000.00000000 0x00000001 0x00000000 1409130449
0x22 9 0x00 0x23bd2 0x0023 0x0225.cebe8467 0x01006b18 0x0000.000.00000000 0x00000001 0x00000000 1409130435
0x23 9 0x00 0x232a5 0x002b 0x0225.cebe84ab 0x01006b18 0x0000.000.00000000 0x00000001 0x00000000 1409130435
0x24 9 0x00 0x23bdf 0x0007 0x0225.cebe8921 0x01006b18 0x0000.000.00000000 0x00000001 0x00000000 1409130446
0x25 9 0x00 0x23bc5 0x0017 0x0225.cebe9110 0x01006b1a 0x0000.000.00000000 0x00000001 0x00000000 1409130469
0x26 9 0x00 0x23ba6 0x0010 0x0225.cebe8e12 0x01006b19 0x0000.000.00000000 0x00000001 0x00000000 1409130459
0x27 9 0x00 0x23bd6 0x0022 0x0225.cebe841f 0x01006b18 0x0000.000.00000000 0x00000001 0x00000000 1409130434
0x28 9 0x00 0x23bce 0x0020 0x0225.cebe9437 0x01006b1a 0x0000.000.00000000 0x00000001 0x00000000 1409130478
0x29 9 0x00 0x23bcc 0x0015 0x0225.cebe8f36 0x01006b19 0x0000.000.00000000 0x00000001 0x00000000 1409130463
0x2a 9 0x00 0x23835 0x0001 0x0225.cebe90a6 0x01006b19 0x0000.000.00000000 0x00000001 0x00000000 1409130468
0x2b 9 0x00 0x23bb2 0x0018 0x0225.cebe8553 0x01006b18 0x0000.000.00000000 0x00000001 0x00000000 1409130437
0x2c 9 0x00 0x23bd5 0xffff 0x0225.cebe9ae0 0x01006b1a 0x0000.000.00000000 0x00000001 0x00000000 1409130501
0x2d 9 0x00 0x23bc8 0x001d 0x0225.cebe8a1e 0x01006b19 0x0000.000.00000000 0x00000001 0x00000000 1409130448
0x2e 9 0x00 0x23bad 0x0025 0x0225.cebe910e 0x01006b1a 0x0000.000.00000000 0x00000001 0x00000000 1409130469
0x2f 9 0x00 0x23bd4 0x000c 0x0225.cebe9759 0x01006b1a 0x0000.000.00000000 0x00000001 0x00000000 1409130488
END OF PINNED BUFFER HISTORY
No relevant component found - buffer pin history redo is not dumped
----- Archival Runtime State -----
LOG_ARCHIVE_DEST_1:
sdip:0x0x15874e7b0
arcname_len_kcrrsdi: 24
arcname_kcrrsdi: /u03/oradata/orcl01/arch
rft_len_kcrrsdi: 0
rft_kcrrsdi:
dbun_len_kcrrsdi: 0
dbun_kcrrsdi:
dgid_kcrrsdi: 0x0
flag_kcrrsdi: 0x206a
flag2_kcrrsdi: 0x1
sflag_kcrrsdi: 0x0
reopen_kcrrsdi: 300
delay_kcrrsdi: 0
client_kcrrsdi: 0
altidx_kcrrsdi: 0
dpdidx_kcrrsdi: 0
quotsz_kcrrsdi: 0
quotsd_kcrrsdi: 0
failblk_kcrrsdi: 0
faildat_kcrrsdi: 0
failoer_kcrrsdi: 0
failseq_kcrrsdi: 0
failcnt_kcrrsdi: 0
dstvno_kcrrsdi: 2
stavno_kcrrsdi: 2
lab_kcrrsdi: 0
zlab_kcrrsdi: 0
sptout_kcrrsdi: 0
lsa_kcrrsdi: 31407
lsr_kcrrsdi: 0
lta_kcrrsdi: 1
ltr_kcrrsdi: 0
slfcnt_kcrrsdi: 0
slfact_kcrrsdi: 0
maxfail_kcrrsdi: 0
validfor_kcrrsdi: 33
mountid_kcrrsdi: -433592793
archseq_kcrrsdi: 31407
intvno_kcrrsdi: 0
-------------------------------------
LOG_ARCHIVE_DEST_2:
sdip:0x0x15874ea68
arcname_len_kcrrsdi: 0
.....
archseq_kcrrsdi: 0
intvno_kcrrsdi: 0
-------------------------------------
----- End of Archival Runtime State -----
--------- Recovery context -------
No recovery context found
-----------End of Recovery context-----------
ksedmp: no current context area
----- Dump of the Fixed PGA -----
word ksmpgf_ [006699820, 006699824) = 00000000
word ksmmpd_ [006699824, 006699828) = 00000001
skgm_cx ksmskgmctx_ [0066872C0, 0066873E0) = 052ECB00 00000000 066876E0 ...
Dump of memory from 0x0066872C8 to 0x0066873E0
0066872C0 00000000 [....]
0066872D0 000000E7 0000000F 00000800 00001000 [................]
0066872E0 00001000 00200000 00000000 00000002 [...... .........]
.....
0066875F0 066875F0 00000000 066875F0 00000000 [.uh......uh.....]
struct ksmug * ksmugp_ [006698718, 006698720) = 97206728 0000002A
Dump of memory from 0x2A97206728 to 0x2A97206768
2A97206720 0000ABAB 00000000 [........]
2A97206730 97206738 0000002A 0668AF40 00000000 [8g .*...@.h.....]
2A97206740 0000FF80 00000000 5A688E88 00000001 [..........hZ....]
2A97206750 97573080 0000002A 97563BC8 0000002A [.0W.*....;V.*...]
2A97206760 00000000 00000000 [........]
ub4 ksmrfuse_ [006699828, 00669982C) = 01001101
kghds * ksmtcpga_ [006698720, 006698728) = 0668AD20 00000000
Dump of memory from 0x00668AD20 to 0x00668AD60
00668AD20 00000000 00000000 000020C0 00000000 [......... ......]
00668AD30 00000000 00000000 A0273008 0000002A [.........0'.*...]
00668AD40 A0273018 0000002A 00000000 00000000 [.0'.*...........]
00668AD50 00000000 00000000 02120200 00000000 [................]
ub1 * ksmkcu_ [006698728, 006698730) = 00000000 00000000
ub1 * ksmken_ [006698730, 006698738) = 00000000 00000000
ub1 * ksmkpr_ [006698738, 006698740) = 00000000 00000000
size_t * ksmchsz_ [006698740, 006698748) = 05AD1FC0 00000000
Dump of memory from 0x005AD1FC0 to 0x005AD2000
005AD1FC0 00000000 00000000 00000000 00000000 [................]
005AD1FD0 00000018 00000000 00000030 00000000 [........0.......]
.....
*** 2014-08-27 18:08:23.159
KSTDUMP: In-memory trace dump
TIME(usecs):SEQ# ORAPID SID EVENT OP DATA
========================================================================
341EED5E:000000B0 999 0 10254 34 KSBS1P: process USER trying to start background DBWd
341EED5F:000000B1 999 0 10254 36 KSBS1P: process DBWd already running or not enabled
341EED60:000000B2 999 0 10254 34 KSBS1P: process USER trying to start background DBWe
341EED61:000000B3 999 0 10254 36 KSBS1P: process DBWe already running or not enabled
341EED62:000000B4 999 0 10254 34 KSBS1P: process USER trying to start background DBWf
341EED63:000000B5 999 0 10254 36 KSBS1P: process DBWf already running or not enabled
341EED64:000000B6 999 0 10254 34 KSBS1P: process USER trying to start background DBWg
341EED64:000000B7 999 0 10254 36 KSBS1P: process DBWg already running or not enabled
341EED66:000000B8 999 0 10254 34 KSBS1P: process USER trying to start background DBWh
341EED66:000000B9 999 0 10254 36 KSBS1P: process DBWh already running or not enabled
341EED67:000000BA 999 0 10254 34 KSBS1P: process USER trying to start background DBWi
341EED68:000000BB 999 0 10254 36 KSBS1P: process DBWi already running or not enabled
341EED69:000000BC 999 0 10254 34 KSBS1P: process USER trying to start background DBWj
341EED69:000000BD 999 0 10254 36 KSBS1P: process DBWj already running or not enabled
341EED6B:000000BE 999 0 10254 34 KSBS1P: process USER trying to start background ARC0
341EED6B:000000BF 999 0 10254 36 KSBS1P: process ARC0 already running or not enabled
341EED6C:000000C0 999 0 10254 34 KSBS1P: process USER trying to start background ARC1
341EED6D:000000C1 999 0 10254 36 KSBS1P: process ARC1 already running or not enabled
341EED6E:000000C2 999 0 10254 34 KSBS1P: process USER trying to start background ARC2
341EED6F:000000C3 999 0 10254 36 KSBS1P: process ARC2 already running or not enabled
.....
4C7FC6DE:6EC67405 485 972 10005 4 KSL POST SENT postee=7 loc='ksasnd' id1=0 id2=0 name= type=0
4C7FC91B:6EC6740D 485 972 10021 11 0x00000000C1D3B140 0x00000000C1D3B13F
4C7FC91D:6EC6740E 485 972 10005 4 KSL POST SENT postee=7 loc='ksasnd' id1=0 id2=0 name= type=0
4C7FD157:6EC67416 485 0 10280 8 kst: process state object about to be deleted
45153779:6EC51C42 486 0 10280 1 kst: process state object created on 08-19 16:00:01.550
4515377A:6EC51C43 486 0 10280 3 kst: process info: ospid=824 pso_num=486 pso_serial#=1
45153807:6EC51C44 486 0 10420 1 kso: new process: pid=824 (legacy spawn)
478B0FB7:6EC59428 486 972 10021 11 0x00000000C1D2D3CF 0x00000000C1D2D3CB
478B0FBC:6EC59429 486 972 10005 4 KSL POST SENT postee=7 loc='ksasnd' id1=0 id2=0 name= type=0
478B0FC7:6EC5942B 486 972 10444 12 ABORT TRANSACTION - xid: 0x0047.002.00008a21
478B11DA:6EC59432 486 972 10442 6 Extension usn 71, ext 1, nex 3
478B11E3:6EC59433 486 972 10445 1 des1: tsn: 48 rdba: 0x16cc9c81 where: ktspbwh1: ktspfsrch
47A74793:6EC59A1B 486 972 10005 4 KSL POST SENT postee=7 loc='kcrfw_redo_gen: wake LGWR after redo copy' id1=0 id2=0 name= type=0
47BFDC7C:6EC5A2B9 486 972 10021 11 0x00000000C1D2D6B7 0x00000000C1D2D6B6
47BFDC81:6EC5A2BA 486 972 10005 4 KSL POST SENT postee=7 loc='ksasnd' id1=0 id2=0 name= type=0
47BFF0BE:6EC5A2C2 486 0 10280 8 kst: process state object about to be deleted
4C1059E8:6EC65E7D 486 0 10280 1 kst: process state object created on 08-19 16:02:01.483
4C1059EA:6EC65E7E 486 0 10280 3 kst: process info: ospid=1164 pso_num=486 pso_serial#=2
4C105A54:6EC65E7F 486 0 10420 1 kso: new process: pid=1164 (legacy spawn)
4C10B4B3:6EC65E89 486 1061 10021 11 0x00000000C1D3AE05 0x00000000C1D3AE04
4C10B4B9:6EC65E8A 486 1061 10005 4 KSL POST SENT postee=7 loc='ksasnd' id1=0 id2=0 name= type=0
4C1330CA:6EC65F08 486 1061 10021 11 0x00000000C1D3AE27 0x00000000C1D3AE26
4C1330D0:6EC65F09 486 1061 10005 4 KSL POST SENT postee=7 loc='ksasnd' id1=0 id2=0 name= type=0
4C138145:6EC65F11 486 1061 10021 11 0x00000000C1D3AE29 0x00000000C1D3AE28
4C13814A:6EC65F12 486 1061 10005 4 KSL POST SENT postee=7 loc='ksasnd' id1=0 id2=0 name= type=0
4C13ABB4:6EC65F1A 486 1061 10021 11 0x00000000C1D3AE2B 0x00000000C1D3AE2A
4C13ABB6:6EC65F1B 486 1061 10005 4 KSL POST SENT postee=7 loc='ksasnd' id1=0 id2=0 name= type=0
4C13AC37:6EC65F1F 486 1061 10021 12 0x00000000C1D3AE2B 0x00000000C1D3AE2C
4C13AC41:6EC65F24 486 1061 10021 13 0x0000000000000000
4C13B37B:6EC65F25 486 0 10280 8 kst: process state object about to be deleted
KSTDUMP: End of in-memory trace dump
*** 2014-08-27 18:08:25.003
GRANULE SIZE is 16777216
COMPONENT NAME : shared pool, curnum=38, usrsz=38, tgt=38, st=0
Number of granules in inactive list (listid 0) is 0
Number of granules in activate list (listid 1) is 0
Number of granules in inuse list (listid 2) is 38
Number of granules in quiesce list (listid 3) is 0
Number of granules in partially inuse list (listid 4) is 0
COMPONENT NAME : large pool, curnum=1, usrsz=0, tgt=1, st=0
Number of granules in inactive list (listid 0) is 0
Number of granules in activate list (listid 1) is 0
Number of granules in inuse list (listid 2) is 1
Number of granules in quiesce list (listid 3) is 0
Number of granules in partially inuse list (listid 4) is 0
.....
COMPONENT NAME : ASM Buffer Cache, curnum=0, usrsz=0, tgt=0, st=0
Number of granules in inactive list (listid 0) is 0
Number of granules in activate list (listid 1) is 0
Number of granules in inuse list (listid 2) is 0
Number of granules in quiesce list (listid 3) is 0
Number of granules in partially inuse list (listid 4) is 0
Dumping memory transfer history; start=0
Dumping resize operations history; start=14
1: 0, 0, 112, 0->38, fin=38, st=2
2: 0, 0, 114, 0->1, fin=1, st=2
3: 0, 0, 116, 0->2, fin=2, st=2
4: 0, 0, 118, 0->1, fin=1, st=2
6: 0, 0, 413, 0->213, fin=213, st=2
7: 0, 0, 420, 0->0, fin=0, st=2
8: 0, 0, 421, 0->0, fin=0, st=2
9: 0, 0, 415, 0->0, fin=0, st=2
10: 0, 0, 416, 0->0, fin=0, st=2
11: 0, 0, 417, 0->0, fin=0, st=2
12: 0, 0, 418, 0->0, fin=0, st=2
13: 0, 0, 419, 0->0, fin=0, st=2
14: 0, 0, 413, 0->0, fin=0, st=2
6: 1, 0, 413, 213->213, fin=213, st=2
Dumping last 2 granules of Transferred Memory
Done Dumping transfer, resize ops and granules.
Dump of memory from 0x0000000157131B08 to 0x0000000157131C80
157131B00 57328A08 00000001 [..2W....]
157131B10 59609BB0 00000001 000000D5 00006657 [..`Y........Wf..]
157131B20 00000010 0000CF2D 00000000 00000000 [....-...........]
.....
157131C60 429FF6EB 00000000 5AAD4935 00000000 [...B....5I.Z....]
157131C70 000AF671 00000000 00000000 00000000 [q...............]
KCBS: disable_kcbsbpd is 0
KCBS: bufcnt = 8610, nb_kcbsds = 8610
KCBS: fbufcnt = 230
KCBS: Tot bufs in set segwise
KCBS: nbseg[0] is 431
KCBS: nbseg[1] is 430
KCBS: nbseg[2] is 431
KCBS: nbseg[3] is 430
KCBS: nbseg[4] is 431
KCBS: nbseg[5] is 430
KCBS: nbseg[6] is 431
KCBS: nbseg[7] is 430
KCBS: nbseg[8] is 431
KCBS: nbseg[9] is 430
KCBS: nbseg[10] is 431
KCBS: nbseg[11] is 430
KCBS: nbseg[12] is 431
KCBS: nbseg[13] is 430
KCBS: nbseg[14] is 431
KCBS: nbseg[15] is 430
KCBS: nbseg[16] is 431
KCBS: nbseg[17] is 430
KCBS: nbseg[18] is 431
KCBS: nbseg[19] is 430
KCBS: Act cnt = 4367
KCBS: bufcnt = 8610, nb_kcbsds = 8610
KCBS: fbufcnt = 230
KCBS: Tot bufs in set segwise
KCBS: nbseg[0] is 431
KCBS: nbseg[1] is 430
KCBS: nbseg[2] is 431
KCBS: nbseg[3] is 430
KCBS: nbseg[4] is 431
KCBS: nbseg[5] is 430
KCBS: nbseg[6] is 431
KCBS: nbseg[7] is 430
KCBS: nbseg[8] is 431
KCBS: nbseg[9] is 430
KCBS: nbseg[10] is 431
KCBS: nbseg[11] is 430
KCBS: nbseg[12] is 431
KCBS: nbseg[13] is 430
KCBS: nbseg[14] is 431
KCBS: nbseg[15] is 430
KCBS: nbseg[16] is 431
KCBS: nbseg[17] is 430
KCBS: nbseg[18] is 431
KCBS: nbseg[19] is 430
KCBS: Act cnt = 4367
KCBS: bufcnt = 8610, nb_kcbsds = 8610
KCBS: fbufcnt = 230
KCBS: Tot bufs in set segwise
KCBS: nbseg[0] is 431
KCBS: nbseg[1] is 430
KCBS: nbseg[2] is 431
KCBS: nbseg[3] is 430
KCBS: nbseg[4] is 431
KCBS: nbseg[5] is 430
KCBS: nbseg[6] is 431
KCBS: nbseg[7] is 430
KCBS: nbseg[8] is 431
KCBS: nbseg[9] is 430
KCBS: nbseg[10] is 431
KCBS: nbseg[11] is 430
KCBS: nbseg[12] is 431
KCBS: nbseg[13] is 430
KCBS: nbseg[14] is 431
KCBS: nbseg[15] is 430
KCBS: nbseg[16] is 431
KCBS: nbseg[17] is 430
KCBS: nbseg[18] is 431
KCBS: nbseg[19] is 430
KCBS: Act cnt = 4367
KCBS: bufcnt = 8610, nb_kcbsds = 8610
KCBS: fbufcnt = 229
KCBS: Tot bufs in set segwise
KCBS: nbseg[0] is 430
KCBS: nbseg[1] is 431
KCBS: nbseg[2] is 430
KCBS: nbseg[3] is 431
KCBS: nbseg[4] is 430
KCBS: nbseg[5] is 431
KCBS: nbseg[6] is 430
KCBS: nbseg[7] is 431
KCBS: nbseg[8] is 430
KCBS: nbseg[9] is 431
KCBS: nbseg[10] is 430
KCBS: nbseg[11] is 431
KCBS: nbseg[12] is 430
KCBS: nbseg[13] is 431
KCBS: nbseg[14] is 430
KCBS: nbseg[15] is 431
KCBS: nbseg[16] is 430
KCBS: nbseg[17] is 431
KCBS: nbseg[18] is 430
KCBS: nbseg[19] is 431
KCBS: Act cnt = 4366
KCBS: bufcnt = 8610, nb_kcbsds = 8610
KCBS: fbufcnt = 229
KCBS: Tot bufs in set segwise
KCBS: nbseg[0] is 430
KCBS: nbseg[1] is 431
KCBS: nbseg[2] is 430
KCBS: nbseg[3] is 431
KCBS: nbseg[4] is 430
KCBS: nbseg[5] is 431
KCBS: nbseg[6] is 430
KCBS: nbseg[7] is 431
KCBS: nbseg[8] is 430
KCBS: nbseg[9] is 431
KCBS: nbseg[10] is 430
KCBS: nbseg[11] is 431
KCBS: nbseg[12] is 430
KCBS: nbseg[13] is 431
KCBS: nbseg[14] is 430
KCBS: nbseg[15] is 431
KCBS: nbseg[16] is 430
KCBS: nbseg[17] is 431
KCBS: nbseg[18] is 430
KCBS: nbseg[19] is 431
KCBS: Act cnt = 4366
KCBS: bufcnt = 8610, nb_kcbsds = 8610
KCBS: fbufcnt = 229
KCBS: Tot bufs in set segwise
KCBS: nbseg[0] is 430
KCBS: nbseg[1] is 431
KCBS: nbseg[2] is 430
KCBS: nbseg[3] is 431
KCBS: nbseg[4] is 430
KCBS: nbseg[5] is 431
KCBS: nbseg[6] is 430
KCBS: nbseg[7] is 431
KCBS: nbseg[8] is 430
KCBS: nbseg[9] is 431
KCBS: nbseg[10] is 430
KCBS: nbseg[11] is 431
KCBS: nbseg[12] is 430
KCBS: nbseg[13] is 431
KCBS: nbseg[14] is 430
KCBS: nbseg[15] is 431
KCBS: nbseg[16] is 430
KCBS: nbseg[17] is 431
KCBS: nbseg[18] is 430
KCBS: nbseg[19] is 431
KCBS: Act cnt = 4366
KSOLS: Begin dumping all object level stats elements
KSOLS: Done dumping all elements. Exiting.
Dump event group for SESSION
Dump event group for SYSTEM
DYNAMICALLY MODIFIED PARAMETERS:
plsql_compiler_flags = INTERPRETED, DEBUG
plsql_debug = TRUE
plsql_optimize_level = 0
*** 2014-08-27 18:08:25.042
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [17281], [1001], [0x15CEBA048], [], [], [], [], []
ORA-01001: invalid cursor
ORA-00600: internal error code, arguments: [17281], [1001], [0x15CEBA048], [], [], [], [], []
ORA-01001: invalid cursor
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+31 call ksedst1() 000000000 ? 000000001 ?
7FBFFFA490 ? 7FBFFFA4F0 ?
7FBFFFA430 ? 000000000 ?
ksedmp()+610 call ksedst() 000000000 ? 000000001 ?
7FBFFFA490 ? 7FBFFFA4F0 ?
7FBFFFA430 ? 000000000 ?
.....
_start()+42 call __libc_start_main() 000713988 ? 000000002 ?
7FBFFFF668 ? 005288D00 ?
000000000 ? 000000002 ?
--------------------- Binary Stack Dump ---------------------
========== FRAME [1] (ksedst()+31 -> ksedst1()) ==========
RDI 0000000000000000 RSI 0000000000000001 RDX 0000007FBFFFA490
RCX 0000007FBFFFA4F0 R8 0000007FBFFFA430 R9 0000000000000000
RAX 00000000013284C4 RBX 0000000000000000 RBP 0000007FBFFFAF60
R10 0000000002F61D9F R11 0000000002F616B8 R12 00000000052EBEA0
R13 00000000066876E0 R14 0000000000000002 R15 0000000006707380
RSP 0000007FBFFFAF60 RIP 0000000000753B19
Dump of memory from 0x0000007FBFFF5E80 to 0x0000007FBFFF6280
7FBFFF5E80 052DF830 00000000 0000001C 00000000 [0.-.............]
7FBFFF5E90 052DF854 00000000 00000001 00584352 [T.-.........RCX.]
7FBFFF5EA0 BFFFA490 0000007F BFFFA4F0 0000007F [................]
.....
COMPONENT NAME : ASM Buffer Cache, curnum=0, usrsz=0, tgt=0, st=0
Number of granules in inactive list (listid 0) is 0
Number of granules in activate list (listid 1) is 0
Number of granules in inuse list (listid 2) is 0
Number of granules in quiesce list (listid 3) is 0
Number of granules in partially inuse list (listid 4) is 0
Dumping memory transfer history; start=0
Dumping resize operations history; start=14
1: 0, 0, 112, 0->38, fin=38, st=2
2: 0, 0, 114, 0->1, fin=1, st=2
3: 0, 0, 116, 0->2, fin=2, st=2
4: 0, 0, 118, 0->1, fin=1, st=2
6: 0, 0, 413, 0->213, fin=213, st=2
7: 0, 0, 420, 0->0, fin=0, st=2
8: 0, 0, 421, 0->0, fin=0, st=2
9: 0, 0, 415, 0->0, fin=0, st=2
10: 0, 0, 416, 0->0, fin=0, st=2
11: 0, 0, 417, 0->0, fin=0, st=2
12: 0, 0, 418, 0->0, fin=0, st=2
13: 0, 0, 419, 0->0, fin=0, st=2
14: 0, 0, 413, 0->0, fin=0, st=2
6: 1, 0, 413, 213->213, fin=213, st=2
Dumping last 2 granules of Transferred Memory
Done Dumping transfer, resize ops and granules.
Dump of memory from 0x0000000157131B08 to 0x0000000157131C80
157131B00 57328A08 00000001 [..2W....]
157131B10 59609BB0 00000001 000000D5 00006657 [..`Y........Wf..]
157131B20 00000010 0000CF2D 00000000 00000000 [....-...........]
157131B30 00010014 00000001 00000000 00000000 [................]
157131B40 000000BD 00000076 00000001 00000463 [....v.......c...]
157131B50 00000000 00000000 00000000 00000000 [................]
Repeat 3 times
157131B90 57131B90 00000001 57131B90 00000001 [...W.......W....]
157131BA0 57131A28 00000001 57131D18 00000001 [(..W.......W....]
157131BB0 00000000 00000000 00000000 00000000 [................]
157131BC0 00000003 00000000 00000000 00000000 [................]
157131BD0 00000000 00000000 00000001 000000D5 [................]
157131BE0 000000D5 00000000 000000D5 00000000 [................]
157131BF0 00066E97 00000000 41464544 00544C55 [.n......DEFAULT.]
157131C00 00000000 00000000 00000000 00000007 [................]
157131C10 00000003 00002000 00000006 0012000D [..... ..........]
157131C20 5843BF98 00000001 00000001 00000000 [..CX............]
157131C30 00000000 00000000 70202101 000005EE [.........! p....]
157131C40 56DB2C0D 000005C5 D69F22C5 00000028 [.,.V....."..(...]
157131C50 429B3107 00000000 00000000 00000000 [.1.B............]
157131C60 429FFF98 00000000 5AAD4935 00000000 [...B....5I.Z....]
157131C70 000AF671 00000000 00000000 00000000 [q...............]
KCBS: disable_kcbsbpd is 0
KCBS: bufcnt = 8610, nb_kcbsds = 8610
KCBS: fbufcnt = 230
KCBS: Tot bufs in set segwise
KCBS: nbseg[0] is 431
KCBS: nbseg[1] is 430
KCBS: nbseg[2] is 431
KCBS: nbseg[3] is 430
KCBS: nbseg[4] is 431
KCBS: nbseg[5] is 430
KCBS: nbseg[6] is 431
KCBS: nbseg[7] is 430
KCBS: nbseg[8] is 431
KCBS: nbseg[9] is 430
KCBS: nbseg[10] is 431
KCBS: nbseg[11] is 430
KCBS: nbseg[12] is 431
KCBS: nbseg[13] is 430
KCBS: nbseg[14] is 431
KCBS: nbseg[15] is 430
KCBS: nbseg[16] is 431
KCBS: nbseg[17] is 430
KCBS: nbseg[18] is 431
KCBS: nbseg[19] is 430
KCBS: Act cnt = 4367
KCBS: bufcnt = 8610, nb_kcbsds = 8610
KCBS: fbufcnt = 230
KCBS: Tot bufs in set segwise
KCBS: nbseg[0] is 431
KCBS: nbseg[1] is 430
KCBS: nbseg[2] is 431
KCBS: nbseg[3] is 430
KCBS: nbseg[4] is 431
KCBS: nbseg[5] is 430
KCBS: nbseg[6] is 431
KCBS: nbseg[7] is 430
KCBS: nbseg[8] is 431
KCBS: nbseg[9] is 430
KCBS: nbseg[10] is 431
KCBS: nbseg[11] is 430
KCBS: nbseg[12] is 431
KCBS: nbseg[13] is 430
KCBS: nbseg[14] is 431
KCBS: nbseg[15] is 430
KCBS: nbseg[16] is 431
KCBS: nbseg[17] is 430
KCBS: nbseg[18] is 431
KCBS: nbseg[19] is 430
KCBS: Act cnt = 4367
KCBS: bufcnt = 8610, nb_kcbsds = 8610
KCBS: fbufcnt = 230
KCBS: Tot bufs in set segwise
KCBS: nbseg[0] is 431
KCBS: nbseg[1] is 430
KCBS: nbseg[2] is 431
KCBS: nbseg[3] is 430
KCBS: nbseg[4] is 431
KCBS: nbseg[5] is 430
KCBS: nbseg[6] is 431
KCBS: nbseg[7] is 430
KCBS: nbseg[8] is 431
KCBS: nbseg[9] is 430
KCBS: nbseg[10] is 431
KCBS: nbseg[11] is 430
KCBS: nbseg[12] is 431
KCBS: nbseg[13] is 430
KCBS: nbseg[14] is 431
KCBS: nbseg[15] is 430
KCBS: nbseg[16] is 431
KCBS: nbseg[17] is 430
KCBS: nbseg[18] is 431
KCBS: nbseg[19] is 430
KCBS: Act cnt = 4367
KCBS: bufcnt = 8610, nb_kcbsds = 8610
KCBS: fbufcnt = 229
KCBS: Tot bufs in set segwise
KCBS: nbseg[0] is 430
KCBS: nbseg[1] is 431
KCBS: nbseg[2] is 430
KCBS: nbseg[3] is 431
KCBS: nbseg[4] is 430
KCBS: nbseg[5] is 431
KCBS: nbseg[6] is 430
KCBS: nbseg[7] is 431
KCBS: nbseg[8] is 430
KCBS: nbseg[9] is 431
KCBS: nbseg[10] is 430
KCBS: nbseg[11] is 431
KCBS: nbseg[12] is 430
KCBS: nbseg[13] is 431
KCBS: nbseg[14] is 430
KCBS: nbseg[15] is 431
KCBS: nbseg[16] is 430
KCBS: nbseg[17] is 431
KCBS: nbseg[18] is 430
KCBS: nbseg[19] is 431
KCBS: Act cnt = 4366
KCBS: bufcnt = 8610, nb_kcbsds = 8610
KCBS: fbufcnt = 229
KCBS: Tot bufs in set segwise
KCBS: nbseg[0] is 430
KCBS: nbseg[1] is 431
KCBS: nbseg[2] is 430
KCBS: nbseg[3] is 431
KCBS: nbseg[4] is 430
KCBS: nbseg[5] is 431
KCBS: nbseg[6] is 430
KCBS: nbseg[7] is 431
KCBS: nbseg[8] is 430
KCBS: nbseg[9] is 431
KCBS: nbseg[10] is 430
KCBS: nbseg[11] is 431
KCBS: nbseg[12] is 430
KCBS: nbseg[13] is 431
KCBS: nbseg[14] is 430
KCBS: nbseg[15] is 431
KCBS: nbseg[16] is 430
KCBS: nbseg[17] is 431
KCBS: nbseg[18] is 430
KCBS: nbseg[19] is 431
KCBS: Act cnt = 4366
KCBS: bufcnt = 8610, nb_kcbsds = 8610
KCBS: fbufcnt = 229
KCBS: Tot bufs in set segwise
KCBS: nbseg[0] is 430
KCBS: nbseg[1] is 431
KCBS: nbseg[2] is 430
KCBS: nbseg[3] is 431
KCBS: nbseg[4] is 430
KCBS: nbseg[5] is 431
KCBS: nbseg[6] is 430
KCBS: nbseg[7] is 431
KCBS: nbseg[8] is 430
KCBS: nbseg[9] is 431
KCBS: nbseg[10] is 430
KCBS: nbseg[11] is 431
KCBS: nbseg[12] is 430
KCBS: nbseg[13] is 431
KCBS: nbseg[14] is 430
KCBS: nbseg[15] is 431
KCBS: nbseg[16] is 430
KCBS: nbseg[17] is 431
KCBS: nbseg[18] is 430
KCBS: nbseg[19] is 431
KCBS: Act cnt = 4366
KSOLS: Begin dumping all object level stats elements
KSOLS: Done dumping all elements. Exiting.
Dump event group for SESSION
Dump event group for SYSTEM
DYNAMICALLY MODIFIED PARAMETERS:
plsql_compiler_flags = INTERPRETED, DEBUG
plsql_debug = TRUE
plsql_optimize_level = 0
opitsk: network error occurred while two-task server trying tosend break; error code = 24365
问题分析
主要是出在Cursor打开状态不正确上。该trace文件中有两处输出，在状态记录中，打开的cursor中都有3号，而在session的cursor dump中，都没有3号，这应该就是出错原因了。
#4138行
CURSORS: size=4 count=2 next=4
index cursor tag context flags
----- ------ -------- -------- ---------------
2 3 0x2a972028d8 0x2a973e6910 LRU/PRS/[03]
3 4 0x2a972028d8 0x2a973e6a58 LRU/PRS/[03]
#4528行
CURSORS: size=4 count=4 next=5
index cursor tag context flags
----- ------ -------- -------- ---------------
1 8 (nil) 0x2a973a7eb8 LRU/PRS/PST[07]
2 9 (nil) 0x2a973948e8 LRU/PRS/PST[07]
3 10 (nil) 0x2a9739e320 LRU/PRS/PST[07]
4 1 (nil) 0x2a9739b8e0 LRU/PRS/PST[07]
#152206行
CURSORS: size=4 count=2 next=4
index cursor tag context flags
----- ------ -------- -------- ---------------
2 3 0x2a972028d8 0x2a973e6910 LRU/PRS/[03]
3 4 0x2a972028d8 0x2a973e6a58 LRU/PRS/[03]
#152416行
CURSORS: size=4 count=4 next=5
index cursor tag context flags
----- ------ -------- -------- ---------------
1 8 (nil) 0x2a973a7eb8 LRU/PRS/PST[07]
2 9 (nil) 0x2a973948e8 LRU/PRS/PST[07]
3 10 (nil) 0x2a9739e320 LRU/PRS/PST[07]
4 1 (nil) 0x2a9739b8e0 LRU/PRS/PST[07]
#4539行
******************** Session Cursor Dump **********************
Current cursor: 0, pgadep: 0
Open cursors(pls, sys, hwm, max): 5(1, 4, 64, 300)
NULL 4 SYNTAX 0 PARSE 0 BOUND 1 FETCH 0 ROW 0
Cached frame pages(total, free):
4k(78, 78), 8k(9, 9), 16k(2, 2), 32k(0, 0)
----------------------------------------
Cursor#4(0x2a97211848) state=BOUND curiob=0x2a973e4208
curflg=c7 fl2=0 par=(nil) ses=0x15a688e88
sqltxt(0x15e662678)=SELECT COUNT(*) FROM ALL_USERS WHERE USER_ID = :B1
hash=be6dbbd4a42f33eeaf34efe4802499b9
parent=0x14cd41760 maxchild=02 plk=0x153e59250 ppn=n
cursor instantiation=0x2a973e4208 used=1409125312
child#0(0x15e65c108) pcs=0x14cd41370
clk=0x153b84f60 ci=0x13baaade8 pn=(nil) ctx=0x13d940988
kgsccflg=0 llk[0x2a973e4210,0x2a973e4210] idx=0
xscflg=80151436 fl2=5000001 fl3=8218c fl4=0
Bind bytecodes
Opcode = 1 Unoptimized
Offsi = 48, Offsi = 0
kkscoacd
Bind#0
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1206001 frm=00 csi=00 siz=24 off=0
No bind buffers allocated
Frames pfr 0x2a973e4170 siz=8224 efr 0x2a973e4088 siz=8176
Cursor frame dump
enxt: 5.0x00000010
pnxt: 2.0x00000020 pnxt: 1.0x00000010
kxscphp 0x2a97393ce8 siz=984 inu=728 nps=600
kxscdfhp 0x2a97393568 siz=984 inu=88 nps=0
----------------------------------------
Cursor#8(0x2a972119e8) state=NULL curiob=0x2a97406d40
curflg=1045 fl2=0 par=(nil) ses=0x15a688e88
sqltxt(0x15df314f8)=table_1_ff_14f_0_0_0
hash=aea003b000399a6247b4cb0dca3f6508
parent=0x14efcc690 maxchild=01 plk=0x1538b1b50 ppn=n
cursor instantiation=0x2a97406d40 used=1409125312
child#0(0x15df31378) pcs=0x14efa08a8
clk=0x153c49238 ci=0x14ef9ff90 pn=0x1448da1c8 ctx=0x14ef9cbe8
kgsccflg=0 llk[0x2a97406d48,0x2a97406d48] idx=0
xscflg=7e fl2=0 fl3=2000 fl4=100
Frames pfr (nil) siz=344 efr (nil) siz=328
Cursor frame dump
enxt: 1.0x00000148
pnxt: 1.0x00000010
----------------------------------------
Cursor#9(0x2a97211a50) state=NULL curiob=0x2a973a3388
curflg=1045 fl2=0 par=(nil) ses=0x15a688e88
sqltxt(0x15df182a8)=table_1_ff_154_0_0_0
hash=cad74ce7637561efa6f8194e0d02f4b4
parent=0x14ef75478 maxchild=01 plk=0x153dfd2c8 ppn=n
cursor instantiation=0x2a973a3388 used=1409125312
child#0(0x15df18080) pcs=0x14ef75088
clk=0x153a1d610 ci=0x14ef74770 pn=0x1448da200 ctx=0x14ef70f70
kgsccflg=0 llk[0x2a973a3390,0x2a973a3390] idx=0
xscflg=7e fl2=0 fl3=2000 fl4=100
Frames pfr (nil) siz=344 efr (nil) siz=328
Cursor frame dump
enxt: 1.0x00000148
pnxt: 1.0x00000010
----------------------------------------
Cursor#10(0x2a97211ab8) state=NULL curiob=0x2a97225930
curflg=1045 fl2=0 par=(nil) ses=0x15a688e88
sqltxt(0x15df179c0)=table_1_ff_159_0_0_0
hash=cea98eb383a7c4f3282daa78daefc53a
parent=0x14ef6ff70 maxchild=01 plk=0x153f928f8 ppn=n
cursor instantiation=0x2a97225930 used=1409125312
child#0(0x15df17798) pcs=0x14ef6fb80
clk=0x153f91ee8 ci=0x14ef6f268 pn=0x1448da238 ctx=0x14ef6ba68
kgsccflg=0 llk[0x2a97225938,0x2a97225938] idx=0
xscflg=7e fl2=0 fl3=2000 fl4=100
Frames pfr (nil) siz=344 efr (nil) siz=328
Cursor frame dump
enxt: 1.0x00000148
pnxt: 1.0x00000010
----------------------------------------
Cursor#1(0x2a97211710) state=NULL curiob=0x2aa0296698
curflg=1045 fl2=0 par=(nil) ses=0x15a688e88
sqltxt(0x15df314f8)=table_1_ff_14f_0_0_0
hash=aea003b000399a6247b4cb0dca3f6508
parent=0x14efcc690 maxchild=01 plk=0x1537520b0 ppn=n
cursor instantiation=0x2aa0296698 used=1409127516
child#0(0x15df31378) pcs=0x14efa08a8
clk=0x153d3bb80 ci=0x14ef9ff90 pn=0x1448da2a8 ctx=0x14ef9cbe8
kgsccflg=0 llk[0x2aa02966a0,0x2aa02966a0] idx=0
xscflg=7e fl2=0 fl3=2002000 fl4=100
Frames pfr (nil) siz=344 efr (nil) siz=328
Cursor frame dump
enxt: 1.0x00000148
pnxt: 1.0x00000010
Session cached cursors
-----------------------------------------------------------
-------------- Generic Session Cached Cursors Dump --------
-----------------------------------------------------------
hash table=0x2a97213290 cnt=20 LRU=0x2a97206bb0 cnt=20 hit=4868 max=20 NumberOfTypes=3
type#0 name=KQD count=2
type#1 name=KQD BUN count=0
type#2 name=KKS count=18
Bucket#001 seg=0x2a972132b0 nit=4 nal=4 ips=4 sz=24 flg=3 ucnt=0
0 cob=0x2a97229e00 0 flg=0 typ=2 idx=1 cur=(nil) lru=0 flg=0 hdl=(nil)
1 cob=0x2a97229e18 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
2 cob=0x2a97229e30 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
3 cob=0x2a97229e48 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
#152427行
******************** Session Cursor Dump **********************
Current cursor: 0, pgadep: 0
Open cursors(pls, sys, hwm, max): 5(1, 4, 64, 300)
NULL 4 SYNTAX 0 PARSE 0 BOUND 1 FETCH 0 ROW 0
Cached frame pages(total, free):
4k(78, 78), 8k(9, 9), 16k(2, 2), 32k(0, 0)
----------------------------------------
Cursor#4(0x2a97211848) state=BOUND curiob=0x2a973e4208
curflg=c7 fl2=0 par=(nil) ses=0x15a688e88
sqltxt(0x15e662678)=SELECT COUNT(*) FROM ALL_USERS WHERE USER_ID = :B1
hash=be6dbbd4a42f33eeaf34efe4802499b9
parent=0x14cd41760 maxchild=02 plk=0x153e59250 ppn=n
cursor instantiation=0x2a973e4208 used=1409125312
child#0(0x15e65c108) pcs=0x14cd41370
clk=0x153b84f60 ci=0x13baaade8 pn=(nil) ctx=0x13d940988
kgsccflg=0 llk[0x2a973e4210,0x2a973e4210] idx=0
xscflg=80151436 fl2=5000001 fl3=8218c fl4=0
Bind bytecodes
Opcode = 1 Unoptimized
Offsi = 48, Offsi = 0
kkscoacd
Bind#0
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1206001 frm=00 csi=00 siz=24 off=0
No bind buffers allocated
Frames pfr 0x2a973e4170 siz=8224 efr 0x2a973e4088 siz=8176
Cursor frame dump
enxt: 5.0x00000010
pnxt: 2.0x00000020 pnxt: 1.0x00000010
kxscphp 0x2a97393ce8 siz=984 inu=728 nps=600
kxscdfhp 0x2a97393568 siz=984 inu=88 nps=0
----------------------------------------
Cursor#8(0x2a972119e8) state=NULL curiob=0x2a97406d40
curflg=1045 fl2=0 par=(nil) ses=0x15a688e88
sqltxt(0x15df314f8)=table_1_ff_14f_0_0_0
hash=aea003b000399a6247b4cb0dca3f6508
parent=0x14efcc690 maxchild=01 plk=0x1538b1b50 ppn=n
cursor instantiation=0x2a97406d40 used=1409125312
child#0(0x15df31378) pcs=0x14efa08a8
clk=0x153c49238 ci=0x14ef9ff90 pn=0x1448da1c8 ctx=0x14ef9cbe8
kgsccflg=0 llk[0x2a97406d48,0x2a97406d48] idx=0
xscflg=7e fl2=0 fl3=2000 fl4=100
Frames pfr (nil) siz=344 efr (nil) siz=328
Cursor frame dump
enxt: 1.0x00000148
pnxt: 1.0x00000010
----------------------------------------
Cursor#9(0x2a97211a50) state=NULL curiob=0x2a973a3388
curflg=1045 fl2=0 par=(nil) ses=0x15a688e88
sqltxt(0x15df182a8)=table_1_ff_154_0_0_0
hash=cad74ce7637561efa6f8194e0d02f4b4
parent=0x14ef75478 maxchild=01 plk=0x153dfd2c8 ppn=n
cursor instantiation=0x2a973a3388 used=1409125312
child#0(0x15df18080) pcs=0x14ef75088
clk=0x153a1d610 ci=0x14ef74770 pn=0x1448da200 ctx=0x14ef70f70
kgsccflg=0 llk[0x2a973a3390,0x2a973a3390] idx=0
xscflg=7e fl2=0 fl3=2000 fl4=100
Frames pfr (nil) siz=344 efr (nil) siz=328
Cursor frame dump
enxt: 1.0x00000148
pnxt: 1.0x00000010
----------------------------------------
Cursor#10(0x2a97211ab8) state=NULL curiob=0x2a97225930
curflg=1045 fl2=0 par=(nil) ses=0x15a688e88
sqltxt(0x15df179c0)=table_1_ff_159_0_0_0
hash=cea98eb383a7c4f3282daa78daefc53a
parent=0x14ef6ff70 maxchild=01 plk=0x153f928f8 ppn=n
cursor instantiation=0x2a97225930 used=1409125312
child#0(0x15df17798) pcs=0x14ef6fb80
clk=0x153f91ee8 ci=0x14ef6f268 pn=0x1448da238 ctx=0x14ef6ba68
kgsccflg=0 llk[0x2a97225938,0x2a97225938] idx=0
xscflg=7e fl2=0 fl3=2000 fl4=100
Frames pfr (nil) siz=344 efr (nil) siz=328
Cursor frame dump
enxt: 1.0x00000148
pnxt: 1.0x00000010
----------------------------------------
Cursor#1(0x2a97211710) state=NULL curiob=0x2aa0296698
curflg=1045 fl2=0 par=(nil) ses=0x15a688e88
sqltxt(0x15df314f8)=table_1_ff_14f_0_0_0
hash=aea003b000399a6247b4cb0dca3f6508
parent=0x14efcc690 maxchild=01 plk=0x1537520b0 ppn=n
cursor instantiation=0x2aa0296698 used=1409127516
child#0(0x15df31378) pcs=0x14efa08a8
clk=0x153d3bb80 ci=0x14ef9ff90 pn=0x1448da2a8 ctx=0x14ef9cbe8
kgsccflg=0 llk[0x2aa02966a0,0x2aa02966a0] idx=0
xscflg=7e fl2=0 fl3=2002000 fl4=100
Frames pfr (nil) siz=344 efr (nil) siz=328
Cursor frame dump
enxt: 1.0x00000148
pnxt: 1.0x00000010
Session cached cursors
-----------------------------------------------------------
-------------- Generic Session Cached Cursors Dump --------
-----------------------------------------------------------
hash table=0x2a97213290 cnt=20 LRU=0x2a97206bb0 cnt=20 hit=4868 max=20 NumberOfTypes=3
type#0 name=KQD count=2
type#1 name=KQD BUN count=0
type#2 name=KKS count=18
Bucket#001 seg=0x2a972132b0 nit=4 nal=4 ips=4 sz=24 flg=3 ucnt=0
0 cob=0x2a97229e00 0 flg=0 typ=2 idx=1 cur=(nil) lru=0 flg=0 hdl=(nil)
1 cob=0x2a97229e18 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
2 cob=0x2a97229e30 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
3 cob=0x2a97229e48 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
参考资料
http://www.askmaclean.com/archives/ora-0060017281-1001%E4%B8%80%E4%BE%8B.html
本页面的文字允许在知识共享 署名-相同方式共享 3.0协议和GNU自由文档许可证下修改和再使用，仅有一个特殊要求，请用链接方式注明文章引用出处及作者。请协助维护作者合法权益。
系列文章
文章列表
- Oracle记录一个ORA-00600错
这篇文章对你有帮助吗，投个票吧？
page revision: 21, last edited: 30 Aug 2014 11:01
留下你的评论