We are experiencing a deadlock between two processes trying to delete
two different rows from the same table. This table's key is a foreign
key in another table which is cleared before these rows are deleted.
Both tables have their primary keys indexed and these are used for
deletions.
I enclose a copy of the oracle error log - anyone know why this is
happening (I do have a suspicion it may have something to do with the
"REPLACE", but haven't found anything to confirm this)?
---------------------------------Oracle
Log------------------------------
Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production With
the Partitioning, OLAP and Oracle Data Mining options JServer Release
9.2.0.3.0
- Production ORACLE_HOME = /u01/app/oracle/product/9.2
System name: SunOS
Node name: shccc01u
Release: 5.9
Version: Generic_112233-04
Machine: sun4u
Instance name: s
Redo thread mounted by this instance: 1
Oracle process number: 15
Unix process pid: 16370, image: oracle_at_sh (TNS V1-V3)
- SESSION ID:(135.58179) 2004-06-20 01:50:30.614
DEADLOCK DETECTED
Current SQL statement for this session:
DELETE FROM TRANSFER WHERE REPLACE( CALL_REF, ' ', '' ) = REPLACE(
'24385', ' ', '' ) 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-00008013-00000000 15 135 SX SSX 43 113
SX
SSX
TM-00008013-00000000 43 113 SX SSX 15 135
SX
SSX
session 135: DID 0001-000F-00000002 session 113: DID
0001-002B-00000002 session 113: DID 0001-002B-00000002 session 135:
DID 0001-000F-00000002 Rows waited on: Session 113: no row Session
135: no row Information on the OTHER waiting sessions: Session 113:
pid=43 serial=20748 audsid=647896 user: 67/CAV
O/S info: user: IUSR_SH, term: SH, ospid: 1832:3164, machine:
program: SCCONT~1.EXE
application name: SCCONT~1.EXE, hash value=0
Current SQL Statement:
DELETE FROM TRANSFER WHERE REPLACE( CALL_REF, ' ', '' ) = REPLACE(
'25127', ' ', '' ) End of information on OTHER waiting sessions.
PROCESS STATE
Process global information:
process: 3ee99bc20, call: 3eecb0a58, xact: 3f0459fc8, curses:
3eeae2b10, usrses: 3eeae2b10
SO: 3ee99bc20, type: 2, owner: 0, flag: INIT/-/-/0x00
(process) Oracle pid=15, calls cur/top: 3eecb0a58/3eecb0a58, flag:
(0) -
int error: 0, call error: 0, sess error: 0, txn error 0
(post info) last post received: 195 0 4
last post received-location: kslpsr
last process to post me: 3ee9984c8 1 6
last post sent: 0 0 15
last post sent-location: ksasnd
last process posted by me: 3ee9984c8 1 6
(latch info) wait_event=0 bits=10
holding 38000a1a0 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 0x00000003EE996F40 to 0x00000003EE996F50 3EE996F40
00000000 00000000 00000000 00000000 [................]
Process Group: DEFAULT, pseudo proc: 3eea82fe0
O/S info: user: oracle, term: UNKNOWN, ospid: 16370
OSD pid info: Unix process pid: 16370, image: oracle_at_sh (TNS
V1-V3)
SO: 3ef7f5548, type: 8, owner: 3ee99bc20, flag: INIT/-/-/0x00
(FOB) flags=2 fib ptr=efd4f048 incno=0 pending i/o cnt=0
SO: 3ef7f5040, type: 8, owner: 3ee99bc20, flag: INIT/-/-/0x00
(FOB) flags=2 fib ptr=efd4c8a0 incno=0 pending i/o cnt=0
SO: 3ef7f37a0, type: 8, owner: 3ee99bc20, flag: INIT/-/-/0x00
(FOB) flags=2 fib ptr=efd4ed78 incno=0 pending i/o cnt=0
SO: 3ef7f3058, type: 8, owner: 3ee99bc20, flag: INIT/-/-/0x00
(FOB) flags=2 fib ptr=efd4eaa8 incno=0 pending i/o cnt=0
SO: 3eeae2b10, type: 4, owner: 3ee99bc20, flag: INIT/-/-/0x00
(session) trans: 3f0459fc8, creator: 3ee99bc20, flag: (100041)
USR/-
BSY/-/-/-/-/-
DID: 0001-000F-00000002, short-term DID:
0000-0000-00000000
txn branch: 0
oct: 7, prv: 0, sql: 3f2a82768, psql: 3f2a82768, user:
67/CAV
O/S info: user: IUSR_SH, term: SH, ospid: 5504:4920,
machine:
program: SCCONT~1.EXE
application name: SCCONT~1.EXE, hash value=0
last wait for 'null event' blocking sess=0xeead42b0 seq=7459
wait_time=3003303
=544d0005, =8013, =0
temporary object counter: 0
SO: 3f10546a8, type: 52, owner: 3eeae2b10, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=3f10546a8 handle=3cab82db8 mode=S
lock=3f3bd64b8
user=3eeae2b10 session=3eeae2b10 count=1 mask=0041
savepoint=2954 flags=[00]
SO: 3f3bd64b8, type: 51, owner: 3eeae2b10, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=3f3bd64b8 handle=3cab82db8 mode=N
call pin=0 session pin=3f10546a8
htl=3f3bd6528[3f3047800,3f3047800] htb=3f3047800
user=3eeae2b10 session=3eeae2b10 count=1 flags=PNS/[08]
savepoint=2954
LIBRARY OBJECT HANDLE: handle=3cab82db8
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=S latch#=6
lwt=3cab82de8[3cab82de8,3cab82de8]
ltm=3cab82df8[3cab82df8,3cab82df8]
pwt=3cab82e18[3cab82e18,3cab82e18]
ptm=3cab82ea8[3cab82ea8,3cab82ea8]
ref=3cab82dc8[3fda34c28, 3fda34c28]
lnd=3cab82ec0[3cab82ec0,3cab82ec0]
LIBRARY OBJECT: object=3c9285dd0
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
DEPENDENCIES: count=2 size=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change
- -------- -------- ------ ---- ------
0 3fdcd7788 3ca8f8ad8 I/P/A 0 NONE
6 3c9285ef0 3ca8f81e8 I/P/A 1 NONE
SO: 3f0ee7788, type: 51, owner: 3eeae2b10, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=3f0ee7788 handle=3f2a82768 mode=N
call pin=3f0e4ab30 session pin=0
htl=3f0ee77f8[3f3047a90,3f3047a90] htb=3f3047a90
user=3eeae2b10 session=3eeae2b10 count=1 flags=[00]
savepoint=2953
LIBRARY OBJECT HANDLE: handle=3f2a82768
name=DELETE FROM TRANSFER WHERE REPLACE( CALL_REF, ' ', '' ) =
REPLACE( '24385', ' ', '' )
hash=443ec7bd timestamp=06-20-2004 01:50:27
namespace=CRSR flags=RON/KGHP/TIM/PN0/MED/[50010000]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch#=6
lwt=3f2a82798[3f2a82798,3f2a82798]
ltm=3f2a827a8[3f2a827a8,3f2a827a8]
pwt=3f2a827c8[3f2a827c8,3f2a827c8]
ptm=3f2a82858[3f2a82858,3f2a82858]
ref=3f2a82778[3f2a82778, 3f2a82778]
lnd=3f2a82870[3f2a82870,3f2a82870]
LIBRARY OBJECT: object=3f44fdf78
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
CHILDREN: size=16
child# table reference handle
- -------- --------- --------
0 3f44fe1b0 3fda34c28 3cab82db8
DATA BLOCKS:
data# heap pointer status pins change
- -------- -------- ------ ---- ------
0 3f44fe258 3f44fe070 I/P/A 0 NONE
SO: 3f0459fc8, type: 38, owner: 3eeae2b10, flag: INIT/-/-/0x00
(trans) bsn = 2949, flg = 0x01, flg2 = 0x00, prx = 0x0, ros =
2147483647, spn = 2958
efd = 5
parent xid: 0x0000.000.00000000
env: (scn: 0x0000.00000000 xid: 0x0000.000.00000000 uba:
0x00000000.0000.00 statement num=0 parent xid: xid:
0x0000.000.00000000
scn: 0x0000.00000000 0sch: scn: 0x0000.00000000)
cev: (spc = 0 arsp = 0 ubk tsn: 0 rdba: 0x00000000 useg tsn:
0
rdba: 0x00000000
hwm uba: 0x00000000.0000.00 col uba: 0x00000000.0000.00
num bl: 0 bk list: 0x0)
(enqueue) <no resource>
res: 0, prv: 0, sess: 0
xga: 0x0, heap: UGA
SO: 3f01e3ec0, type: 34, owner: 3f0459fc8, flag: INIT/-/-/0x00
DML LOCK: tab=32787 flg=01 chi=0
his[0]: mod=3 spn=2949
(enqueue) TM-00008013-00000000 DID: 0001-000F-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 3eeed7ea8, mode: SX, req: SSX, prv: 3f01e3cb8, sess:
3eeae2b10,
proc: 3ee99bc20
SO: 3f01e3e00, type: 34, owner: 3f0459fc8, flag: INIT/-/-/0x00
DML LOCK: tab=32785 flg=01 chi=1
his[0]: mod=2 spn=2949
his[1]: mod=3 spn=2957
(enqueue) TM-00008011-00000000 DID: 0001-000F-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 3eeed7f28, mode: SX, prv: 3eeed7f38, sess: 3eeae2b10,
proc: 3ee99bc20
SO: 3f01e3d40, type: 34, owner: 3f0459fc8, flag: INIT/-/-/0x00
DML LOCK: tab=32741 flg=01 chi=0
his[0]: mod=2 spn=2949
(enqueue) TM-00007FE5-00000000 DID: 0001-000F-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 3eeed7da8, mode: SS, prv: 3eeed7db8, sess: 3eeae2b10,
proc: 3ee99bc20
SO: 3f0e49a80, type: 51, owner: 3eeae2b10, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=3f0e49a80 handle=3f1dc43e0 mode=N
call pin=3f0ee8df0 session pin=0
htl=3f0e49af0[3f30470a0,3f30470a0] htb=3f30470a0
user=3eeae2b10 session=3eeae2b10 count=1 flags=CBB/[02]
savepoint=84
LIBRARY OBJECT HANDLE: handle=3f1dc43e0
name=SYS.DATABASE
hash=e471d81e 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#=6
lwt=3f1dc4410[3f1dc4410,3f1dc4410]
ltm=3f1dc4420[3f1dc4420,3f1dc4420]
pwt=3f1dc4440[3f1dc4440,3f1dc4440]
ptm=3f1dc44d0[3f1dc44d0,3f1dc44d0]
ref=3f1dc43f0[3f1dc43f0, 3f1dc43f0]
lnd=3f1dc44e8[3f1dc44e8,3f1dc44e8]
LIBRARY OBJECT: object=3f1dc4040
type=EVNT flags=EXS/LOC[0005] pflags= [00] status=VALD load=0
DATA BLOCKS:
data# heap pointer status pins change
- -------- -------- ------ ---- ------
0 3f1dc4320 3f1dc41e8 I/-/A 0 NONE
3 3f1dc4160 3f1dc3be8 I/-/A 0 NONE
SO: 3f0e4e3b8, type: 51, owner: 3eeae2b10, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=3f0e4e3b8 handle=3f19f6f08 mode=N
call pin=3f60ca728 session pin=0
htl=3f0e4e428[3f3047280,3f3047280] htb=3f3047280
user=3eeae2b10 session=3eeae2b10 count=1 flags=CBB/[02]
savepoint=84
LIBRARY OBJECT HANDLE: handle=3f19f6f08
name=CAV.CAV
hash=da7d6a3c 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#=9
lwt=3f19f6f38[3f19f6f38,3f19f6f38]
ltm=3f19f6f48[3f19f6f48,3f19f6f48]
pwt=3f19f6f68[3f19f6f68,3f19f6f68]
ptm=3f19f6ff8[3f19f6ff8,3f19f6ff8]
ref=3f19f6f18[3f19f6f18, 3f19f6f18]
lnd=3f19f7010[3f19f7010,3f19f7010]
LIBRARY OBJECT: object=3f875d520
type=EVNT flags=EXS/LOC[0005] pflags= [00] status=VALD load=0
DATA BLOCKS:
data# heap pointer status pins change
- -------- -------- ------ ---- ------
0 3f87663e0 3f875d6c8 I/-/A 0 NONE
3 3f875d640 3fbb58b30 I/-/A 0 NONE
SO: 3fbd95450, type: 50, owner: 3eeae2b10, flag: INIT/-/-/0x00
user lock: lock=3fbd95450 mode=S
user resource: user=3f0ec63d8 uid=67 mode=S
SO: 3ca2fcfb0, type: 50, owner: 3eeae2b10, flag: INIT/-/-/0x00
user lock: lock=3ca2fcfb0 mode=S
user resource: user=3f0ec63d8 uid=67 mode=S
SO: 3f047b948, type: 39, owner: 3eeae2b10, flag: INIT/-/-/0x00
(dummy) nxc=0, nlb=1
SO: 3f02afd90, type: 37, owner: 3f047b948, flag: -/-/-/0x00
(List of Blocks) next index = 16
index savepoint itli buffer hint rdba
0 2776 2 0x3dafb4300 0x440716a
1 2778 3 0x3d9fb4200 0x5000e5a
2 2817 1 0x3cdf8a400 0x441cc91
3 2828 2 0x3d9fa2200 0x441cca0
4 2831 2 0x3cffae700 0x500fd74
5 2833 2 0x3cdfa7e00 0x5002a8c
6 2835 39 0x3d6fdaa00 0x5011878
7 2837 39 0x3d6fbe500 0x5011a91
8 2849 1 0x3cefaa100 0x441cca8
9 2852 3 0x3dbff5700 0x501089e
10 2864 2 0x3d0fd4e00 0x441ccb4
11 2867 2 0x3d4f92900 0x5010947
12 2869 65 0x3cff8aa00 0x5011b2b
13 2871 53 0x3d6fb4b00 0x5011a83
14 2883 1 0x3dafd9d00 0x441cc73
15 2886 2 0x3ccfe9d00 0x500eca4
SO: 3eef53b50, type: 13, owner: 3ee99bc20, flag: INIT/-/-/0x00
(broadcast handle) flag: (2) ACTIVE SUBSCRIBER, owner: 3ee99bc20,
event: 273679, last message event: 273679,
last message waited event: 273679, messages
read: 0
channel: (3eef81e30) system events broadcast
channel
scope: 0, event: 273680, last mesage
event: 0,
publishers/subscribers: 0/116,
messages published: 0
SO: 3eecb0a58, type: 3, owner: 3ee99bc20, flag: INIT/-/-/0x00
(call) sess: cur 3eeae2b10, rec 0, usr 3eeae2b10; depth: 0
CURRENT SESSION'S INSTANTIATION STATE
current session=3eeae2b10
INSTANTIATION OBJECT: object=ffffffff7c46dd48
type="KOKA open cursor"[3] lock=0 handle=0 body=0 level=0
flags=FST[60] executions=0 REST OF INSTANTIATION OBJECT:
address=ffffffff7c46dde0 size=16 00000000 00000005 0000000a 00000000
INSTANTIATION OBJECT: object=ffffffff7c46dc88
type="KOKA pseudo cursor"[4] lock=0 handle=0 body=0 level=0
flags=FST[60] executions=0 REST OF INSTANTIATION OBJECT:
address=ffffffff7c46dd20 size=16 00000000 00000005 0000000a 00000000
INSTANTIATION OBJECT: object=ffffffff7c46b990
type="cursor"[2] lock=3f0ee7788 handle=3f2a82768 body=0 level=0
flags=FST[60] executions=0 REST OF INSTANTIATION OBJECT:
address=ffffffff7c46ba28 size=720 00000003 cab82db8 00000003 f3bd64b8
00000003 f10546a8 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00100024 10000008 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 ffffffff 7c460350
00000006 07000000 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 00000043 00000043 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
pgactx: 3ca8f81e8 ctxcbk: 3ca8f8638 ctxqbc: 0 ctxrws: 3fcf97d68
Explain
plan: Plan Table
| Operation | Name | Rows | Bytes
|
Cost | TQ |IN-OUT| PQ Distrib |Pstart| Pstop |
| DELETE STATEMENT | | 0 | 0
|
33 | | | | | |
| DELETE | | 0 | 0
|
0 | | | | | |
| INDEX FULL SCAN | OBJ#(32786) | 33 | 429
|
33 | | | | | |
Cursor Dump:
Cursor 1 (ffffffff7c460350): CURBOUND curiob: ffffffff7c46b990
curflg: 4c curpar: 0 curusr: 0 curses 3eeae2b10
cursor name: DELETE FROM TRANSFER WHERE REPLACE( CALL_REF, ' ', '' )
= REPLACE( '24385', ' ', '' ) child pin: 3f10546a8, child lock:
3f3bd64b8, parent lock: 3f0ee7788
xscflg: 100024, parent handle: 3f2a82768, xscfl2: 10000008
nxt: 3.0x00000368 nxt: 2.0x00000510 nxt: 1.0x00000630 Cursor frame
allocation dump:
frm: -------- Comment -------- Size Seg Off
End of cursor dump
***************** dump of cursor xsc=ffffffff7c46b990
- dump of shared cursor ------------------
HEAP DUMP heap name="sql area" desc=3c9285ef0
extent sz=0x1040 alt=32767 het=32 rec=0 flg=2 opc=5 parent=380000030
owner=0 nex=0 xsz=0x0 EXTENT 0 addr=3f85667e8
Chunk 3f85667f8 sz= 248 perm "perm "
alo=248
3F85667F0 50B38F00 000000F9 [P.......]
3F8566800 00000000 00000000 00000003 FCF97168 [..............qh]
3F8566810 000000F8 00000000 00000000 00000000 [................]
3F8566820 01000000 00000000 00000003 F8566890 [.............Vh.]
3F8566830 00000000 00000000 00000003 FCF974C0 [..............t.]
3F8566840 00000000 00000000 00000003 F8566898 [.............Vh.]
3F8566850 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3F8566870 00000000 00000000 02E00000 00000000 [................]
3F8566880 00000000 00000000 00000000 00000000 [................]
3F8566890 00000003 F85668C0 01000000 00000019 [.....Vh.........]
3F85668A0 05000684 000089E7 00008012 00080003 [................]
3F85668B0 00001FE8 00000000 00000000 000200FF [................]
3F85668C0 0A000000 00000016 00000028 00080000 [...........(....]
3F85668D0 00000003 FCF97CF0 05001FE8 00000003 [......|.........]
3F85668E0 03680000 12FA0327 00000020 00E80000 [.h.....'... ....]
EXTENT 1 addr=3fcf97158
Chunk 3fcf97168 sz= 3832 perm "perm "
alo=3832
3FCF97160 40B38F00 00000EF9 [@.......]
3FCF97170 00000000 00000000 00000003 CA8F81C8 [................]
3FCF97180 00000EF8 00000000 0000003A 01030000 [...........:....]
3FCF97190 03690100 00000000 00002000 00000000 [.i........ .....]
3FCF971A0 00000020 00080000 00000018 01D80000 [... ............]
3FCF971B0 00050005 00000000 00000000 00000003 [................]
3FCF971C0 00000003 FCF979A0 00000000 00000000 [......y.........]
3FCF971D0 00000000 00000000 00000003 CA8F8938 [...............8]
3FCF971E0 00000003 CA8F89A0 00000003 CA8F8A08 [................]
3FCF971F0 00000000 00000000 00000000 00000000 [................]
3FCF97200 00000003 FCF97218 00010000 00000000 [......r.........]
3FCF97210 FFFFFFFF 7C45CD68 00000038 02020000 [....|E.h...8....]
3FCF97220 00000000 00000000 00000000 00000000 [................]
3FCF97230 00000000 00000000 00000018 01E80000 [................]
3FCF97240 00000000 00000000 00000005 00000002 [................]
3FCF97250 00000000 00000000 00000000 00000000 [................]
3FCF97260 00000000 00000000 00000003 CA8F8898 [................]
3FCF97270 00000003 FCF97188 00000020 00080000 [......q.... ....]
3FCF97280 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3FCF972A0 00000000 00000000 00000003 FCF974C0 [..............t.]
3FCF972B0 00008011 00010000 00000000 00000000 [................]
3FCF972C0 00000000 00000010 00000043 00070007 [...........C....]
3FCF972D0 00000000 00786702 130C0B07 78680505 [.....xg.....xh..]
3FCF972E0 0D131278 6702130C 0B070000 00000000 [...xg...........]
3FCF972F0 00000000 00000000 00000000 00000000 [................]
3FCF97300 00000000 00000000 00000000 00000001 [................]
3FCF97310 00000000 00000000 000002E0 00000000 [................]
3FCF97320 00000000 00000000 00070000 00000000 [................]
3FCF97330 00000000 00000000 00000000 00000000 [................]
3FCF97340 00000000 00000000 FFFFFFFF 7C45EED8 [............|E..]
3FCF97350 00000000 00000000 00000003 FCF97430 [..............t0]
3FCF97360 00000003 FCF97430 FFFFFFFF 7C45E638 [......t0....|E.8]
3FCF97370 00000000 00000000 00000000 00000000 [................]
3FCF97380 00000000 00000000 00080000 00000000 [................]
3FCF97390 00000000 00000000 00000000 00000000 [................]
3FCF973A0 00000000 00000000 20000000 00000000 [........ .......]
3FCF973B0 00000000 00000000 00000000 00000000 [................]
Repeat 4 times
3FCF97400 00000003 CA8F8498 00000020 00000002 [........... ....]
3FCF97410 00100000 00000000 0000000C 00094341 [..............CA]
3FCF97420 56454E44 49534800 00000000 00000000 [VENDISH.........]
3FCF97430 40A9F000 00000000 0000032B 000002D6 [@..........+....]
3FCF97440 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3FCF97460 00000000 00000000 00002000 00000000 [.......... .....]
3FCF97470 00000000 00000000 00000000 00000000 [................]
3FCF97480 00000000 00000000 01000000 00000000 [................]
3FCF97490 00000000 00000000 00008011 00000000 [................]
3FCF974A0 00000000 00000000 00000020 000899C8 [........... ....]
3FCF974B0 00000000 00000001 00000000 00000000 [................]
3FCF974C0 00000018 01F80000 00000000 00000000 [................]
3FCF974D0 00008012 00000851 00040002 01010001 [.......Q........]
3FCF974E0 00000000 00000000 00000000 00000000 [................]
Repeat 3 times
3FCF97520 00000000 00000000 01000000 00000000 [................]
3FCF97530 00000003 FCF974DE 00000000 00000000 [......t.........]
3FCF97540 00000003 FCF97788 00000000 00000000 [......w.........]
3FCF97550 00000000 00000000 00000000 00000000 [................]
3FCF97560 00000000 00000000 FFFFFFFF 7C45EF08 [............|E..]
3FCF97570 00000000 00000000 00000000 00000000 [................]
3FCF97580 FFFFFFFF 7C45EF38 FFFFFFFF 7C45A9E8 [....|E.8....|E..]
3FCF97590 00000004 00000000 00000000 00000000 [................]
3FCF975A0 00000000 00000000 00000000 00000000 [................]
3FCF975B0 00000000 00008011 00000000 00000000 [................]
3FCF975C0 00000000 00000000 00000000 00000000 [................]
Repeat 14 times
3FCF976B0 00000003 FCF97B50 78670A01 0F041C00 [......{Pxg......]
3FCF976C0 00000003 FCF97910 00008011 03030100 [......y.........]
3FCF976D0 800000AA 00010001 00010100 000D000D [................]
3FCF976E0 00000001 00000000 00000000 00000000 [................]
3FCF976F0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3FCF97710 FFFFFFFF 7C45A718 00000000 00000000 [....|E..........]
3FCF97720 FFFFFFFF 7C459CB8 00000000 00000000 [....|E..........]
3FCF97730 03690100 00000000 00000000 00000000 [.i..............]
3FCF97740 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3FCF97760 00008011 00000000 00000003 FCF97980 [..............y.]
3FCF97770 00000003 FCF978A8 00000000 00000000 [......x.........]
3FCF97780 00000000 00000000 00000018 02180000 [................]
3FCF97790 00000018 00100000 01000000 00000000 [................]
3FCF977A0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3FCF977C0 00008012 00000E94 00000003 FCF978B8 [..............x.]
3FCF977D0 00000003 FCF978C0 01000002 0000000D [......x.........]
3FCF977E0 00000003 FCF978E8 00000000 00000000 [......x.........]
3FCF977F0 00000003 FCF978C8 00008011 00000000 [......x.........]
3FCF97800 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3FCF97820 00000000 00000E95 00000003 FCF978F0 [..............x.]
3FCF97830 00000003 FCF978F8 01000100 0000000D [......x.........]
3FCF97840 00000000 00000000 00000000 00000000 [................]
3FCF97850 00000000 00000000 00008013 00000000 [................]
3FCF97860 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3FCF97880 00000003 FCF97920 00590000 C0000000 [......y .Y......]
3FCF97890 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3FCF978B0 00000003 FCF97788 00010000 00000000 [......w.........]
3FCF978C0 00010000 00000000 00000019 05000684 [................]
3FCF978D0 000089E7 00008012 00000003 00000000 [................]
3FCF978E0 00000000 00000000 00000000 00000000 [................]
3FCF978F0 00010000 00000000 00010000 00000000 [................]
3FCF97900 00000000 00084341 4C4C5F52 45460000 [......CALL_REF..]
3FCF97910 00000000 00000000 00008013 04010100 [................]
3FCF97920 2073656C 65637420 2F2A2B20 616C6C5F [ select /*+ all_]
3FCF97930 726F7773 202A2F20 636F756E 74283129 [rows */ count(1)]
3FCF97940 2066726F 6D202243 4156454E 44495348 [ from "CAVENDISH]
3FCF97950 222E2254 52414E53 4645525F 4556454E ["."TRANSFER_EVEN]
3FCF97960 54222077 68657265 20224341 4C4C5F52 [T" where "CALL_R]
3FCF97970 45462220 3D203A31 00000000 00000000 [EF" = :1........]
3FCF97980 00000000 00000000 00000003 FCF972B0 [..............r.]
3FCF97990 00000000 00000000 00000003 FCF976D0 [..............v.]
3FCF979A0 32343338 35000000 00000000 3EEEEEEE [24385.......>...]
3FCF979B0 00000003 CA8F8900 00000003 FCF97168 [..............qh]
3FCF979C0 00000003 FCF979C0 00000003 FCF979C0 [......y.......y.]
3FCF979D0 00000000 00000000 FFFFFFFF 7C45EFB8 [............|E..]
3FCF979E0 FFFFFFFF 7C45EFB8 FFFFFFFF 7C45EFB8 [....|E......|E..]
3FCF979F0 00000000 00000000 00000000 00000000 [................]
3FCF97A00 00000000 00000000 00000001 00000000 [................]
3FCF97A10 00000000 00000000 40408000 00000000 [........@@......]
3FCF97A20 40408000 00000000 40408000 00000000 [@@......@@......]
Repeat 2 times
3FCF97A50 00000000 00000000 00000000 00000000 [................]
Repeat 5 times
3FCF97AB0 00000001 00000000 00000000 00000000 [................]
3FCF97AC0 00000000 00000000 407AD000 00000000 [........_at_z......]
3FCF97AD0 0000000D 00010000 00000000 00000000 [................]
3FCF97AE0 FFFFFFFF 7FFF9D80 00000000 00000000 [................]
3FCF97AF0 00000000 00000000 00000000 00000000 [................]
Repeat 4 times
3FCF97B40 00000000 00000000 00000005 00000000 [................]
3FCF97B50 00000000 000B5452 414E5346 45525F50 [......TRANSFER_P]
3FCF97B60 4B000000 00000000 00000003 FCF97278 [K.............rx]
3FCF97B70 00000000 000003E9 00004500 000A0000 [..........E.....]
3FCF97B80 00000000 00000000 00000000 00000000 [................]
Repeat 7 times
3FCF97C00 00000000 00000000 00000000 45010000 [............E...]
3FCF97C10 00000000 00000000 00000001 00000000 [................]
3FCF97C20 00000020 00080000 00000018 02680000 [... .........h..]
3FCF97C30 000A0000 00000000 00000000 00000000 [................]
3FCF97C40 00000003 FCF97CA0 00000000 00000000 [......|.........]
3FCF97C50 00000003 FCF97B70 00000000 00000000 [......{p........]
3FCF97C60 00000003 CA8F86F8 00000000 00000000 [................]
3FCF97C70 00000000 00000000 00000000 00000000 [................]
3FCF97C80 00000000 00000000 00020000 00000000 [................]
3FCF97C90 00000003 FCF97C08 00000003 CA8F8740 [......|........@]
3FCF97CA0 00000018 02680000 00000020 00080000 [.....h..... ....]
3FCF97CB0 000A0000 00000000 00000003 FCF97B70 [..............{p]
3FCF97CC0 FFFF0000 00000000 00000018 02800000 [................]
3FCF97CD0 00000020 00180000 000D0000 00010000 [... ............]
3FCF97CE0 00000003 FCF976D0 FFFF0000 00000000 [......v.........]
3FCF97CF0 00000003 CA8F8480 00000005 00000002 [................]
3FCF97D00 05100000 000C4C4F 00000003 FCF97CC8 [......LO......|.]
3FCF97D10 00000019 05000684 000089E7 00008012 [................]
3FCF97D20 00080003 00001FE8 00008011 00000090 [................]
3FCF97D30 00000000 10006E78 02502108 170B8012 [......nx.P!.....]
3FCF97D40 212101AD 21566CB8 01000000 00000000 [!!..!Vl.........]
3FCF97D50 00000018 02980000 00000000 00000000 [................]
3FCF97D60 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3FCF97D80 00000003 FCF97DB8 00000000 00000000 [......}.........]
3FCF97D90 00000018 02C00000 00000034 00000000 [...........4....]
3FCF97DA0 00000003 FCF97D30 00010000 00000000 [......}0........]
3FCF97DB0 00000003 CA8F8638 00000000 00000000 [.......8........]
3FCF97DC0 00000003 FCF97D68 00000000 00000000 [......}h........]
3FCF97DD0 00000000 00000000 00000003 FCF97C88 [..............|.]
3FCF97DE0 00000018 02C80000 00000019 00000000 [................]
3FCF97DF0 00000003 FCF97D38 00020000 00000000 [......}8........]
3FCF97E00 00000006 00000001 00000001 00000000 [................]
3FCF97E10 00000003 FCF971F0 00000003 FCF97CA0 [......q.......|.]
3FCF97E20 00000003 FCF97D08 00000003 FCF97F48 [......}........H]
3FCF97E30 00000020 00700000 00000020 00280000 [... .p..... .(..]
3FCF97E40 00000018 03B80000 00000000 00000000 [................]
3FCF97E50 00000000 00000000 00000000 00000000 [................]
Repeat 3 times
3FCF97E90 00000000 00000000 00000003 FCF97D10 [..............}.]
3FCF97EA0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3FCF97EC0 00000003 FCF972E3 00000000 00000000 [......r.........]
3FCF97ED0 00000000 00000000 00008012 00008011 [................]
3FCF97EE0 00000000 00001080 00010003 0003000F [................]
3FCF97EF0 00000101 00010101 00000000 00000000 [................]
3FCF97F00 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3FCF97F20 00000000 00000000 00002000 00000000 [.......... .....]
3FCF97F30 00000000 00000000 00000000 00000000 [................]
3FCF97F40 00000000 00000000 00000003 FCF97CC8 [..............|.]
3FCF97F50 00000003 F85668C8 00000003 F85668E8 [.....Vh......Vh.]
3FCF97F60 40000000 00008011 00010000 00000000 [@...............]
3FCF97F70 00000000 00000000 02040000 40000000 [............@...]
3FCF97F80 00010000 00000000 00000000 00000000 [................]
3FCF97F90 00000000 00000000 00000003 FCF98050 [...............P]
3FCF97FA0 00000003 FCF98050 00000000 00000360 [.......P.......`]
3FCF97FB0 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
3FCF97FE0 00000000 00000000 00000003 FCF98020 [............... ]
3FCF97FF0 00000000 00000000 00000000 00000000 [................]
3FCF98000 00000000 00000000 0147AE14 00000000 [.........G......]
3FCF98010 00000000 00000000 00000000 00000000 [................]
3FCF98020 02000000 00000016 0440018B 00008011 [.........@......]
3FCF98030 00008011 00080003 00001FE8 00000000 [................]
3FCF98040 00000000 12FA0327 000200FF 00000000 [.......'........]
3FCF98050 00030000 00000000 00000000 00000000 [................]
Chunk 3fcf98060 sz= 56 free " "
3FCF98060 D0B38F00 00000039 00000003 FCF97168 [.......9......qh]
3FCF98070 00000003 C9285F68 00000003 CA8F8A78 [.....(_h.......x]
3FCF98080 00000000 00000000 00000000 00000000 [................]
3FCF98090 00000000 00000000 [........]
EXTENT 2 addr=3ca8f81b8
Chunk 3ca8f81c8 sz= 2208 perm "perm "
alo=2208
3CA8F81C0 40B38F00 000008A1 [@.......]
3CA8F81D0 00000000 00000000 00000000 00000000 [................]
3CA8F81E0 000008A0 00000000 00000018 00080000 [................]
3CA8F81F0 00000018 00080000 00000000 00000000 [................]
3CA8F8200 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
3CA8F8230 FFFFFFFF 7C45EDD8 FFFFFFFF 7C45EDC8 [....|E......|E..]
3CA8F8240 00000000 00000000 00000000 00000000 [................]
3CA8F8250 00000000 00000000 00000003 CA8F8638 [...............8]
3CA8F8260 00000003 CA8F8610 00000000 00000000 [................]
3CA8F8270 00000000 00000000 00008310 07000000 [................]
3CA8F8280 00000000 00000000 00000000 00000000 [................]
3CA8F8290 00000000 00000000 78670213 0C0B0700 [........xg......]
3CA8F82A0 00000000 00000000 00000000 00000000 [................]
3CA8F82B0 00000000 00000000 00000003 FCF976C0 [..............v.]
3CA8F82C0 00000003 FCF97D68 00000000 00000000 [......}h........]
3CA8F82D0 00000003 F85668D0 00000000 00000000 [.....Vh.........]
3CA8F82E0 00000000 00000000 00000000 00000000 [................]
3CA8F82F0 00000003 FCF97400 00000000 00000000 [......t.........]
3CA8F8300 00000000 00000000 00000001 00000000 [................]
3CA8F8310 00000003 FCF974A0 00000003 FCF97768 [......t.......wh]
3CA8F8320 00000000 00000000 00000000 00000000 [................]
3CA8F8330 00000003 CA8F8B9C 00000000 00000000 [................]
3CA8F8340 00000000 00000000 00000000 00000000 [................]
Repeat 3 times
3CA8F8380 00000000 00000000 08000040 00000000 [...........@....]
3CA8F8390 00000003 FCF97B68 00000001 00000000 [......{h........]
3CA8F83A0 00000000 00000000 00000000 00000000 [................]
3CA8F83B0 00000000 0000002C 00000000 00000000 [.......,........]
3CA8F83C0 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
3CA8F83F0 40408000 00000000 00000000 00000000 [@@..............]
3CA8F8400 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3CA8F8420 00000003 CA8F84B0 00000000 00000000 [................]
3CA8F8430 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3CA8F8450 00000000 00000000 00000003 FCF97D48 [..............}H]
3CA8F8460 00010001 825D6EAF 00000001 00000000 [.....]n.........]
3CA8F8470 00000000 00000000 00000000 00000000 [................]
3CA8F8480 00000000 00000000 010000A0 00000001 [................]
3CA8F8490 06300000 00000000 00000000 00000000 [.0..............]
3CA8F84A0 01000003 00000001 00180002 00000000 [................]
3CA8F84B0 00000000 00000000 00000003 CA8F81E8 [................]
3CA8F84C0 00000000 00000000 00000000 00000000 [................]
3CA8F84D0 00000202 00000000 00000000 00000000 [................]
3CA8F84E0 00000003 CA8F8570 00000003 CA8F8540 [.......p.......@]
3CA8F84F0 00000003 CA8F8520 00000003 80023568 [....... ......5h]
3CA8F8500 00000000 00000000 00000000 00000000 [................]
3CA8F8510 00000003 CA8F85F8 00000003 CA8F8598 [................]
3CA8F8520 00000003 C9285EF0 FFFFFFFF 7C45FB20 [.....(^.....|E. ]
3CA8F8530 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3CA8F8550 00000003 CA8F84B0 00000000 00000000 [................]
3CA8F8560 00000000 00000000 00000000 00000000 [................]
3CA8F8570 00000000 00000000 00000003 CA8F84B0 [................]
3CA8F8580 00000002 00000000 00000003 CAB82DB8 [..............-.]
3CA8F8590 00000000 00000000 00000003 CA8F85C8 [................]
3CA8F85A0 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
3CA8F85D0 00000000 00000000 00000000 00000001 [................]
3CA8F85E0 00000000 00000000 00000000 00000000 [................]
3CA8F85F0 00000000 00000000 00000003 CA8F84B0 [................]
3CA8F8600 00000000 00000000 00000000 00000000 [................]
3CA8F8610 43415645 4E444953 48000000 00000000 [CAVENDISH.......]
3CA8F8620 00000000 00000000 00000000 00000900 [................]
3CA8F8630 00000043 00000000 00000000 00000000 [...C............]
3CA8F8640 00000000 00000000 00220000 00000000 [........."......]
3CA8F8650 00000003 FCF97990 00000003 FCF97F50 [......y........P]
3CA8F8660 00000003 F8566818 00020002 00010001 [.....Vh.........]
3CA8F8670 00000000 00000000 00000000 00000000 [................]
3CA8F8680 00000020 00C80000 00000000 00000000 [... ............]
3CA8F8690 00000000 00000000 00000003 FCF974C0 [..............t.]
3CA8F86A0 03000000 00000000 00000003 FCF97CA0 [..............|.]
3CA8F86B0 00020000 00000000 00000003 FCF97278 [..............rx]
3CA8F86C0 00000003 FCF97C08 00000003 CA8F86F8 [......|.........]
3CA8F86D0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3CA8F86F0 00000000 00000000 0000000C 00085452 [..............TR]
3CA8F8700 414E5346 45520000 00000000 3EEEEEEE [ANSFER......>...]
3CA8F8710 00000000 00000000 00000003 CA8F81C8 [................]
3CA8F8720 00000003 CA8F8720 00000003 CA8F8720 [....... ....... ]
3CA8F8730 0000001B 00075245 504C4143 45000000 [......REPLACE...]
3CA8F8740 00000024 01010000 03690100 00000000 [...$.....i......]
3CA8F8750 00000001 00040000 00000020 00180000 [........... ....]
3CA8F8760 00000018 02800000 000D000D 00000000 [................]
3CA8F8770 00000000 00000000 00000003 FCF97CC8 [..............|.]
3CA8F8780 04000000 00000000 00000003 FCF976D0 [..............v.]
3CA8F8790 00000000 00000000 00000000 00000000 [................]
3CA8F87A0 00000003 CA8F87C0 FFFFFFFF 7C45E758 [............|E.X]
3CA8F87B0 00000000 00000000 00000000 00000000 [................]
3CA8F87C0 00000024 00084341 4C4C5F52 45460000 [...$..CALL_REF..]
3CA8F87D0 0000002E 01030000 03690100 00000000 [.........i......]
3CA8F87E0 00000300 00000000 00000000 00000000 [................]
3CA8F87F0 00000018 01780000 00010001 00000000 [.....x..........]
3CA8F8800 00000000 00000000 00000003 CA8F8830 [...............0]
3CA8F8810 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3CA8F8830 20000000 00000000 00000033 01030000 [ ..........3....]
3CA8F8840 03690100 00000000 00000300 00000000 [.i..............]
3CA8F8850 00000000 00000000 00000018 01880000 [................]
3CA8F8860 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
3CA8F8890 00000000 00000000 0000001B 01020000 [................]
3CA8F88A0 03690100 00000000 00002000 00000000 [.i........ .....]
3CA8F88B0 00000020 00B80000 00000018 01980000 [... ............]
3CA8F88C0 000D000D 00000000 00000073 00000003 [...........s....]
3CA8F88D0 00000000 00000000 00000000 00000000 [................]
3CA8F88E0 00000000 00000000 00000003 CA8F8740 [...............@]
3CA8F88F0 00000003 CA8F87D0 00000003 CA8F8838 [...............8]
3CA8F8900 00000000 3EEEEEEE 00000003 CA8F8708 [....>...........]
3CA8F8910 00000003 CA8F81C8 00000003 CA8F8918 [................]
3CA8F8920 00000003 CA8F8918 0000003A 00075245 [...........:..RE]
3CA8F8930 504C4143 45000000 00000043 01030000 [PLACE......C....]
3CA8F8940 03690100 00000000 00000300 00000000 [.i..............]
3CA8F8950 00000000 00000000 00000018 01A80000 [................]
3CA8F8960 00050005 00000000 00000000 00000000 [................]
3CA8F8970 00000003 CA8F8998 00000000 00000000 [................]
3CA8F8980 00000000 00000000 00000000 00000000 [................]
3CA8F8990 00000000 00000000 32343338 35000000 [........24385...]
3CA8F89A0 0000004C 01030000 03690100 00000000 [...L.....i......]
3CA8F89B0 00000300 00000000 00000000 00000000 [................]
3CA8F89C0 00000018 01B80000 00010001 00000000 [................]
3CA8F89D0 00000000 00000000 00000003 CA8F8A00 [................]
3CA8F89E0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3CA8F8A00 20000000 00000000 00000051 01030000 [ ..........Q....]
3CA8F8A10 03690100 00000000 00000300 00000000 [.i..............]
3CA8F8A20 00000000 00000000 00000018 01C80000 [................]
3CA8F8A30 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
3CA8F8A60 00000000 00000000 [........]
Chunk 3ca8f8a68 sz= 40 free " "
3CA8F8A60 D0B38F00 00000029 [.......)]
3CA8F8A70 00000003 CA8F81C8 00000003 FCF98070 [...............p]
3CA8F8A80 00000003 C9285F68 00000000 00000000 [.....(_h........]
Total heap size = 6384
FREE LISTS:
Bucket 0 size=0
Chunk 3fcf98060 sz= 56 free " "
3FCF98060 D0B38F00 00000039 00000003 FCF97168 [.......9......qh]
3FCF98070 00000003 C9285F68 00000003 CA8F8A78 [.....(_h.......x]
3FCF98080 00000000 00000000 00000000 00000000 [................]
3FCF98090 00000000 00000000 [........]
Chunk 3ca8f8a68 sz= 40 free " "
3CA8F8A60 D0B38F00 00000029 [.......)]
3CA8F8A70 00000003 CA8F81C8 00000003 FCF98070 [...............p]
3CA8F8A80 00000003 C9285F68 00000000 00000000 [.....(_h........]
Total free space = 96
UNPINNED RECREATABLE CHUNKS (lru first):
PERMANENT CHUNKS:
Chunk 3f85667f8 sz= 248 perm "perm "
alo=248
3F85667F0 50B38F00 000000F9 [P.......]
3F8566800 00000000 00000000 00000003 FCF97168 [..............qh]
3F8566810 000000F8 00000000 00000000 00000000 [................]
3F8566820 01000000 00000000 00000003 F8566890 [.............Vh.]
3F8566830 00000000 00000000 00000003 FCF974C0 [..............t.]
3F8566840 00000000 00000000 00000003 F8566898 [.............Vh.]
3F8566850 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3F8566870 00000000 00000000 02E00000 00000000 [................]
3F8566880 00000000 00000000 00000000 00000000 [................]
3F8566890 00000003 F85668C0 01000000 00000019 [.....Vh.........]
3F85668A0 05000684 000089E7 00008012 00080003 [................]
3F85668B0 00001FE8 00000000 00000000 000200FF [................]
3F85668C0 0A000000 00000016 00000028 00080000 [...........(....]
3F85668D0 00000003 FCF97CF0 05001FE8 00000003 [......|.........]
3F85668E0 03680000 12FA0327 00000020 00E80000 [.h.....'... ....]
Chunk 3fcf97168 sz= 3832 perm "perm "
alo=3832
3FCF97160 40B38F00 00000EF9 [@.......]
3FCF97170 00000000 00000000 00000003 CA8F81C8 [................]
3FCF97180 00000EF8 00000000 0000003A 01030000 [...........:....]
3FCF97190 03690100 00000000 00002000 00000000 [.i........ .....]
3FCF971A0 00000020 00080000 00000018 01D80000 [... ............]
3FCF971B0 00050005 00000000 00000000 00000003 [................]
3FCF971C0 00000003 FCF979A0 00000000 00000000 [......y.........]
3FCF971D0 00000000 00000000 00000003 CA8F8938 [...............8]
3FCF971E0 00000003 CA8F89A0 00000003 CA8F8A08 [................]
3FCF971F0 00000000 00000000 00000000 00000000 [................]
3FCF97200 00000003 FCF97218 00010000 00000000 [......r.........]
3FCF97210 FFFFFFFF 7C45CD68 00000038 02020000 [....|E.h...8....]
3FCF97220 00000000 00000000 00000000 00000000 [................]
3FCF97230 00000000 00000000 00000018 01E80000 [................]
3FCF97240 00000000 00000000 00000005 00000002 [................]
3FCF97250 00000000 00000000 00000000 00000000 [................]
3FCF97260 00000000 00000000 00000003 CA8F8898 [................]
3FCF97270 00000003 FCF97188 00000020 00080000 [......q.... ....]
3FCF97280 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3FCF972A0 00000000 00000000 00000003 FCF974C0 [..............t.]
3FCF972B0 00008011 00010000 00000000 00000000 [................]
3FCF972C0 00000000 00000010 00000043 00070007 [...........C....]
3FCF972D0 00000000 00786702 130C0B07 78680505 [.....xg.....xh..]
3FCF972E0 0D131278 6702130C 0B070000 00000000 [...xg...........]
3FCF972F0 00000000 00000000 00000000 00000000 [................]
3FCF97300 00000000 00000000 00000000 00000001 [................]
3FCF97310 00000000 00000000 000002E0 00000000 [................]
3FCF97320 00000000 00000000 00070000 00000000 [................]
3FCF97330 00000000 00000000 00000000 00000000 [................]
3FCF97340 00000000 00000000 FFFFFFFF 7C45EED8 [............|E..]
3FCF97350 00000000 00000000 00000003 FCF97430 [..............t0]
3FCF97360 00000003 FCF97430 FFFFFFFF 7C45E638 [......t0....|E.8]
3FCF97370 00000000 00000000 00000000 00000000 [................]
3FCF97380 00000000 00000000 00080000 00000000 [................]
3FCF97390 00000000 00000000 00000000 00000000 [................]
3FCF973A0 00000000 00000000 20000000 00000000 [........ .......]
3FCF973B0 00000000 00000000 00000000 00000000 [................]
Repeat 4 times
3FCF97400 00000003 CA8F8498 00000020 00000002 [........... ....]
3FCF97410 00100000 00000000 0000000C 00094341 [..............CA]
3FCF97420 56454E44 49534800 00000000 00000000 [VENDISH.........]
3FCF97430 40A9F000 00000000 0000032B 000002D6 [@..........+....]
3FCF97440 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3FCF97460 00000000 00000000 00002000 00000000 [.......... .....]
3FCF97470 00000000 00000000 00000000 00000000 [................]
3FCF97480 00000000 00000000 01000000 00000000 [................]
3FCF97490 00000000 00000000 00008011 00000000 [................]
3FCF974A0 00000000 00000000 00000020 000899C8 [........... ....]
3FCF974B0 00000000 00000001 00000000 00000000 [................]
3FCF974C0 00000018 01F80000 00000000 00000000 [................]
3FCF974D0 00008012 00000851 00040002 01010001 [.......Q........]
3FCF974E0 00000000 00000000 00000000 00000000 [................]
Repeat 3 times
3FCF97520 00000000 00000000 01000000 00000000 [................]
3FCF97530 00000003 FCF974DE 00000000 00000000 [......t.........]
3FCF97540 00000003 FCF97788 00000000 00000000 [......w.........]
3FCF97550 00000000 00000000 00000000 00000000 [................]
3FCF97560 00000000 00000000 FFFFFFFF 7C45EF08 [............|E..]
3FCF97570 00000000 00000000 00000000 00000000 [................]
3FCF97580 FFFFFFFF 7C45EF38 FFFFFFFF 7C45A9E8 [....|E.8....|E..]
3FCF97590 00000004 00000000 00000000 00000000 [................]
3FCF975A0 00000000 00000000 00000000 00000000 [................]
3FCF975B0 00000000 00008011 00000000 00000000 [................]
3FCF975C0 00000000 00000000 00000000 00000000 [................]
Repeat 14 times
3FCF976B0 00000003 FCF97B50 78670A01 0F041C00 [......{Pxg......]
3FCF976C0 00000003 FCF97910 00008011 03030100 [......y.........]
3FCF976D0 800000AA 00010001 00010100 000D000D [................]
3FCF976E0 00000001 00000000 00000000 00000000 [................]
3FCF976F0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3FCF97710 FFFFFFFF 7C45A718 00000000 00000000 [....|E..........]
3FCF97720 FFFFFFFF 7C459CB8 00000000 00000000 [....|E..........]
3FCF97730 03690100 00000000 00000000 00000000 [.i..............]
3FCF97740 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3FCF97760 00008011 00000000 00000003 FCF97980 [..............y.]
3FCF97770 00000003 FCF978A8 00000000 00000000 [......x.........]
3FCF97780 00000000 00000000 00000018 02180000 [................]
3FCF97790 00000018 00100000 01000000 00000000 [................]
3FCF977A0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3FCF977C0 00008012 00000E94 00000003 FCF978B8 [..............x.]
3FCF977D0 00000003 FCF978C0 01000002 0000000D [......x.........]
3FCF977E0 00000003 FCF978E8 00000000 00000000 [......x.........]
3FCF977F0 00000003 FCF978C8 00008011 00000000 [......x.........]
3FCF97800 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3FCF97820 00000000 00000E95 00000003 FCF978F0 [..............x.]
3FCF97830 00000003 FCF978F8 01000100 0000000D [......x.........]
3FCF97840 00000000 00000000 00000000 00000000 [................]
3FCF97850 00000000 00000000 00008013 00000000 [................]
3FCF97860 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3FCF97880 00000003 FCF97920 00590000 C0000000 [......y .Y......]
3FCF97890 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3FCF978B0 00000003 FCF97788 00010000 00000000 [......w.........]
3FCF978C0 00010000 00000000 00000019 05000684 [................]
3FCF978D0 000089E7 00008012 00000003 00000000 [................]
3FCF978E0 00000000 00000000 00000000 00000000 [................]
3FCF978F0 00010000 00000000 00010000 00000000 [................]
3FCF97900 00000000 00084341 4C4C5F52 45460000 [......CALL_REF..]
3FCF97910 00000000 00000000 00008013 04010100 [................]
3FCF97920 2073656C 65637420 2F2A2B20 616C6C5F [ select /*+ all_]
3FCF97930 726F7773 202A2F20 636F756E 74283129 [rows */ count(1)]
3FCF97940 2066726F 6D202243 4156454E 44495348 [ from "CAVENDISH]
3FCF97950 222E2254 52414E53 4645525F 4556454E ["."TRANSFER_EVEN]
3FCF97960 54222077 68657265 20224341 4C4C5F52 [T" where "CALL_R]
3FCF97970 45462220 3D203A31 00000000 00000000 [EF" = :1........]
3FCF97980 00000000 00000000 00000003 FCF972B0 [..............r.]
3FCF97990 00000000 00000000 00000003 FCF976D0 [..............v.]
3FCF979A0 32343338 35000000 00000000 3EEEEEEE [24385.......>...]
3FCF979B0 00000003 CA8F8900 00000003 FCF97168 [..............qh]
3FCF979C0 00000003 FCF979C0 00000003 FCF979C0 [......y.......y.]
3FCF979D0 00000000 00000000 FFFFFFFF 7C45EFB8 [............|E..]
3FCF979E0 FFFFFFFF 7C45EFB8 FFFFFFFF 7C45EFB8 [....|E......|E..]
3FCF979F0 00000000 00000000 00000000 00000000 [................]
3FCF97A00 00000000 00000000 00000001 00000000 [................]
3FCF97A10 00000000 00000000 40408000 00000000 [........@@......]
3FCF97A20 40408000 00000000 40408000 00000000 [@@......@@......]
Repeat 2 times
3FCF97A50 00000000 00000000 00000000 00000000 [................]
Repeat 5 times
3FCF97AB0 00000001 00000000 00000000 00000000 [................]
3FCF97AC0 00000000 00000000 407AD000 00000000 [........_at_z......]
3FCF97AD0 0000000D 00010000 00000000 00000000 [................]
3FCF97AE0 FFFFFFFF 7FFF9D80 00000000 00000000 [................]
3FCF97AF0 00000000 00000000 00000000 00000000 [................]
Repeat 4 times
3FCF97B40 00000000 00000000 00000005 00000000 [................]
3FCF97B50 00000000 000B5452 414E5346 45525F50 [......TRANSFER_P]
3FCF97B60 4B000000 00000000 00000003 FCF97278 [K.............rx]
3FCF97B70 00000000 000003E9 00004500 000A0000 [..........E.....]
3FCF97B80 00000000 00000000 00000000 00000000 [................]
Repeat 7 times
3FCF97C00 00000000 00000000 00000000 45010000 [............E...]
3FCF97C10 00000000 00000000 00000001 00000000 [................]
3FCF97C20 00000020 00080000 00000018 02680000 [... .........h..]
3FCF97C30 000A0000 00000000 00000000 00000000 [................]
3FCF97C40 00000003 FCF97CA0 00000000 00000000 [......|.........]
3FCF97C50 00000003 FCF97B70 00000000 00000000 [......{p........]
3FCF97C60 00000003 CA8F86F8 00000000 00000000 [................]
3FCF97C70 00000000 00000000 00000000 00000000 [................]
3FCF97C80 00000000 00000000 00020000 00000000 [................]
3FCF97C90 00000003 FCF97C08 00000003 CA8F8740 [......|........@]
3FCF97CA0 00000018 02680000 00000020 00080000 [.....h..... ....]
3FCF97CB0 000A0000 00000000 00000003 FCF97B70 [..............{p]
3FCF97CC0 FFFF0000 00000000 00000018 02800000 [................]
3FCF97CD0 00000020 00180000 000D0000 00010000 [... ............]
3FCF97CE0 00000003 FCF976D0 FFFF0000 00000000 [......v.........]
3FCF97CF0 00000003 CA8F8480 00000005 00000002 [................]
3FCF97D00 05100000 000C4C4F 00000003 FCF97CC8 [......LO......|.]
3FCF97D10 00000019 05000684 000089E7 00008012 [................]
3FCF97D20 00080003 00001FE8 00008011 00000090 [................]
3FCF97D30 00000000 10006E78 02502108 170B8012 [......nx.P!.....]
3FCF97D40 212101AD 21566CB8 01000000 00000000 [!!..!Vl.........]
3FCF97D50 00000018 02980000 00000000 00000000 [................]
3FCF97D60 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3FCF97D80 00000003 FCF97DB8 00000000 00000000 [......}.........]
3FCF97D90 00000018 02C00000 00000034 00000000 [...........4....]
3FCF97DA0 00000003 FCF97D30 00010000 00000000 [......}0........]
3FCF97DB0 00000003 CA8F8638 00000000 00000000 [.......8........]
3FCF97DC0 00000003 FCF97D68 00000000 00000000 [......}h........]
3FCF97DD0 00000000 00000000 00000003 FCF97C88 [..............|.]
3FCF97DE0 00000018 02C80000 00000019 00000000 [................]
3FCF97DF0 00000003 FCF97D38 00020000 00000000 [......}8........]
3FCF97E00 00000006 00000001 00000001 00000000 [................]
3FCF97E10 00000003 FCF971F0 00000003 FCF97CA0 [......q.......|.]
3FCF97E20 00000003 FCF97D08 00000003 FCF97F48 [......}........H]
3FCF97E30 00000020 00700000 00000020 00280000 [... .p..... .(..]
3FCF97E40 00000018 03B80000 00000000 00000000 [................]
3FCF97E50 00000000 00000000 00000000 00000000 [................]
Repeat 3 times
3FCF97E90 00000000 00000000 00000003 FCF97D10 [..............}.]
3FCF97EA0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3FCF97EC0 00000003 FCF972E3 00000000 00000000 [......r.........]
3FCF97ED0 00000000 00000000 00008012 00008011 [................]
3FCF97EE0 00000000 00001080 00010003 0003000F [................]
3FCF97EF0 00000101 00010101 00000000 00000000 [................]
3FCF97F00 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3FCF97F20 00000000 00000000 00002000 00000000 [.......... .....]
3FCF97F30 00000000 00000000 00000000 00000000 [................]
3FCF97F40 00000000 00000000 00000003 FCF97CC8 [..............|.]
3FCF97F50 00000003 F85668C8 00000003 F85668E8 [.....Vh......Vh.]
3FCF97F60 40000000 00008011 00010000 00000000 [@...............]
3FCF97F70 00000000 00000000 02040000 40000000 [............@...]
3FCF97F80 00010000 00000000 00000000 00000000 [................]
3FCF97F90 00000000 00000000 00000003 FCF98050 [...............P]
3FCF97FA0 00000003 FCF98050 00000000 00000360 [.......P.......`]
3FCF97FB0 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
3FCF97FE0 00000000 00000000 00000003 FCF98020 [............... ]
3FCF97FF0 00000000 00000000 00000000 00000000 [................]
3FCF98000 00000000 00000000 0147AE14 00000000 [.........G......]
3FCF98010 00000000 00000000 00000000 00000000 [................]
3FCF98020 02000000 00000016 0440018B 00008011 [.........@......]
3FCF98030 00008011 00080003 00001FE8 00000000 [................]
3FCF98040 00000000 12FA0327 000200FF 00000000 [.......'........]
3FCF98050 00030000 00000000 00000000 00000000 [................]
Chunk 3ca8f81c8 sz= 2208 perm "perm "
alo=2208
3CA8F81C0 40B38F00 000008A1 [@.......]
3CA8F81D0 00000000 00000000 00000000 00000000 [................]
3CA8F81E0 000008A0 00000000 00000018 00080000 [................]
3CA8F81F0 00000018 00080000 00000000 00000000 [................]
3CA8F8200 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
3CA8F8230 FFFFFFFF 7C45EDD8 FFFFFFFF 7C45EDC8 [....|E......|E..]
3CA8F8240 00000000 00000000 00000000 00000000 [................]
3CA8F8250 00000000 00000000 00000003 CA8F8638 [...............8]
3CA8F8260 00000003 CA8F8610 00000000 00000000 [................]
3CA8F8270 00000000 00000000 00008310 07000000 [................]
3CA8F8280 00000000 00000000 00000000 00000000 [................]
3CA8F8290 00000000 00000000 78670213 0C0B0700 [........xg......]
3CA8F82A0 00000000 00000000 00000000 00000000 [................]
3CA8F82B0 00000000 00000000 00000003 FCF976C0 [..............v.]
3CA8F82C0 00000003 FCF97D68 00000000 00000000 [......}h........]
3CA8F82D0 00000003 F85668D0 00000000 00000000 [.....Vh.........]
3CA8F82E0 00000000 00000000 00000000 00000000 [................]
3CA8F82F0 00000003 FCF97400 00000000 00000000 [......t.........]
3CA8F8300 00000000 00000000 00000001 00000000 [................]
3CA8F8310 00000003 FCF974A0 00000003 FCF97768 [......t.......wh]
3CA8F8320 00000000 00000000 00000000 00000000 [................]
3CA8F8330 00000003 CA8F8B9C 00000000 00000000 [................]
3CA8F8340 00000000 00000000 00000000 00000000 [................]
Repeat 3 times
3CA8F8380 00000000 00000000 08000040 00000000 [...........@....]
3CA8F8390 00000003 FCF97B68 00000001 00000000 [......{h........]
3CA8F83A0 00000000 00000000 00000000 00000000 [................]
3CA8F83B0 00000000 0000002C 00000000 00000000 [.......,........]
3CA8F83C0 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
3CA8F83F0 40408000 00000000 00000000 00000000 [@@..............]
3CA8F8400 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3CA8F8420 00000003 CA8F84B0 00000000 00000000 [................]
3CA8F8430 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3CA8F8450 00000000 00000000 00000003 FCF97D48 [..............}H]
3CA8F8460 00010001 825D6EAF 00000001 00000000 [.....]n.........]
3CA8F8470 00000000 00000000 00000000 00000000 [................]
3CA8F8480 00000000 00000000 010000A0 00000001 [................]
3CA8F8490 06300000 00000000 00000000 00000000 [.0..............]
3CA8F84A0 01000003 00000001 00180002 00000000 [................]
3CA8F84B0 00000000 00000000 00000003 CA8F81E8 [................]
3CA8F84C0 00000000 00000000 00000000 00000000 [................]
3CA8F84D0 00000202 00000000 00000000 00000000 [................]
3CA8F84E0 00000003 CA8F8570 00000003 CA8F8540 [.......p.......@]
3CA8F84F0 00000003 CA8F8520 00000003 80023568 [....... ......5h]
3CA8F8500 00000000 00000000 00000000 00000000 [................]
3CA8F8510 00000003 CA8F85F8 00000003 CA8F8598 [................]
3CA8F8520 00000003 C9285EF0 FFFFFFFF 7C45FB20 [.....(^.....|E. ]
3CA8F8530 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3CA8F8550 00000003 CA8F84B0 00000000 00000000 [................]
3CA8F8560 00000000 00000000 00000000 00000000 [................]
3CA8F8570 00000000 00000000 00000003 CA8F84B0 [................]
3CA8F8580 00000002 00000000 00000003 CAB82DB8 [..............-.]
3CA8F8590 00000000 00000000 00000003 CA8F85C8 [................]
3CA8F85A0 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
3CA8F85D0 00000000 00000000 00000000 00000001 [................]
3CA8F85E0 00000000 00000000 00000000 00000000 [................]
3CA8F85F0 00000000 00000000 00000003 CA8F84B0 [................]
3CA8F8600 00000000 00000000 00000000 00000000 [................]
3CA8F8610 43415645 4E444953 48000000 00000000 [CAV.............]
3CA8F8620 00000000 00000000 00000000 00000900 [................]
3CA8F8630 00000043 00000000 00000000 00000000 [...C............]
3CA8F8640 00000000 00000000 00220000 00000000 [........."......]
3CA8F8650 00000003 FCF97990 00000003 FCF97F50 [......y........P]
3CA8F8660 00000003 F8566818 00020002 00010001 [.....Vh.........]
3CA8F8670 00000000 00000000 00000000 00000000 [................]
3CA8F8680 00000020 00C80000 00000000 00000000 [... ............]
3CA8F8690 00000000 00000000 00000003 FCF974C0 [..............t.]
3CA8F86A0 03000000 00000000 00000003 FCF97CA0 [..............|.]
3CA8F86B0 00020000 00000000 00000003 FCF97278 [..............rx]
3CA8F86C0 00000003 FCF97C08 00000003 CA8F86F8 [......|.........]
3CA8F86D0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3CA8F86F0 00000000 00000000 0000000C 00085452 [..............TR]
3CA8F8700 414E5346 45520000 00000000 3EEEEEEE [ANSFER......>...]
3CA8F8710 00000000 00000000 00000003 CA8F81C8 [................]
3CA8F8720 00000003 CA8F8720 00000003 CA8F8720 [....... ....... ]
3CA8F8730 0000001B 00075245 504C4143 45000000 [......REPLACE...]
3CA8F8740 00000024 01010000 03690100 00000000 [...$.....i......]
3CA8F8750 00000001 00040000 00000020 00180000 [........... ....]
3CA8F8760 00000018 02800000 000D000D 00000000 [................]
3CA8F8770 00000000 00000000 00000003 FCF97CC8 [..............|.]
3CA8F8780 04000000 00000000 00000003 FCF976D0 [..............v.]
3CA8F8790 00000000 00000000 00000000 00000000 [................]
3CA8F87A0 00000003 CA8F87C0 FFFFFFFF 7C45E758 [............|E.X]
3CA8F87B0 00000000 00000000 00000000 00000000 [................]
3CA8F87C0 00000024 00084341 4C4C5F52 45460000 [...$..CALL_REF..]
3CA8F87D0 0000002E 01030000 03690100 00000000 [.........i......]
3CA8F87E0 00000300 00000000 00000000 00000000 [................]
3CA8F87F0 00000018 01780000 00010001 00000000 [.....x..........]
3CA8F8800 00000000 00000000 00000003 CA8F8830 [...............0]
3CA8F8810 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3CA8F8830 20000000 00000000 00000033 01030000 [ ..........3....]
3CA8F8840 03690100 00000000 00000300 00000000 [.i..............]
3CA8F8850 00000000 00000000 00000018 01880000 [................]
3CA8F8860 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
3CA8F8890 00000000 00000000 0000001B 01020000 [................]
3CA8F88A0 03690100 00000000 00002000 00000000 [.i........ .....]
3CA8F88B0 00000020 00B80000 00000018 01980000 [... ............]
3CA8F88C0 000D000D 00000000 00000073 00000003 [...........s....]
3CA8F88D0 00000000 00000000 00000000 00000000 [................]
3CA8F88E0 00000000 00000000 00000003 CA8F8740 [...............@]
3CA8F88F0 00000003 CA8F87D0 00000003 CA8F8838 [...............8]
3CA8F8900 00000000 3EEEEEEE 00000003 CA8F8708 [....>...........]
3CA8F8910 00000003 CA8F81C8 00000003 CA8F8918 [................]
3CA8F8920 00000003 CA8F8918 0000003A 00075245 [...........:..RE]
3CA8F8930 504C4143 45000000 00000043 01030000 [PLACE......C....]
3CA8F8940 03690100 00000000 00000300 00000000 [.i..............]
3CA8F8950 00000000 00000000 00000018 01A80000 [................]
3CA8F8960 00050005 00000000 00000000 00000000 [................]
3CA8F8970 00000003 CA8F8998 00000000 00000000 [................]
3CA8F8980 00000000 00000000 00000000 00000000 [................]
3CA8F8990 00000000 00000000 32343338 35000000 [........24385...]
3CA8F89A0 0000004C 01030000 03690100 00000000 [...L.....i......]
3CA8F89B0 00000300 00000000 00000000 00000000 [................]
3CA8F89C0 00000018 01B80000 00010001 00000000 [................]
3CA8F89D0 00000000 00000000 00000003 CA8F8A00 [................]
3CA8F89E0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3CA8F8A00 20000000 00000000 00000051 01030000 [ ..........Q....]
3CA8F8A10 03690100 00000000 00000300 00000000 [.i..............]
3CA8F8A20 00000000 00000000 00000018 01C80000 [................]
3CA8F8A30 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
3CA8F8A60 00000000 00000000 [........]
Permanent space = 6288
MARKS:
Mark 3fcf979a8
Mark 3ca8f8900
Mark 3ca8f8708
END OF PROCESS STATE
Received on Wed Jun 30 2004 - 04:42:48 CDT
