Home » SQL & PL/SQL » SQL & PL/SQL » Deadlock during DELETE operation
Deadlock during DELETE operation [message #273773] Thu, 11 October 2007 11:23 Go to next message
sagimann
Messages: 8
Registered: October 2007
Junior Member
Hello,
I'm using Oracle 10g. I've been combing the Net for solutions to my problem... Many threads address the ORA-00060 error, but non which I found useful for one or more reasons Sad

My problem is this: I'm getting the ORA-00060 error (deadlock) when trying to delete from various tables, using 2 simultaneous xactions. The 2 deletion are of unrelated rows - not even through relationships.

I did some diagnostics, and found something that may be related, but I'm not sure if it is, and how I can resolve the issue:

The v$locked_object table shows that whenever I attempt a delete op from a table, its PARENT TABLE gets locked. Specifically:

DELETE FROM CHILD_TABLE where someid = 1;

causes CHILD_TABLE to be locked in lock-mode 2 (row-s, SS)
and PARENT_TABLE to be locked in lock-mode 3 (row-x, SX)
("grandparent" tables are not affected)

In my case, there are many DELETE ops, so after about 10 delete ops, the ENTIRE SCHEMA GETS LOCKED. I thought that Oracle 10g should not have allowed for this to happen :-/ Also, it only explains why a xaction would TIMEOUT - not why a DEADLOCK would occur...

The oracle trace file states that both xactions deadlock without rowid's.

Both xactions perform the delete ops in the same order, i.e. the go over a predefined (ordered) list of tables and remove certain records. No cascading is used, i.e. child records are explicitly deleted before parent tables.

Any ideas what's going on?
thanks...
Re: Deadlock during DELETE operation [message #273776 is a reply to message #273773] Thu, 11 October 2007 11:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
First, index your foreign keys.

Regards
Michel
Re: Deadlock during DELETE operation [message #274043 is a reply to message #273776] Sat, 13 October 2007 00:04 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Post the deadlock trace from the UDUMP directory.

Ross Leishman
Re: Deadlock during DELETE operation [message #274132 is a reply to message #273773] Sun, 14 October 2007 05:37 Go to previous messageGo to next message
sagimann
Messages: 8
Registered: October 2007
Junior Member
My foreign keys are indexed.
I've been able to manually reproduce this using a 3 table schema, and 2 sqlplus clients:

PARENT(id, name)
CHILD_GROUP(id, name, parent_id_fk)
CHILD(id, name, parent_id_fk, group_id_fk)

Note: parent_id_fk is NOT NULL and group_id_fk may be NULL.
There are no CASCADE declarations.

Now perform the following, using 2 clients A, B (no need to populate any data):

A: delete from CHILD;
success

Diagnostics: show locks
select object_name, l.locked_mode l.session_id from user_objects o, v$locked_object l where o.object_id = l.object_id

OBJECT_NAME / SESSION_ID / LOCKED_MODE
PARENT / 25 / 2(SS)
CHILD_GROUP / 25 / 2(SS)
CHILD / 25 / 3(SX)

B: delete from CHILD;
success

Diagnostics: show locks
select object_name, l.locked_mode, l.session_id from user_objects o, v$locked_object l where o.object_id = l.object_id

OBJECT_NAME / SESSION_ID / LOCKED_MODE
PARENT / 25 / 2(SS)
PARENT / 26 / 2(SS)
CHILD_GROUP / 25 / 2(SS)
CHILD_GROUP / 26 / 2(SS)
CHILD / 25 / 3(SX)
CHILD / 26 / 3(SX)

A: delete from CHILD_GROUP;
transaction is blocked!

B: delete from CHILD:
transaction is blocked!
A is "unblocked" with error:
ORA-00060: deadlock detected while waiting for resource


dump file (without memory dumps):


Dump file c:\oraclexe\app\oracle\admin\xe\udump\xe_ora_3980.trc
Sun Oct 14 12:28:34 2007
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
Windows XP Version V5.1 Service Pack 2
CPU : 1 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:141M/503M, Ph+PgF:708M/1230M, VA:1737M/2047M
Instance name: xe

Redo thread mounted by this instance: 1

Oracle process number: 20

Windows thread id: 3980, image: ORACLE.EXE (SHAD)


*** 2007-10-14 12:28:34.146
*** ACTION NAME:() 2007-10-14 12:28:34.146
*** MODULE NAME:(SQL*Plus) 2007-10-14 12:28:34.146
*** SERVICE NAME:(SYS$USERS) 2007-10-14 12:28:34.146
*** SESSION ID:(31.4) 2007-10-14 12:28:34.146
DEADLOCK DETECTED
[Transaction Deadlock]
Current SQL statement for this session:
delete from CHILD_GROUP
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-00007ad6-00000000 20 31 SX SSX 23 30 SX SSX
TM-00007ad6-00000000 23 30 SX SSX 20 31 SX SSX
session 31: DID 0001-0014-00000004 session 30: DID 0001-0017-00000002
session 30: DID 0001-0017-00000002 session 31: DID 0001-0014-00000004
Rows waited on:
Session 30: obj - rowid = 00007AD6 - AAAHrWAAEAAAA/LAAA
(dictionary objn - 31446, file - 4, block - 4043, slot - 0)
Session 31: obj - rowid = 000025C0 - AAACXAAABAAAG2JAAA
(dictionary objn - 9664, file - 1, block - 28041, slot - 0)
Information on the OTHER waiting sessions:
Session 30:
pid=23 serial=10 audsid=5795 user: 44/TESTUSER1
O/S info: user: TESTBOX1\SharedManager, term: TESTBOX1, ospid: 3560:1552, machine: MYDOMAIN\TESTBOX1
program: sqlplus.exe
application name: SQL*Plus, hash value=3669949024
Current SQL Statement:
delete from CHILD_GROUP
End of information on OTHER waiting sessions.
===================================================
PROCESS STATE
-------------
Process global information:
process: 6BD35D34, call: 6BD86EA8, xact: 6ADB3AA4, curses: 6BD67898, usrses: 6BD67898
----------------------------------------
SO: 6BD35D34, type: 2, owner: 00000000, flag: INIT/-/-/0x00
(process) Oracle pid=20, calls cur/top: 6BD86EA8/6BD86EA8, flag: (0) -
int error: 0, call error: 0, sess error: 0, txn error 0
(post info) last post received: 0 0 0
last post received-location: No post
last process to post me: none
last post sent: 0 0 0
last post sent-location: No post
last process posted by me: none
(latch info) wait_event=0 bits=10
holding (efd=4) 3c45bb8 Parent+children enqueue hash chains level=4
Location from where latch is held: ksqcmi: kslgpl:
Context saved from call: 0
state=busy, wlstate=free
recovery area:
Dump of memory from 0x6BD28D84 to 0x6BD28D94
6BD28D80 00000000 00000000 00000000 [............]
6BD28D90 00000000 [....]
Process Group: DEFAULT, pseudo proc: 6BD3DFC0
O/S info: user: SYSTEM, term: TESTBOX1, ospid: 3980
OSD pid info: Windows thread id: 3980, image: ORACLE.EXE (SHAD)
Dump of memory from 0x6BD2C824 to 0x6BD2C9A8
6BD2C820 00000005 6B707B80 00000010 [.....{pk....]
6BD2C830 0003139D 6BD86EA8 00000003 0003139D [.....n.k........]
6BD2C840 6BE4CCCC 0000000B 0003139D 6BD67898 [...k.........x.k]
6BD2C850 00000004 00031291 6AC975A4 00000007 [.........u.j....]
6BD2C860 0003139D 00000000 00000000 00000000 [................]
6BD2C870 00000000 00000000 00000000 00000000 [................]
Repeat 18 times
6BD2C9A0 00000000 00000000 [........]
(FOB) flags=2 fib=6ACD8534 incno=0 pending i/o cnt=0
fname=C:\ORACLEXE\ORADATA\XE\SYSTEM.DBF
fno=1 lblksz=4 fsiz=52201148
----------------------------------------
SO: 6BD67898, type: 4, owner: 6BD35D34, flag: INIT/-/-/0x00
(session) sid: 31 trans: 6ADB3AA4, creator: 6BD35D34, flag: (41) USR/- BSY/-/-/-/-/-
DID: 0001-0014-00000004, short-term DID: 0000-0000-00000000
txn branch: 00000000
oct: 7, prv: 0, sql: 6B914BF8, psql: 6B91F8B0, user: 44/TESTUSER1
O/S info: user: TESTBOX1\SharedManager, term: TESTBOX1, ospid: 580:3236, machine: MYDOMAIN\TESTBOX1
program: sqlplus.exe
application name: SQL*Plus, hash value=3669949024
last wait for 'enq: TM - contention' blocking sess=0x6BD665D0 seq=59 wait_time=3004242 seconds since wait started=36
name|mode=544d0005, object #=7ad6, table/partition=0
Dumping Session Wait History
for 'enq: TM - contention' count=1 wait_time=3004242
name|mode=544d0005, object #=7ad6, table/partition=0
for 'enq: TM - contention' count=1 wait_time=3004231
name|mode=544d0005, object #=7ad6, table/partition=0
for 'enq: TM - contention' count=1 wait_time=3004244
name|mode=544d0005, object #=7ad6, table/partition=0
for 'enq: TM - contention' count=1 wait_time=3004228
name|mode=544d0005, object #=7ad6, table/partition=0
for 'enq: TM - contention' count=1 wait_time=3004260
name|mode=544d0005, object #=7ad6, table/partition=0
for 'enq: TM - contention' count=1 wait_time=3004236
name|mode=544d0005, object #=7ad6, table/partition=0
for 'enq: TM - contention' count=1 wait_time=3004247
name|mode=544d0005, object #=7ad6, table/partition=0
for 'enq: TM - contention' count=1 wait_time=3004204
name|mode=544d0005, object #=7ad6, table/partition=0
for 'enq: TM - contention' count=1 wait_time=3004278
name|mode=544d0005, object #=7ad6, table/partition=0
for 'enq: TM - contention' count=1 wait_time=3004236
name|mode=544d0005, object #=7ad6, table/partition=0
temporary object counter: 0
----------------------------------------
Virtual Thread:
kgskvt: 6BABE188, sess: 6BD67898, vc: 00000000, proc: 6BD35D34
consumer group cur: OTHER_GROUPS (upd? 0), mapped: DEFAULT_CONSUMER_GROUP, orig:
vt_state: 0x4, vt_flags: 0x30, blkrun: 0
is_assigned: 1, in_sched: 0 (0)
vt_active: 0 (pending: 1)
used quanta: 110817 (cg: 110817)
cpu start time: 4285815115, quantum status: 0x2
quantum checks to skip: 27, check thresh: 28
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
KGX Atomic Operation Log 6B92A164
Mutex 00000000(0, 0) idn 0 oper NONE
Cursor Parent uid 31 efd 5 whr 11 slp 0
oper=NONE pt1=68BF3904 pt2=68BF3A00 pt3=68BF38D4
pt4=00000000 u41=0 stt=0
KGX Atomic Operation Log 6B92A18C
Mutex 6B914CAC(0, 1) idn 0 oper NONE
Cursor Stat uid 31 efd 10 whr 1 slp 0
oper=NONE pt1=6B914BF8 pt2=00000000 pt3=00000000
pt4=00000000 u41=0 stt=8
KGX Atomic Operation Log 6B92A1B4
Mutex 00000000(0, 0) idn 0 oper NONE
Cursor Stat uid 31 efd 0 whr 0 slp 0
oper=NONE pt1=00000000 pt2=00000000 pt3=00000000
pt4=00000000 u41=0 stt=0
----------------------------------------
SO: 69D22A00, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d22a00 handle=6b91d954 mode=N
call pin=00000000 session pin=00000000 hpc=0000 hlc=0000
htl=69D22A50[69D54A5C,69D4A4CC] htb=69D4A4CC ssga=69D49EB0
user=6bd67898 session=6bd67898 count=0 flags=LRU/[4000] savepoint=0x6ec
LIBRARY OBJECT HANDLE: handle=6b91d954 mutex=6B91DA08(0)
name=TESTUSER1.CHILD_GROUP
hash=61a12512dee7a67117d224c0c75d09ad timestamp=10-11-2007 18:33:43
namespace=TABL flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0749-0749 lock=N pin=0 latch#=1 hpc=0004 hlc=0004
lwt=6B91D9B0[6B91D9B0,6B91D9B0] ltm=6B91D9B8[6B91D9B8,6B91D9B8]
pwt=6B91D994[6B91D994,6B91D994] ptm=6B91D99C[6B91D99C,6B91D99C]
ref=6B91D9D0[6B91D9D0,6B91D9D0] lnd=6B91D9DC[6B91D2D0,6B91E764]
LIBRARY OBJECT: object=6944219c
type=TABL flags=EXS/LOC[0005] pflags=[0000] status=VALD load=0
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6b91d8e4 694422a0 I/-/A/-/- 0 NONE 00
3 68bf1e04 69434034 I/-/A/-/- 0 NONE 00
8 6944240c 69442058 I/-/A/-/- 0 NONE 00
9 69442514 68bf25a0 I/-/A/-/- 0 NONE 00
10 694424a0 694418a0 I/-/A/-/- 0 NONE 00
----------------------------------------
SO: 69D548BC, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d548bc handle=6b91d248 mode=N
call pin=00000000 session pin=00000000 hpc=0000 hlc=0000
htl=69D5490C[69D4A394,69D4A394] htb=69D4A394 ssga=69D49EB0
user=6bd67898 session=6bd67898 count=0 flags=LRU/[4000] savepoint=0x736
LIBRARY OBJECT HANDLE: handle=6b91d248 mutex=6B91D2FC(0)
name=TESTUSER1.PARENT
hash=742a30d76f7899e2e9c337b2c0ea2f86 timestamp=10-11-2007 18:33:43
namespace=TABL flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0541-0541 lock=N pin=0 latch#=1 hpc=0004 hlc=0004
lwt=6B91D2A4[6B91D2A4,6B91D2A4] ltm=6B91D2AC[6B91D2AC,6B91D2AC]
pwt=6B91D288[6B91D288,6B91D288] ptm=6B91D290[6B91D290,6B91D290]
ref=6B91D2C4[6B91D2C4,6B91D2C4] lnd=6B91D2D0[6B91A928,6B91D9DC]
LIBRARY OBJECT: object=6943ee0c
type=TABL flags=EXS/LOC[0005] pflags=[0000] status=VALD load=0
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6b91d1d8 6943ef10 I/-/A/-/- 0 NONE 00
8 6943f07c 6943ecc8 I/-/A/-/- 0 NONE 00
10 6943f110 6943e940 I/-/A/-/- 0 NONE 00
----------------------------------------
SO: 69D38AE8, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d38ae8 handle=6b91f1e4 mode=N
call pin=00000000 session pin=00000000 hpc=0000 hlc=0000
htl=69D38B38[69D4C23C,69D4A43C] htb=69D4A43C ssga=69D49EB0
user=6bd67898 session=6bd67898 count=0 flags=LRU/[4000] savepoint=0x736
LIBRARY OBJECT HANDLE: handle=6b91f1e4 mutex=6B91F298(0)
name=TESTUSER1.CHILD
hash=827cc4d532c8c2f5e5ace46bd27b519b timestamp=10-11-2007 18:33:43
namespace=TABL flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0709-0709 lock=N pin=0 latch#=1 hpc=0002 hlc=0002
lwt=6B91F240[6B91F240,6B91F240] ltm=6B91F248[6B91F248,6B91F248]
pwt=6B91F224[6B91F224,6B91F224] ptm=6B91F22C[6B91F22C,6B91F22C]
ref=6B91F260[6B91F260,6B91F260] lnd=6B91F26C[6B91E764,6B91F938]
LIBRARY OBJECT: object=69447f60
type=TABL flags=EXS/LOC[0005] pflags=[0000] status=VALD load=0
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6b91f174 69447ff8 I/-/A/-/- 0 NONE 00
3 69443edc 69443abc I/-/A/-/- 0 NONE 00
8 69448188 69447e1c I/-/A/-/- 0 NONE 00
9 694482b4 69444678 I/-/A/-/- 0 NONE 00
10 69448240 69447664 I/-/A/-/- 0 NONE 00
----------------------------------------
SO: 69D7B028, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d7b028 handle=6ba60368 mode=N
call pin=00000000 session pin=69D14ED8 hpc=0000 hlc=0000
htl=69D7B078[69D7B008,69D4A11C] htb=69D4A11C ssga=69D49EB0
user=6bd67898 session=6bd607e8 count=1 flags=[0000] savepoint=0x0
LIBRARY OBJECT HANDLE: handle=6ba60368 mutex=6BA6041C(0)
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch#=1 hpc=002e hlc=002e
lwt=6BA603C4[6BA603C4,6BA603C4] ltm=6BA603CC[6BA603CC,6BA603CC]
pwt=6BA603A8[6BA603A8,6BA603A8] ptm=6BA603B0[6BA603B0,6BA603B0]
ref=6BA603E4[6964A930,6964A930] lnd=6BA603F0[6BA603F0,6BA603F0]
LIBRARY OBJECT: object=6964a490
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
DEPENDENCIES: count=1 size=16
READ ONLY DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6ba602f8 6964a5e0 I/P/A/-/- 0 NONE 00
6 69649e44 693aaae4 I/-/A/-/- 0 NONE 00
----------------------------------------
SO: 69D7AFB8, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d7afb8 handle=6ba604ac mode=N
call pin=00000000 session pin=00000000 hpc=0000 hlc=0000
htl=69D7B008[69D54BAC,69D7B078] htb=69D4A11C ssga=69D49EB0
user=6bd67898 session=6bd607e8 count=1 flags=[0000] savepoint=0x738
LIBRARY OBJECT HANDLE: handle=6ba604ac mutex=6BA60560(1)
name=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 timestamp=10-14-2007 12:23:52
namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=1 hpc=002e hlc=002e
lwt=6BA60508[6BA60508,6BA60508] ltm=6BA60510[6BA60510,6BA60510]
pwt=6BA604EC[6BA604EC,6BA604EC] ptm=6BA604F4[6BA604F4,6BA604F4]
ref=6BA60528[6BA60528,6BA60528] lnd=6BA60534[6BADAB20,6BAEE158]
LIBRARY OBJECT: object=6964acf0
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
CHILDREN: size=16
child# table reference handle
------ -------- --------- --------
0 6964ac7c 6964a930 6ba60368
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6ba6043c 6964ad88 I/P/A/-/- 0 NONE 00
----------------------------------------
SO: 69D6192C, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d6192c handle=6bb06adc mode=N
call pin=00000000 session pin=00000000 hpc=0000 hlc=0000
htl=69D6197C[69D4A1D4,69D4A1D4] htb=69D4A1D4 ssga=69D49EB0
user=6bd67898 session=6bd607e8 count=0 flags=LRU/[4000] savepoint=0x733
LIBRARY OBJECT HANDLE: handle=6bb06adc mutex=6BB06B90(0)
name=SYS.OBJ$
hash=6bd508fcca69602620c1816e61c9fe4e timestamp=02-07-2006 22:10:16
namespace=TABL flags=PKP/KGHP/TIM/KEP/SML/BSO/[02900002]
kkkk-dddd-llll=0101-0301-0309 lock=N pin=0 latch#=1 hpc=0024 hlc=0024
lwt=6BB06B38[6BB06B38,6BB06B38] ltm=6BB06B40[6BB06B40,6BB06B40]
pwt=6BB06B1C[6BB06B1C,6BB06B1C] ptm=6BB06B24[6BB06B24,6BB06B24]
ref=6BB06B58[6BB06B58,6BB06B58] lnd=6BB06B64[6BB062A0,6BB06E00]
LIBRARY OBJECT: object=697c6934
type=TABL flags=EXS/LOC[0005] pflags=[0000] status=VALD load=0
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6bb06a6c 697c69f0 I/P/A/-/- 0 NONE 00
8 697c6b5c 697c67f0 I/P/A/-/- 0 NONE 00
9 697c6cc0 69768be0 I/-/A/-/- 0 NONE 00
----------------------------------------
SO: 69D621EC, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d621ec handle=6bb03fbc mode=N
call pin=00000000 session pin=00000000 hpc=0000 hlc=0000
htl=69D6223C[69D49FFC,69D49FFC] htb=69D49FFC ssga=69D49EB0
user=6bd67898 session=6bd607e8 count=0 flags=LRU/[4000] savepoint=0x733
LIBRARY OBJECT HANDLE: handle=6bb03fbc mutex=6BB04070(0)
name=SYS.USER$
hash=6d8063e933741c7b437132a225321413 timestamp=02-07-2006 22:10:16
namespace=TABL flags=PKP/KGHP/TIM/KEP/SML/BSO/[02900002]
kkkk-dddd-llll=0101-0301-0309 lock=N pin=0 latch#=1 hpc=0022 hlc=0022
lwt=6BB04018[6BB04018,6BB04018] ltm=6BB04020[6BB04020,6BB04020]
pwt=6BB03FFC[6BB03FFC,6BB03FFC] ptm=6BB04004[6BB04004,6BB04004]
ref=6BB04038[6BB04038,6BB04038] lnd=6BB04044[6BB03890,6BB042E0]
LIBRARY OBJECT: object=697bfc54
type=TABL flags=EXS/LOC[0005] pflags=[0000] status=VALD load=0
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6bb03f4c 697bfd10 I/P/A/-/- 0 NONE 00
8 697bfe7c 697bfb10 I/P/A/-/- 0 NONE 00
9 697bff58 69765140 I/-/A/-/- 0 NONE 00
----------------------------------------
SO: 69D61AEC, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d61aec handle=6ba46028 mode=N
call pin=00000000 session pin=00000000 hpc=0000 hlc=0000
htl=69D61B3C[69D4A04C,69D4A04C] htb=69D4A04C ssga=69D49EB0
user=6bd67898 session=6bd607e8 count=0 flags=LRU/[4000] savepoint=0x733
LIBRARY OBJECT HANDLE: handle=6ba46028 mutex=6BA460DC(0)
name=SYS.TRIGGER$
hash=6cfcf49191918618b4cc694e736acc1d timestamp=02-07-2006 22:10:19
namespace=TABL flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0101-0101 lock=N pin=0 latch#=1 hpc=0006 hlc=0006
lwt=6BA46084[6BA46084,6BA46084] ltm=6BA4608C[6BA4608C,6BA4608C]
pwt=6BA46068[6BA46068,6BA46068] ptm=6BA46070[6BA46070,6BA46070]
ref=6BA460A4[6BA460A4,6BA460A4] lnd=6BA460B0[6BB142AC,6BA463AC]
LIBRARY OBJECT: object=6961eed4
type=TABL flags=EXS/LOC[0005] pflags=[0000] status=VALD load=0
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6ba45fb8 6961ef6c I/-/A/-/- 0 NONE 00
8 6961f0fc 6961ed90 I/-/A/-/- 0 NONE 00
----------------------------------------
SO: 69D60FFC, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d60ffc handle=6bac86ac mode=N
call pin=00000000 session pin=69D4D284 hpc=0000 hlc=0000
htl=69D6104C[69D4C2AC,69D4A3A4] htb=69D4A3A4 ssga=69D49EB0
user=6bd67898 session=6bd607e8 count=1 flags=[0000] savepoint=0x0
LIBRARY OBJECT HANDLE: handle=6bac86ac mutex=6BAC8760(0)
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch#=1 hpc=0028 hlc=0028
lwt=6BAC8708[6BAC8708,6BAC8708] ltm=6BAC8710[6BAC8710,6BAC8710]
pwt=6BAC86EC[6BAC86EC,6BAC86EC] ptm=6BAC86F4[6BAC86F4,6BAC86F4]
ref=6BAC8728[6971CE7C,6971CE7C] lnd=6BAC8734[6BAC8734,6BAC8734]
LIBRARY OBJECT: object=6971da9c
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
DEPENDENCIES: count=1 size=16
READ ONLY DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6bac863c 6971dbec I/P/A/-/- 0 NONE 00
6 6971cbf0 6914c92c I/-/A/-/- 0 NONE 00
----------------------------------------
SO: 69D4C25C, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d4c25c handle=6bac87f0 mode=N
call pin=00000000 session pin=00000000 hpc=0000 hlc=0000
htl=69D4C2AC[69D630AC,69D6104C] htb=69D4A3A4 ssga=69D49EB0
user=6bd67898 session=6bd607e8 count=1 flags=[0000] savepoint=0x726
LIBRARY OBJECT HANDLE: handle=6bac87f0 mutex=6BAC88A4(1)
name=select grantee#,privilege#,nvl(col#,0),max(mod(nvl(option$,0),2))from objauth$ where obj#=:1 group by grantee#,privilege#,nvl(col#,0) order by grantee#
hash=26947ac91d45c1242b247fc5f6b6f088 timestamp=10-14-2007 12:23:45
namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=1 hpc=0028 hlc=0028
lwt=6BAC884C[6BAC884C,6BAC884C] ltm=6BAC8854[6BAC8854,6BAC8854]
pwt=6BAC8830[6BAC8830,6BAC8830] ptm=6BAC8838[6BAC8838,6BAC8838]
ref=6BAC886C[6BAC886C,6BAC886C] lnd=6BAC8878[6BAC7354,6BAD44D0]
LIBRARY OBJECT: object=6971d23c
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
CHILDREN: size=16
child# table reference handle
------ -------- --------- --------
0 6971d1c8 6971ce7c 6bac86ac
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6bac8780 6971d2d4 I/P/A/-/- 0 NONE 00
----------------------------------------
SO: 69D023E0, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d023e0 handle=6bac8fd4 mode=N
call pin=00000000 session pin=69D4D22C hpc=0000 hlc=0000
htl=69D02430[69D612EC,69D4A39C] htb=69D4A39C ssga=69D49EB0
user=6bd67898 session=6bd607e8 count=1 flags=[0000] savepoint=0x0
LIBRARY OBJECT HANDLE: handle=6bac8fd4 mutex=6BAC9088(0)
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch#=1 hpc=0028 hlc=0028
lwt=6BAC9030[6BAC9030,6BAC9030] ltm=6BAC9038[6BAC9038,6BAC9038]
pwt=6BAC9014[6BAC9014,6BAC9014] ptm=6BAC901C[6BAC901C,6BAC901C]
ref=6BAC9050[6971E36C,6971E36C] lnd=6BAC905C[6BAC905C,6BAC905C]
LIBRARY OBJECT: object=6977f444
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
DEPENDENCIES: count=1 size=16
READ ONLY DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6bac8f64 6977f594 I/P/A/-/- 0 NONE 00
6 6971e0e0 693c9bb4 I/-/A/-/- 0 NONE 00
----------------------------------------
SO: 69D6129C, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d6129c handle=6bac9118 mode=N
call pin=00000000 session pin=00000000 hpc=0000 hlc=0000
htl=69D612EC[69D4A39C,69D02430] htb=69D4A39C ssga=69D49EB0
user=6bd67898 session=6bd607e8 count=1 flags=[0000] savepoint=0x719
LIBRARY OBJECT HANDLE: handle=6bac9118 mutex=6BAC91CC(1)
name=select col#, grantee#, privilege#,max(mod(nvl(option$,0),2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#
hash=d751142c3b7971bd655864a445f58a87 timestamp=10-14-2007 12:23:45
namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=1 hpc=0028 hlc=0028
lwt=6BAC9174[6BAC9174,6BAC9174] ltm=6BAC917C[6BAC917C,6BAC917C]
pwt=6BAC9158[6BAC9158,6BAC9158] ptm=6BAC9160[6BAC9160,6BAC9160]
ref=6BAC9194[6BAC9194,6BAC9194] lnd=6BAC91A0[6BAD44D0,6BAC97C0]
LIBRARY OBJECT: object=6971e72c
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
CHILDREN: size=16
child# table reference handle
------ -------- --------- --------
0 6971e6b8 6971e36c 6bac8fd4
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6bac90a8 6971e7c4 I/P/A/-/- 0 NONE 00
----------------------------------------
SO: 69D60C7C, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d60c7c handle=6baebd88 mode=N
call pin=00000000 session pin=69D4D1D4 hpc=0000 hlc=0000
htl=69D60CCC[69D22EB0,69D4A354] htb=69D4A354 ssga=69D49EB0
user=6bd67898 session=6bd607e8 count=1 flags=[0000] savepoint=0x0
LIBRARY OBJECT HANDLE: handle=6baebd88 mutex=6BAEBE3C(0)
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch#=1 hpc=002a hlc=002a
lwt=6BAEBDE4[6BAEBDE4,6BAEBDE4] ltm=6BAEBDEC[6BAEBDEC,6BAEBDEC]
pwt=6BAEBDC8[6BAEBDC8,6BAEBDC8] ptm=6BAEBDD0[6BAEBDD0,6BAEBDD0]
ref=6BAEBE04[69775164,69775164] lnd=6BAEBE10[6BAEBE10,6BAEBE10]
LIBRARY OBJECT: object=697d6044
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
DEPENDENCIES: count=1 size=16
READ ONLY DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6baebd18 697d6194 I/P/A/-/- 0 NONE 00
6 69774ed8 693fbe58 I/-/A/-/- 0 NONE 00
----------------------------------------
SO: 69D22E60, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d22e60 handle=6baebecc mode=N
call pin=00000000 session pin=00000000 hpc=0000 hlc=0000
htl=69D22EB0[69D4A354,69D60CCC] htb=69D4A354 ssga=69D49EB0
user=6bd67898 session=6bd607e8 count=1 flags=[0000] savepoint=0x708
LIBRARY OBJECT HANDLE: handle=6baebecc mutex=6BAEBF80(1)
name=select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj#,o.flags from obj$ o where o.obj#=:1
hash=ae93e4a5100360375a3ff87632f4667e timestamp=10-14-2007 12:23:42
namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=1 hpc=002a hlc=002a
lwt=6BAEBF28[6BAEBF28,6BAEBF28] ltm=6BAEBF30[6BAEBF30,6BAEBF30]
pwt=6BAEBF0C[6BAEBF0C,6BAEBF0C] ptm=6BAEBF14[6BAEBF14,6BAEBF14]
ref=6BAEBF48[6BAEBF48,6BAEBF48] lnd=6BAEBF54[6BAE9D24,6BAEC530]
LIBRARY OBJECT: object=69775524
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
CHILDREN: size=16
child# table reference handle
------ -------- --------- --------
0 697754b0 69775164 6baebd88
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6baebe5c 697755bc I/P/A/-/- 0 NONE 00
----------------------------------------
SO: 69D6256C, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d6256c handle=6bace290 mode=N
call pin=00000000 session pin=00000000 hpc=0000 hlc=0000
htl=69D625BC[69D61EBC,69D4A67C] htb=69D4A67C ssga=69D49EB0
user=6bd67898 session=6bd607e8 count=1 flags=[0000] savepoint=0x0
LIBRARY OBJECT HANDLE: handle=6bace290 mutex=6BACE344(0)
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch#=1 hpc=001c hlc=001c
lwt=6BACE2EC[6BACE2EC,6BACE2EC] ltm=6BACE2F4[6BACE2F4,6BACE2F4]
pwt=6BACE2D0[6BACE2D0,6BACE2D0] ptm=6BACE2D8[6BACE2D8,6BACE2D8]
ref=6BACE30C[6972D414,6972D414] lnd=6BACE318[6BACE318,6BACE318]
LIBRARY OBJECT: object=697009cc
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
DEPENDENCIES: count=1 size=16
READ ONLY DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6baa9d2c 69700b1c I/P/A/-/- 0 NONE 00
6 69700380 691347f4 I/-/A/-/- 0 NONE 00
----------------------------------------
SO: 69D61E6C, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d61e6c handle=6bace3d4 mode=N
call pin=00000000 session pin=00000000 hpc=0000 hlc=0000
htl=69D61EBC[69D6119C,69D625BC] htb=69D4A67C ssga=69D49EB0
user=6bd67898 session=6bd607e8 count=1 flags=[0000] savepoint=0x6ee
LIBRARY OBJECT HANDLE: handle=6bace3d4 mutex=6BACE488(1)
name=select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts,NVL(lists,65535),NVL(groups,65535),cachehint,hwmincr, NVL(spare1,0),NVL(scanhint,0) from seg$ where ts#=:1 and file#=:2 and block#=:3
hash=b6c0fcd2c2b927772f4cd082ac305ce3 timestamp=10-14-2007 12:23:44
namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=1 hpc=001c hlc=001c
lwt=6BACE430[6BACE430,6BACE430] ltm=6BACE438[6BACE438,6BACE438]
pwt=6BACE414[6BACE414,6BACE414] ptm=6BACE41C[6BACE41C,6BACE41C]
ref=6BACE450[6BACE450,6BACE450] lnd=6BACE45C[6BACD730,6BAD9360]
LIBRARY OBJECT: object=6972d7d4
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
CHILDREN: size=16
child# table reference handle
------ -------- --------- --------
0 6972d760 6972d414 6bace290
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6bace364 6972d86c I/P/A/-/- 0 NONE 00
----------------------------------------
SO: 69D66EEC, type: 54, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=69d66eec handle=6b914ab4 mode=S lock=0
user=6bd67898 session=6bd67898 count=1 mask=0041 savepoint=0x6eb flags=[04]
----------------------------------------
SO: 69D6106C, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d6106c handle=6b914ab4 mode=N
call pin=00000000 session pin=00000000 hpc=0000 hlc=0000
htl=69D610BC[69D6112C,69D4A0DC] htb=69D4A0DC ssga=69D49EB0
user=6bd67898 session=6bd67898 count=1 flags=[0000] savepoint=0x0
LIBRARY OBJECT HANDLE: handle=6b914ab4 mutex=6B914B68(0)
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=S latch#=1 hpc=0004 hlc=0004
lwt=6B914B10[6B914B10,6B914B10] ltm=6B914B18[6B914B18,6B914B18]
pwt=6B914AF4[6B914AF4,6B914AF4] ptm=6B914AFC[6B914AFC,6B914AFC]
ref=6B914B30[68BF3374,68BF3374] lnd=6B914B3C[6B914B3C,6B914B3C]
LIBRARY OBJECT: object=68bf2ed4
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
DEPENDENCIES: count=3 size=16
READ ONLY DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6b914a44 68bf3024 I/P/A/-/- 0 NONE 00
6 68bf28c0 68e44aac I/P/A/-/- 2 NONE 00
----------------------------------------
SO: 69D610DC, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d610dc handle=6b914bf8 mode=N
call pin=00000000 session pin=00000000 hpc=0000 hlc=0000
htl=69D6112C[69D4A0DC,69D610BC] htb=69D4A0DC ssga=69D49EB0
user=6bd67898 session=6bd67898 count=1 flags=[0000] savepoint=0x6ea
LIBRARY OBJECT HANDLE: handle=6b914bf8 mutex=6B914CAC(1)
name=delete from CHILD_GROUP
hash=64cb1e4963593ff7ab81cdd0be006e2f timestamp=10-14-2007 12:27:58
namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/SML/KST/DBN/MTX/[120100d4]
kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=1 hpc=0004 hlc=0004
lwt=6B914C54[6B914C54,6B914C54] ltm=6B914C5C[6B914C5C,6B914C5C]
pwt=6B914C38[6B914C38,6B914C38] ptm=6B914C40[6B914C40,6B914C40]
ref=6B914C74[6B914C74,6B914C74] lnd=6B914C80[6B913F18,6B915F80]
LIBRARY OBJECT: object=68bf3734
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
CHILDREN: size=16
child# table reference handle
------ -------- --------- --------
0 68bf36c0 68bf3374 6b914ab4
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6b914b88 68bf37cc I/P/A/-/- 0 NONE 00
----------------------------------------
SO: 6ADB3AA4, type: 40, owner: 6BD67898, flag: INIT/-/-/0x00
(trans) flg = 0x01, flg2 = 0x14000, prx = 0x0, ros = 2147483647 bsn = 0x6e6 spn = 0x769
efd = 4
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)
cr opc: 0x0 spc: 0 uba: 0x00000000.0000.00
(enqueue) <no resource>
res: 0, prv: 0, own: 0, sess: 0
xga: 0x0, heap: UGA
Trans IMU st: 1 Pool index 1, Redo pool 0x6ae949f8, Undo pool 0x6ae949c0
Redo pool range [0x6adf08ac 0x6adf08ac 0x6adffeac]
Undo pool range [0x6ae94c00 0x6ae94c34 0x6aea4600]
Redo small pool range [0x0 0x0 0x0]
Undo small pool range [0x0 0x0 0x0]
Pmd 0x6ae93d50 opc: 1 bkopc: 0, recstate 0
txnvalid 0 chgvalid 0 cvsvalid 0
IMU Redo pool sz 62976, usage 0
IMU Undo pool sz 64000, usage 52
IMU changes: 0 applied chgs: 0 Redosiz 0, Flush reason 11
Redo Private strand index = 2
Strand index 2 Strand state 1 Available bufs 123
Current IMU pool 1 First buf 0x6adf0858 Strand size 66560
-------------------------------------------------------
IMU redo block change list
------------------------------------------------------
----------------------------------------
SO: 6AD97D9C, type: 36, owner: 6ADB3AA4, flag: INIT/-/-/0x00
DML LOCK: tab=31450 flg=11 chi=0
his[0]: mod=2 spn=1766
(enqueue) TM-00007ADA-00000000 DID: 0001-0014-00000004
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 flag: 0x6
res: 6be15a90, mode: SS, prv: 6be15a98, own: 6bd67898, sess: 6bd67898, proc: 6bd35d34
----------------------------------------
SO: 6AD97CD8, type: 36, owner: 6ADB3AA4, flag: INIT/-/-/0x00
DML LOCK: tab=31448 flg=11 chi=0
his[0]: mod=2 spn=1766
(enqueue) TM-00007AD8-00000000 DID: 0001-0014-00000004
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 flag: 0x6
res: 6be15988, mode: SS, prv: 6be15990, own: 6bd67898, sess: 6bd67898, proc: 6bd35d34
----------------------------------------
SO: 6AD97C14, type: 36, owner: 6ADB3AA4, flag: INIT/-/-/0x00
DML LOCK: tab=31446 flg=11 chi=0
his[0]: mod=3 spn=1766
(enqueue) TM-00007AD6-00000000 DID: 0001-0014-00000004
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 flag: 0x6
res: 6be158d8, mode: SX, req: SSX, prv: 6be158f0, own: 6bd67898, sess: 6bd67898, proc: 6bd35d34
----------------------------------------
SO: 69D611BC, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d611bc handle=6b94fc44 mode=N
call pin=00000000 session pin=00000000 hpc=0000 hlc=0000
htl=69D6120C[69D4A654,69D4A654] htb=69D4A654 ssga=69D49EB0
user=6bd67898 session=6bd67898 count=0 flags=LRU/[4000] savepoint=0x6d9
LIBRARY OBJECT HANDLE: handle=6b94fc44 mutex=6B94FCF8(0)
name=TESTUSER1.DUAL
hash=699488e46365a55df335f42b2f2bccde timestamp=NULL
namespace=TABL flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch#=1 hpc=0006 hlc=0006
lwt=6B94FCA0[6B94FCA0,6B94FCA0] ltm=6B94FCA8[6B94FCA8,6B94FCA8]
pwt=6B94FC84[6B94FC84,6B94FC84] ptm=6B94FC8C[6B94FC8C,6B94FC8C]
ref=6B94FCC0[6B94FCC0,6B94FCC0] lnd=6B94FCCC[6B94F0B4,6B94FFC8]
LIBRARY OBJECT: object=694b8544
flags=NEX[0002] pflags=[0000] status=VALD load=0
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6b94fbd4 694b85dc I/-/A/-/- 0 NONE 00
----------------------------------------
SO: 69D624FC, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d624fc handle=6b94f400 mode=N
call pin=00000000 session pin=00000000 hpc=0000 hlc=0000
htl=69D6254C[69D4A3DC,69D4A3DC] htb=69D4A3DC ssga=69D49EB0
user=6bd67898 session=6bd67898 count=0 flags=LRU/[4000] savepoint=0x6d9
LIBRARY OBJECT HANDLE: handle=6b94f400 mutex=6B94F4B4(0)
name=PUBLIC.DUAL
hash=320197261c9c8f420d2af96104c58c8f timestamp=02-07-2006 22:10:24
namespace=TABL flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch#=1 hpc=0006 hlc=0006
lwt=6B94F45C[6B94F45C,6B94F45C] ltm=6B94F464[6B94F464,6B94F464]
pwt=6B94F440[6B94F440,6B94F440] ptm=6B94F448[6B94F448,6B94F448]
ref=6B94F47C[6B94F47C,6B94F47C] lnd=6B94F488[6B94D18C,6B94D488]
LIBRARY OBJECT: object=694b4ed4
type=SYNM flags=EXS/LOC[0005] pflags=[0000] status=VALD load=0
DEPENDENCIES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6b94f390 694b4f6c I/-/A/-/- 0 NONE 00
----------------------------------------
SO: 69D6114C, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d6114c handle=6baaa134 mode=N
call pin=00000000 session pin=00000000 hpc=0000 hlc=0000
htl=69D6119C[69D4A67C,69D61EBC] htb=69D4A67C ssga=69D49EB0
user=6bd67898 session=6bd67898 count=0 flags=LRU/[4000] savepoint=0x6d9
LIBRARY OBJECT HANDLE: handle=6baaa134 mutex=6BAAA1E8(0)
name=SYS.DUAL
hash=608f3914e8f4f4eb2ce8093ef467d0e3 timestamp=02-07-2006 22:10:24
namespace=TABL flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0301-0301 lock=N pin=0 latch#=1 hpc=000c hlc=000c
lwt=6BAAA190[6BAAA190,6BAAA190] ltm=6BAAA198[6BAAA198,6BAAA198]
pwt=6BAAA174[6BAAA174,6BAAA174] ptm=6BAAA17C[6BAAA17C,6BAAA17C]
ref=6BAAA1B0[6BAAA1B0,6BAAA1B0] lnd=6BAAA1BC[6BAAAA6C,6BAAA4B8]
LIBRARY OBJECT: object=69702b4c
type=TABL flags=EXS/LOC[0005] pflags=[0000] status=VALD load=0
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6baaa0c4 69702be4 I/-/A/-/- 0 NONE 00
8 69702d74 69702a08 I/-/A/-/- 0 NONE 00
9 69702de8 694b0b00 I/-/A/-/- 0 NONE 00
----------------------------------------
SO: 69D60C0C, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d60c0c handle=6ba2c9fc mode=N
call pin=69D39200 session pin=00000000 hpc=0000 hlc=0000
htl=69D60C5C[69D4A134,69D4A134] htb=69D4A134 ssga=69D49EB0
user=6bd67898 session=6bd67898 count=1 flags=[0000] savepoint=0x6d4
LIBRARY OBJECT HANDLE: handle=6ba2c9fc mutex=6BA2CAB0(0)
name=SYS.DBMS_APPLICATION_INFO
hash=de1dc0e557f1b44f8f8f6a1e12cdcf3a timestamp=02-07-2006 22:14:50
namespace=BODY flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0011-0011 lock=N pin=0 latch#=1 hpc=0006 hlc=0006
lwt=6BA2CA58[6BA2CA58,6BA2CA58] ltm=6BA2CA60[6BA2CA60,6BA2CA60]
pwt=6BA2CA3C[6BA2CA3C,6BA2CA3C] ptm=6BA2CA44[6BA2CA44,6BA2CA44]
ref=6BA2CA78[6BA2CA78,6BA2CA78] lnd=6BA2CA84[6BA2CA84,6BA2CA84]
LIBRARY OBJECT: object=695fcb64
type=PKBD flags=EXS/LOC[0005] pflags=NST/SWR[0009] status=VALD load=0
DEPENDENCIES: count=2 size=16
ACCESSES: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6ba2c98c 695fcc20 I/-/A/-/- 0 NONE 00
4 695fcd64 692f80b4 I/-/A/-/- 0 NONE 00
----------------------------------------
SO: 69D5499C, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d5499c handle=6bae2a80 mode=N
call pin=00000000 session pin=00000000 hpc=0000 hlc=0000
htl=69D549EC[69D4A724,69D4A724] htb=69D4A724 ssga=69D49EB0
user=6bd67898 session=6bd67898 count=0 flags=LRU/[4000] savepoint=0x584
LIBRARY OBJECT HANDLE: handle=6bae2a80 mutex=6BAE2B34(0)
name=SYS.DBMS_STANDARD
hash=d541fdab99f67fcc4f0f21aa62697af8 timestamp=02-07-2006 22:11:04
namespace=TABL flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0005-0005 lock=N pin=0 latch#=1 hpc=0016 hlc=0016
lwt=6BAE2ADC[6BAE2ADC,6BAE2ADC] ltm=6BAE2AE4[6BAE2AE4,6BAE2AE4]
pwt=6BAE2AC0[6BAE2AC0,6BAE2AC0] ptm=6BAE2AC8[6BAE2AC8,6BAE2AC8]
ref=6BAE2AFC[6BAE2AFC,6BAE2AFC] lnd=6BAE2B08[6BA7F5EC,6BA801CC]
LIBRARY OBJECT: object=6975ed94
type=PCKG flags=EXS/LOC[0005] pflags=NST[0001] status=VALD load=0
DEPENDENCIES: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6bae2a10 6975ee50 I/-/A/-/- 0 NONE 00
2 6975ef40 6916dc0c I/-/A/-/- 0 NONE 00
----------------------------------------
SO: 69D54CAC, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d54cac handle=6ba2e45c mode=N
call pin=69D38FF0 session pin=00000000 hpc=0000 hlc=0000
htl=69D54CFC[69D4A3EC,69D4A3EC] htb=69D4A3EC ssga=69D49EB0
user=6bd67898 session=6bd67898 count=1 flags=[0000] savepoint=0x6d4
LIBRARY OBJECT HANDLE: handle=6ba2e45c mutex=6BA2E510(0)
name=SYS.DBMS_APPLICATION_INFO
hash=9613ad6560e3f11cb71fe8148bee5691 timestamp=02-07-2006 22:14:37
namespace=TABL flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0015-0015 lock=N pin=0 latch#=1 hpc=0004 hlc=0004
lwt=6BA2E4B8[6BA2E4B8,6BA2E4B8] ltm=6BA2E4C0[6BA2E4C0,6BA2E4C0]
pwt=6BA2E49C[6BA2E49C,6BA2E49C] ptm=6BA2E4A4[6BA2E4A4,6BA2E4A4]
ref=6BA2E4D8[6BA2E4D8,6BA2E4D8] lnd=6BA2E4E4[6BA2E38C,6BA2F5E0]
LIBRARY OBJECT: object=695fcf94
type=PCKG flags=EXS/LOC[0005] pflags=[0000] status=VALD load=0
DEPENDENCIES: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6ba2cd60 695fd050 I/-/A/-/- 0 NONE 00
2 695fd1b4 68e4dccc I/-/A/-/- 0 NONE 00
4 695fd140 692f90b4 I/-/A/-/- 0 NONE 00
----------------------------------------
SO: 69D61F4C, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d61f4c handle=6baa05c8 mode=N
call pin=00000000 session pin=69D4D2DC hpc=0000 hlc=0000
htl=69D61F9C[69D631FC,69D4A47C] htb=69D4A47C ssga=69D49EB0
user=6bd67898 session=6bd665d0 count=1 flags=[0000] savepoint=0x0
LIBRARY OBJECT HANDLE: handle=6baa05c8 mutex=6BAA067C(0)
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch#=1 hpc=0002 hlc=0002
lwt=6BAA0624[6BAA0624,6BAA0624] ltm=6BAA062C[6BAA062C,6BAA062C]
pwt=6BAA0608[6BAA0608,6BAA0608] ptm=6BAA0610[6BAA0610,6BAA0610]
ref=6BAA0644[696E41CC,696E41CC] lnd=6BAA0650[6BAA0650,6BAA0650]
LIBRARY OBJECT: object=696e3d2c
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
DEPENDENCIES: count=1 size=16
READ ONLY DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6baa0558 696e3e7c I/P/A/-/- 0 NONE 00
6 696e36e0 69117688 I/-/A/-/- 0 NONE 00
----------------------------------------
SO: 69D631AC, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d631ac handle=6baa070c mode=N
call pin=00000000 session pin=00000000 hpc=0000 hlc=0000
htl=69D631FC[69D4A47C,69D61F9C] htb=69D4A47C ssga=69D49EB0
user=6bd67898 session=6bd665d0 count=1 flags=[0000] savepoint=0x641
LIBRARY OBJECT HANDLE: handle=6baa070c mutex=6BAA07C0(1)
name=select privilege#,nvl(col#,0),max(mod(nvl(option$,0),2))from objauth$ where obj#=:1 and grantee#=:2 group by privilege#,nvl(col#,0)
hash=6760fb1da0133f65379f1dcc52d37da3 timestamp=10-14-2007 12:23:48
namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=1 hpc=0002 hlc=0002
lwt=6BAA0768[6BAA0768,6BAA0768] ltm=6BAA0770[6BAA0770,6BAA0770]
pwt=6BAA074C[6BAA074C,6BAA074C] ptm=6BAA0754[6BAA0754,6BAA0754]
ref=6BAA0788[6BAA0788,6BAA0788] lnd=6BAA0794[6BA9FC7C,6BAA0E98]
LIBRARY OBJECT: object=696e458c
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
CHILDREN: size=16
child# table reference handle
------ -------- --------- --------
0 696e4518 696e41cc 6baa05c8
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6baa069c 696e4624 I/P/A/-/- 0 NONE 00
----------------------------------------
SO: 69D6248C, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d6248c handle=6bae439c mode=N
call pin=00000000 session pin=00000000 hpc=0000 hlc=0000
htl=69D624DC[69D4C4DC,69D4A174] htb=69D4A174 ssga=69D49EB0
user=6bd67898 session=6bd665d0 count=1 flags=[0000] savepoint=0x0
LIBRARY OBJECT HANDLE: handle=6bae439c mutex=6BAE4450(0)
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch#=1 hpc=0008 hlc=0008
lwt=6BAE43F8[6BAE43F8,6BAE43F8] ltm=6BAE4400[6BAE4400,6BAE4400]
pwt=6BAE43DC[6BAE43DC,6BAE43DC] ptm=6BAE43E4[6BAE43E4,6BAE43E4]
ref=6BAE4418[69763104,69763104] lnd=6BAE4424[6BAE4424,6BAE4424]
LIBRARY OBJECT: object=696a290c
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
DEPENDENCIES: count=1 size=16
READ ONLY DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6ba89954 696a2a5c I/P/A/-/- 0 NONE 00
6 696a22c0 690b037c I/-/A/-/- 0 NONE 00
----------------------------------------
SO: 69D4C48C, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d4c48c handle=6bae44e0 mode=N
call pin=00000000 session pin=00000000 hpc=0000 hlc=0000
htl=69D4C4DC[69D4A174,69D624DC] htb=69D4A174 ssga=69D49EB0
user=6bd67898 session=6bd665d0 count=1 flags=[0000] savepoint=0x5fc
LIBRARY OBJECT HANDLE: handle=6bae44e0 mutex=6BAE4594(1)
name=select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#,length,piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#
hash=72be447c7285373334cc98ea6461ad42 timestamp=10-14-2007 12:23:43
namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=1 hpc=0008 hlc=0008
lwt=6BAE453C[6BAE453C,6BAE453C] ltm=6BAE4544[6BAE4544,6BAE4544]
pwt=6BAE4520[6BAE4520,6BAE4520] ptm=6BAE4528[6BAE4528,6BAE4528]
ref=6BAE455C[6BAE455C,6BAE455C] lnd=6BAE4568[6BAE3958,6BAE5178]
LIBRARY OBJECT: object=697634c4
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
CHILDREN: size=16
child# table reference handle
------ -------- --------- --------
0 69763450 69763104 6bae439c
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6bae4470 6976355c I/P/A/-/- 0 NONE 00
----------------------------------------
SO: 69D01880, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d01880 handle=6bae4fac mode=N
call pin=00000000 session pin=69D39048 hpc=0000 hlc=0000
htl=69D018D0[69D60E1C,69D4A064] htb=69D4A064 ssga=69D49EB0
user=6bd67898 session=6bd665d0 count=1 flags=[0000] savepoint=0x0
LIBRARY OBJECT HANDLE: handle=6bae4fac mutex=6BAE5060(0)
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch#=1 hpc=0008 hlc=0008
lwt=6BAE5008[6BAE5008,6BAE5008] ltm=6BAE5010[6BAE5010,6BAE5010]
pwt=6BAE4FEC[6BAE4FEC,6BAE4FEC] ptm=6BAE4FF4[6BAE4FF4,6BAE4FF4]
ref=6BAE5028[69765284,69765284] lnd=6BAE5034[6BAE5034,6BAE5034]
LIBRARY OBJECT: object=696a359c
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
DEPENDENCIES: count=1 size=16
READ ONLY DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6ba899b4 696a36ec I/P/A/-/- 0 NONE 00
6 696a2f50 690b137c I/-/A/-/- 0 NONE 00
----------------------------------------
SO: 69D60DCC, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d60dcc handle=6bae50f0 mode=N
call pin=00000000 session pin=00000000 hpc=0000 hlc=0000
htl=69D60E1C[69D4A064,69D018D0] htb=69D4A064 ssga=69D49EB0
user=6bd67898 session=6bd665d0 count=1 flags=[0000] savepoint=0x5f0
LIBRARY OBJECT HANDLE: handle=6bae50f0 mutex=6BAE51A4(1)
name=select /*+ index(idl_char$ i_idl_char1) +*/ piece#,length,piece from idl_char$ where obj#=:1 and part=:2 and version=:3 order by piece#
hash=b08a18f166b16334c32b96c14278d620 timestamp=10-14-2007 12:23:43
namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=1 hpc=0008 hlc=0008
lwt=6BAE514C[6BAE514C,6BAE514C] ltm=6BAE5154[6BAE5154,6BAE5154]
pwt=6BAE5130[6BAE5130,6BAE5130] ptm=6BAE5138[6BAE5138,6BAE5138]
ref=6BAE516C[6BAE516C,6BAE516C] lnd=6BAE5178[6BAE4568,6BAE5D88]
LIBRARY OBJECT: object=69765644
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
CHILDREN: size=16
child# table reference handle
------ -------- --------- --------
0 697655d0 69765284 6bae4fac
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6bae5080 697656dc I/P/A/-/- 0 NONE 00
----------------------------------------
SO: 69D60F1C, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d60f1c handle=6bae5bbc mode=N
call pin=00000000 session pin=69D02CB0 hpc=0000 hlc=0000
htl=69D60F6C[69D6078C,69D4A034] htb=69D4A034 ssga=69D49EB0
user=6bd67898 session=6bd665d0 count=1 flags=[0000] savepoint=0x0
LIBRARY OBJECT HANDLE: handle=6bae5bbc mutex=6BAE5C70(0)
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch#=1 hpc=0008 hlc=0008
lwt=6BAE5C18[6BAE5C18,6BAE5C18] ltm=6BAE5C20[6BAE5C20,6BAE5C20]
pwt=6BAE5BFC[6BAE5BFC,6BAE5BFC] ptm=6BAE5C04[6BAE5C04,6BAE5C04]
ref=6BAE5C38[69767404,69767404] lnd=6BAE5C44[6BAE5C44,6BAE5C44]
LIBRARY OBJECT: object=696a422c
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
DEPENDENCIES: count=1 size=16
READ ONLY DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6ba89a14 696a437c I/P/A/-/- 0 NONE 00
6 696a3be0 690b337c I/-/A/-/- 0 NONE 00
----------------------------------------
SO: 69D6073C, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d6073c handle=6bae5d00 mode=N
call pin=00000000 session pin=00000000 hpc=0000 hlc=0000
htl=69D6078C[69D4A034,69D60F6C] htb=69D4A034 ssga=69D49EB0
user=6bd67898 session=6bd665d0 count=1 flags=[0000] savepoint=0x5e4
LIBRARY OBJECT HANDLE: handle=6bae5d00 mutex=6BAE5DB4(1)
name=select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#,length,piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
hash=ee0939a6dd26084ecdd0a459fdf0611a timestamp=10-14-2007 12:23:43
namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=1 hpc=0008 hlc=0008
lwt=6BAE5D5C[6BAE5D5C,6BAE5D5C] ltm=6BAE5D64[6BAE5D64,6BAE5D64]
pwt=6BAE5D40[6BAE5D40,6BAE5D40] ptm=6BAE5D48[6BAE5D48,6BAE5D48]
ref=6BAE5D7C[6BAE5D7C,6BAE5D7C] lnd=6BAE5D88[6BAE5178,6BAE6998]
LIBRARY OBJECT: object=697677c4
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
CHILDREN: size=16
child# table reference handle
------ -------- --------- --------
0 69767750 69767404 6bae5bbc
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6bae5c90 6976785c I/P/A/-/- 0 NONE 00
----------------------------------------
SO: 69D02300, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d02300 handle=6bae67cc mode=N
call pin=00000000 session pin=69D38F40 hpc=0000 hlc=0000
htl=69D02350[69D4C07C,69D49F64] htb=69D49F64 ssga=69D49EB0
user=6bd67898 session=6bd665d0 count=1 flags=[0000] savepoint=0x0
LIBRARY OBJECT HANDLE: handle=6bae67cc mutex=6BAE6880(0)
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch#=1 hpc=0008 hlc=0008
lwt=6BAE6828[6BAE6828,6BAE6828] ltm=6BAE6830[6BAE6830,6BAE6830]
pwt=6BAE680C[6BAE680C,6BAE680C] ptm=6BAE6814[6BAE6814,6BAE6814]
ref=6BAE6848[69769584,69769584] lnd=6BAE6854[6BAE6854,6BAE6854]
LIBRARY OBJECT: object=696a4ebc
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
DEPENDENCIES: count=1 size=16
READ ONLY DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6ba89a74 696a500c I/P/A/-/- 0 NONE 00
6 696a4870 690bb3b0 I/-/A/-/- 0 NONE 00
----------------------------------------
SO: 69D4C02C, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d4c02c handle=6bae6910 mode=N
call pin=00000000 session pin=00000000 hpc=0000 hlc=0000
htl=69D4C07C[69D49F64,69D02350] htb=69D49F64 ssga=69D49EB0
user=6bd67898 session=6bd665d0 count=1 flags=[0000] savepoint=0x5d8
LIBRARY OBJECT HANDLE: handle=6bae6910 mutex=6BAE69C4(1)
name=select /*+ index(idl_sb4$ i_idl_sb41) +*/ piece#,length,piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece#
hash=1871529dbb6cd514f52629ec8acf2700 timestamp=10-14-2007 12:23:43
namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=1 hpc=0008 hlc=0008
lwt=6BAE696C[6BAE696C,6BAE696C] ltm=6BAE6974[6BAE6974,6BAE6974]
pwt=6BAE6950[6BAE6950,6BAE6950] ptm=6BAE6958[6BAE6958,6BAE6958]
ref=6BAE698C[6BAE698C,6BAE698C] lnd=6BAE6998[6BAE5D88,6BAE9668]
LIBRARY OBJECT: object=69769944
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
CHILDREN: size=16
child# table reference handle
------ -------- --------- --------
0 697698d0 69769584 6bae67cc
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6bae68a0 697699dc I/P/A/-/- 0 NONE 00
----------------------------------------
SO: 69D13708, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d13708 handle=6bae72ac mode=N
call pin=00000000 session pin=69D02DB8 hpc=0000 hlc=0000
htl=69D13758[69D0CC64,69D4A674] htb=69D4A674 ssga=69D49EB0
user=6bd67898 session=6bd665d0 count=1 flags=[0000] savepoint=0x0
LIBRARY OBJECT HANDLE: handle=6bae72ac mutex=6BAE7360(0)
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch#=1 hpc=0018 hlc=0018
lwt=6BAE7308[6BAE7308,6BAE7308] ltm=6BAE7310[6BAE7310,6BAE7310]
pwt=6BAE72EC[6BAE72EC,6BAE72EC] ptm=6BAE72F4[6BAE72F4,6BAE72F4]
ref=6BAE7328[6976B704,6976B704] lnd=6BAE7334[6BAE7334,6BAE7334]
LIBRARY OBJECT: object=696f300c
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
DEPENDENCIES: count=1 size=16
READ ONLY DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6baa4cbc 696f315c I/P/A/-/- 0 NONE 00
6 696f29c0 69113654 I/-/A/-/- 0 NONE 00
----------------------------------------
SO: 69D0CC14, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d0cc14 handle=6bae73f0 mode=N
call pin=00000000 session pin=00000000 hpc=0000 hlc=0000
htl=69D0CC64[69D4A674,69D13758] htb=69D4A674 ssga=69D49EB0
user=6bd67898 session=6bd665d0 count=1 flags=[0000] savepoint=0x5cc
LIBRARY OBJECT HANDLE: handle=6bae73f0 mutex=6BAE74A4(1)
name=select order#,columns,types from access$ where d_obj#=:1
hash=16ca272060087b658c73d55aee098ce2 timestamp=10-14-2007 12:23:43
namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/SML/KST/DBN/MTX/[120100d4]
kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=1 hpc=0018 hlc=0018
lwt=6BAE744C[6BAE744C,6BAE744C] ltm=6BAE7454[6BAE7454,6BAE7454]
pwt=6BAE7430[6BAE7430,6BAE7430] ptm=6BAE7438[6BAE7438,6BAE7438]
ref=6BAE746C[6BAE746C,6BAE746C] lnd=6BAE7478[6BAE9668,6BAE75D0]
LIBRARY OBJECT: object=6976bac4
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
CHILDREN: size=16
child# table reference handle
------ -------- --------- --------
0 6976ba50 6976b704 6bae72ac
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6bae7380 6976bb5c I/P/A/-/- 0 NONE 00
----------------------------------------
SO: 69D0D2A4, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d0d2a4 handle=6bae84b8 mode=N
call pin=00000000 session pin=69D4D38C hpc=0000 hlc=0000
htl=69D0D2F4[69D4C54C,69D4A34C] htb=69D4A34C ssga=69D49EB0
user=6bd67898 session=6bd665d0 count=1 flags=[0000] savepoint=0x0
LIBRARY OBJECT HANDLE: handle=6bae84b8 mutex=6BAE856C(0)
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch#=1 hpc=0018 hlc=0018
lwt=6BAE8514[6BAE8514,6BAE8514] ltm=6BAE851C[6BAE851C,6BAE851C]
pwt=6BAE84F8[6BAE84F8,6BAE84F8] ptm=6BAE8500[6BAE8500,6BAE8500]
ref=6BAE8534[6976ECE4,6976ECE4] lnd=6BAE8540[6BAE8540,6BAE8540]
LIBRARY OBJECT: object=696f55bc
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
DEPENDENCIES: count=2 size=16
READ ONLY DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=2 size=16
TRANSLATIONS: count=2 size=16
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6baa55c8 696f570c I/P/A/-/- 0 NONE 00
6 696f4f70 6912978c I/-/A/-/- 0 NONE 00
----------------------------------------
SO: 69D4C4FC, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d4c4fc handle=6bae85fc mode=N
call pin=00000000 session pin=00000000 hpc=0000 hlc=0000
htl=69D4C54C[69D4A34C,69D0D2F4] htb=69D4A34C ssga=69D49EB0
user=6bd67898 session=6bd665d0 count=1 flags=[0000] savepoint=0x5ba
LIBRARY OBJECT HANDLE: handle=6bae85fc mutex=6BAE86B0(1)
name=select owner#,name,namespace,remoteowner,linkname,p_timestamp,p_obj#, nvl(property,0),subname,d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
hash=9a0ac34a10fbc77acb3f6533a7a8987d timestamp=10-14-2007 12:23:42
namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=1 hpc=0018 hlc=0018
lwt=6BAE8658[6BAE8658,6BAE8658] ltm=6BAE8660[6BAE8660,6BAE8660]
pwt=6BAE863C[6BAE863C,6BAE863C] ptm=6BAE8644[6BAE8644,6BAE8644]
ref=6BAE8678[6BAE8678,6BAE8678] lnd=6BAE8684[6BAE75D0,6BAE9294]
LIBRARY OBJECT: object=6976f0a4
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
CHILDREN: size=16
child# table reference handle
------ -------- --------- --------
0 6976f030 6976ece4 6bae84b8
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6bae858c 6976f13c I/P/A/-/- 0 NONE 00
----------------------------------------
SO: 69D4C10C, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d4c10c handle=6b94eee8 mode=N
call pin=00000000 session pin=69D66F44 hpc=0000 hlc=0000
htl=69D4C15C[69D0C484,69D4A5B4] htb=69D4A5B4 ssga=69D49EB0
user=6bd67898 session=6bd665d0 count=1 flags=[0000] savepoint=0x0
LIBRARY OBJECT HANDLE: handle=6b94eee8 mutex=6B94EF9C(0)
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch#=1 hpc=000e hlc=000e
lwt=6B94EF44[6B94EF44,6B94EF44] ltm=6B94EF4C[6B94EF4C,6B94EF4C]
pwt=6B94EF28[6B94EF28,6B94EF28] ptm=6B94EF30[6B94EF30,6B94EF30]
ref=6B94EF64[694B46E4,694B46E4] lnd=6B94EF70[6B94EF70,6B94EF70]
LIBRARY OBJECT: object=694b4244
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
DEPENDENCIES: count=1 size=16
READ ONLY DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6b94ee78 694b4394 I/P/A/-/- 0 NONE 00
6 694b3bf8 68f06f1c I/-/A/-/- 0 NONE 00
----------------------------------------
SO: 69D0C434, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d0c434 handle=6b94f02c mode=N
call pin=00000000 session pin=00000000 hpc=0000 hlc=0000
htl=69D0C484[69D4A5B4,69D4C15C] htb=69D4A5B4 ssga=69D49EB0
user=6bd67898 session=6bd665d0 count=1 flags=[0000] savepoint=0x5ae
LIBRARY OBJECT HANDLE: handle=6b94f02c mutex=6B94F0E0(1)
name=select node,owner,name from syn$ where obj#=:1
hash=71bc999f612564c419c5a9ed500deaca timestamp=10-14-2007 12:24:05
namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/SML/KST/DBN/MTX/[120100d4]
kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=1 hpc=000e hlc=000e
lwt=6B94F088[6B94F088,6B94F088] ltm=6B94F090[6B94F090,6B94F090]
pwt=6B94F06C[6B94F06C,6B94F06C] ptm=6B94F074[6B94F074,6B94F074]
ref=6B94F0A8[6B94F0A8,6B94F0A8] lnd=6B94F0B4[6B94EDB8,6B94FCCC]
LIBRARY OBJECT: object=694b4aa4
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
CHILDREN: size=16
child# table reference handle
------ -------- --------- --------
0 694b4a30 694b46e4 6b94eee8
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6b94efbc 694b4b3c I/P/A/-/- 0 NONE 00
----------------------------------------
SO: 69D0BF64, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d0bf64 handle=6baedaf4 mode=N
call pin=00000000 session pin=69D4D17C hpc=0000 hlc=0000
htl=69D0BFB4[69D6127C,69D4A3E4] htb=69D4A3E4 ssga=69D49EB0
user=6bd67898 session=6bd665d0 count=1 flags=[0000] savepoint=0x0
LIBRARY OBJECT HANDLE: handle=6baedaf4 mutex=6BAEDBA8(0)
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch#=1 hpc=003c hlc=003c
lwt=6BAEDB50[6BAEDB50,6BAEDB50] ltm=6BAEDB58[6BAEDB58,6BAEDB58]
pwt=6BAEDB34[6BAEDB34,6BAEDB34] ptm=6BAEDB3C[6BAEDB3C,6BAEDB3C]
ref=6BAEDB70[6977CF04,6977CF04] lnd=6BAEDB7C[6BAEDB7C,6BAEDB7C]
LIBRARY OBJECT: object=697f56c4
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
DEPENDENCIES: count=1 size=16
READ ONLY DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6baeda84 697f5814 I/P/A/-/- 0 NONE 00
6 6977c848 693d8c1c I/-/A/-/- 0 NONE 00
----------------------------------------
SO: 69D6122C, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d6122c handle=6baedc38 mode=N
call pin=00000000 session pin=00000000 hpc=0000 hlc=0000
htl=69D6127C[69D4A3E4,69D0BFB4] htb=69D4A3E4 ssga=69D49EB0
user=6bd67898 session=6bd665d0 count=1 flags=[0000] savepoint=0x586
LIBRARY OBJECT HANDLE: handle=6baedc38 mutex=6BAEDCEC(1)
name=select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
hash=b26a259f381e87d302773791f5e84a90 timestamp=10-14-2007 12:23:42
namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=1 hpc=003c hlc=003c
lwt=6BAEDC94[6BAEDC94,6BAEDC94] ltm=6BAEDC9C[6BAEDC9C,6BAEDC9C]
pwt=6BAEDC78[6BAEDC78,6BAEDC78] ptm=6BAEDC80[6BAEDC80,6BAEDC80]
ref=6BAEDCB4[6BAEDCB4,6BAEDCB4] lnd=6BAEDCC0[6BAED6D0,6BAEE454]
LIBRARY OBJECT: object=6977d2c4
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
CHILDREN: size=16
child# table reference handle
------ -------- --------- --------
0 6977d250 6977cf04 6baedaf4
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6baedbc8 6977d35c I/P/A/-/- 0 NONE 00
----------------------------------------
SO: 69D54B5C, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d54b5c handle=6ba60368 mode=N
call pin=00000000 session pin=69D38E90 hpc=0000 hlc=0000
htl=69D54BAC[69D23000,69D7B008] htb=69D4A11C ssga=69D49EB0
user=6bd67898 session=6bd665d0 count=1 flags=[0000] savepoint=0x0
LIBRARY OBJECT HANDLE: handle=6ba60368 mutex=6BA6041C(0)
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch#=1 hpc=002e hlc=002e
lwt=6BA603C4[6BA603C4,6BA603C4] ltm=6BA603CC[6BA603CC,6BA603CC]
pwt=6BA603A8[6BA603A8,6BA603A8] ptm=6BA603B0[6BA603B0,6BA603B0]
ref=6BA603E4[6964A930,6964A930] lnd=6BA603F0[6BA603F0,6BA603F0]
LIBRARY OBJECT: object=6964a490
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
DEPENDENCIES: count=1 size=16
READ ONLY DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6ba602f8 6964a5e0 I/P/A/-/- 0 NONE 00
6 69649e44 693aaae4 I/-/A/-/- 0 NONE 00
----------------------------------------
SO: 69D22FB0, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d22fb0 handle=6ba604ac mode=N
call pin=00000000 session pin=00000000 hpc=0000 hlc=0000
htl=69D23000[69D4A11C,69D54BAC] htb=69D4A11C ssga=69D49EB0
user=6bd67898 session=6bd665d0 count=1 flags=[0000] savepoint=0x4cf
LIBRARY OBJECT HANDLE: handle=6ba604ac mutex=6BA60560(1)
name=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 timestamp=10-14-2007 12:23:52
namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=1 hpc=002e hlc=002e
lwt=6BA60508[6BA60508,6BA60508] ltm=6BA60510[6BA60510,6BA60510]
pwt=6BA604EC[6BA604EC,6BA604EC] ptm=6BA604F4[6BA604F4,6BA604F4]
ref=6BA60528[6BA60528,6BA60528] lnd=6BA60534[6BADAB20,6BAEE158]
LIBRARY OBJECT: object=6964acf0
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
CHILDREN: size=16
child# table reference handle
------ -------- --------- --------
0 6964ac7c 6964a930 6ba60368
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6ba6043c 6964ad88 I/P/A/-/- 0 NONE 00
----------------------------------------
SO: 69D630CC, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d630cc handle=6bac95f4 mode=N
call pin=00000000 session pin=69D4CA44 hpc=0000 hlc=0000
htl=69D6311C[69D54B3C,69D4A37C] htb=69D4A37C ssga=69D49EB0
user=6bd67898 session=6bd665d0 count=1 flags=[0000] savepoint=0x0
LIBRARY OBJECT HANDLE: handle=6bac95f4 mutex=6BAC96A8(0)
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch#=1 hpc=0010 hlc=0010
lwt=6BAC9650[6BAC9650,6BAC9650] ltm=6BAC9658[6BAC9658,6BAC9658]
pwt=6BAC9634[6BAC9634,6BAC9634] ptm=6BAC963C[6BAC963C,6BAC963C]
ref=6BAC9670[69722C40,69722C40] lnd=6BAC967C[6BAC967C,6BAC967C]
LIBRARY OBJECT: object=696e1f88
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
DEPENDENCIES: count=1 size=16
READ ONLY DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6baa0030 696e20d8 I/P/A/-/- 0 NONE 00
6 696e193c 69116688 I/-/A/-/- 0 NONE 00
----------------------------------------
SO: 69D54AEC, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d54aec handle=6bac9738 mode=N
call pin=00000000 session pin=00000000 hpc=0000 hlc=0000
htl=69D54B3C[69D4A37C,69D6311C] htb=69D4A37C ssga=69D49EB0
user=6bd67898 session=6bd665d0 count=1 flags=[0000] savepoint=0x4c0
LIBRARY OBJECT HANDLE: handle=6bac9738 mutex=6BAC97EC(1)
name=select intcol#,nvl(pos#,0),col#,nvl(spare1,0) from ccol$ where con#=:1
hash=2b7313745935366b51e14a17e5737183 timestamp=10-14-2007 12:23:45
namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=1 hpc=0010 hlc=0010
lwt=6BAC9794[6BAC9794,6BAC9794] ltm=6BAC979C[6BAC979C,6BAC979C]
pwt=6BAC9778[6BAC9778,6BAC9778] ptm=6BAC9780[6BAC9780,6BAC9780]
ref=6BAC97B4[6BAC97B4,6BAC97B4] lnd=6BAC97C0[6BAC91A0,6BAC9CB0]
LIBRARY OBJECT: object=69723000
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
CHILDREN: size=16
child# table reference handle
------ -------- --------- --------
0 69722f8c 69722c40 6bac95f4
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6bac96c8 69723098 I/P/A/-/- 0 NONE 00
----------------------------------------
SO: 69D62FEC, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d62fec handle=6bad5028 mode=N
call pin=00000000 session pin=69D027E0 hpc=0000 hlc=0000
htl=69D6303C[69D54C1C,69D4A4C4] htb=69D4A4C4 ssga=69D49EB0
user=6bd67898 session=6bd665d0 count=1 flags=[0000] savepoint=0x0
LIBRARY OBJECT HANDLE: handle=6bad5028 mutex=6BAD50DC(0)
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch#=1 hpc=0012 hlc=0012
lwt=6BAD5084[6BAD5084,6BAD5084] ltm=6BAD508C[6BAD508C,6BAD508C]
pwt=6BAD5068[6BAD5068,6BAD5068] ptm=6BAD5070[6BAD5070,6BAD5070]
ref=6BAD50A4[69738824,69738824] lnd=6BAD50B0[6BAD50B0,6BAD50B0]
LIBRARY OBJECT: object=69738384
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
DEPENDENCIES: count=1 size=16
READ ONLY DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6bad4fb8 697384d4 I/P/A/-/- 0 NONE 00
6 69737d38 693cdbb4 I/-/A/-/- 0 NONE 00
----------------------------------------
SO: 69D54BCC, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d54bcc handle=6bad516c mode=N
call pin=00000000 session pin=00000000 hpc=0000 hlc=0000
htl=69D54C1C[69D4A4C4,69D6303C] htb=69D4A4C4 ssga=69D49EB0
user=6bd67898 session=6bd665d0 count=1 flags=[0000] savepoint=0x47a
LIBRARY OBJECT HANDLE: handle=6bad516c mutex=6BAD5220(1)
name=select con#,type#,condlength,intcols,robj#,rcon#,match#,refact,nvl(enabled,0),rowid,cols,nvl(defer,0),mtime,nvl(spare1,0) from cdef$ where obj#=:1
hash=2c7d8d54a642c499a38f8bd87da474ac timestamp=10-14-2007 12:23:44
namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=1 hpc=0012 hlc=0012
lwt=6BAD51C8[6BAD51C8,6BAD51C8] ltm=6BAD51D0[6BAD51D0,6BAD51D0]
pwt=6BAD51AC[6BAD51AC,6BAD51AC] ptm=6BAD51B4[6BAD51B4,6BAD51B4]
ref=6BAD51E8[6BAD51E8,6BAD51E8] lnd=6BAD51F4[6BAD4138,6BAD55B4]
LIBRARY OBJECT: object=69738be4
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
CHILDREN: size=16
child# table reference handle
------ -------- --------- --------
0 69738b70 69738824 6bad5028
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6bad50fc 69738c7c I/P/A/-/- 0 NONE 00
----------------------------------------
SO: 69D62F0C, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d62f0c handle=6bac9ae4 mode=N
call pin=00000000 session pin=69D6751C hpc=0000 hlc=0000
htl=69D62F5C[69D61DDC,69D4A72C] htb=69D4A72C ssga=69D49EB0
user=6bd67898 session=6bd665d0 count=1 flags=[0000] savepoint=0x0
LIBRARY OBJECT HANDLE: handle=6bac9ae4 mutex=6BAC9B98(0)
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch#=1 hpc=001a hlc=001a
lwt=6BAC9B40[6BAC9B40,6BAC9B40] ltm=6BAC9B48[6BAC9B48,6BAC9B48]
pwt=6BAC9B24[6BAC9B24,6BAC9B24] ptm=6BAC9B2C[6BAC9B2C,6BAC9B2C]
ref=6BAC9B60[697249E4,697249E4] lnd=6BAC9B6C[6BAC9B6C,6BAC9B6C]
LIBRARY OBJECT: object=69724544
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
DEPENDENCIES: count=1 size=16
READ ONLY DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6bac9a74 69724694 I/P/A/-/- 0 NONE 00
6 69723ef8 693cfbb4 I/-/A/-/- 0 NONE 00
----------------------------------------
SO: 69D61D8C, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d61d8c handle=6bac9c28 mode=N
call pin=00000000 session pin=00000000 hpc=0000 hlc=0000
htl=69D61DDC[69D4A72C,69D62F5C] htb=69D4A72C ssga=69D49EB0
user=6bd67898 session=6bd665d0 count=1 flags=[0000] savepoint=0x46c
LIBRARY OBJECT HANDLE: handle=6bac9c28 mutex=6BAC9CDC(1)
name=select con#,obj#,rcon#,enabled,nvl(defer,0) from cdef$ where robj#=:1
hash=12f772e1a2097382e4555ba057bc44f9 timestamp=10-14-2007 12:23:44
namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=1 hpc=001a hlc=001a
lwt=6BAC9C84[6BAC9C84,6BAC9C84] ltm=6BAC9C8C[6BAC9C8C,6BAC9C8C]
pwt=6BAC9C68[6BAC9C68,6BAC9C68] ptm=6BAC9C70[6BAC9C70,6BAC9C70]
ref=6BAC9CA4[6BAC9CA4,6BAC9CA4] lnd=6BAC9CB0[6BAC97C0,6BACA070]
LIBRARY OBJECT: object=69724da4
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
CHILDREN: size=16
child# table reference handle
------ -------- --------- --------
0 69724d30 697249e4 6bac9ae4
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6bac9bb8 69724e3c I/P/A/-/- 0 NONE 00
----------------------------------------
SO: 69D6305C, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d6305c handle=6bac86ac mode=N
call pin=00000000 session pin=69D03390 hpc=0000 hlc=0000
htl=69D630AC[69D22820,69D4C2AC] htb=69D4A3A4 ssga=69D49EB0
user=6bd67898 session=6bd665d0 count=1 flags=[0000] savepoint=0x0
LIBRARY OBJECT HANDLE: handle=6bac86ac mutex=6BAC8760(0)
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch#=1 hpc=0028 hlc=0028
lwt=6BAC8708[6BAC8708,6BAC8708] ltm=6BAC8710[6BAC8710,6BAC8710]
pwt=6BAC86EC[6BAC86EC,6BAC86EC] ptm=6BAC86F4[6BAC86F4,6BAC86F4]
ref=6BAC8728[6971CE7C,6971CE7C] lnd=6BAC8734[6BAC8734,6BAC8734]
LIBRARY OBJECT: object=6971da9c
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
DEPENDENCIES: count=1 size=16
READ ONLY DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6bac863c 6971dbec I/P/A/-/- 0 NONE 00
6 6971cbf0 6914c92c I/-/A/-/- 0 NONE 00
----------------------------------------
SO: 69D227D0, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d227d0 handle=6bac87f0 mode=N
call pin=00000000 session pin=00000000 hpc=0000 hlc=0000
htl=69D22820[69D4A3A4,69D630AC] htb=69D4A3A4 ssga=69D49EB0
user=6bd67898 session=6bd665d0 count=1 flags=[0000] savepoint=0x3f3
LIBRARY OBJECT HANDLE: handle=6bac87f0 mutex=6BAC88A4(1)
name=select grantee#,privilege#,nvl(col#,0),max(mod(nvl(option$,0),2))from objauth$ where obj#=:1 group by grantee#,privilege#,nvl(col#,0) order by grantee#
hash=26947ac91d45c1242b247fc5f6b6f088 timestamp=10-14-2007 12:23:45
namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=1 hpc=0028 hlc=0028
lwt=6BAC884C[6BAC884C,6BAC884C] ltm=6BAC8854[6BAC8854,6BAC8854]
pwt=6BAC8830[6BAC8830,6BAC8830] ptm=6BAC8838[6BAC8838,6BAC8838]
ref=6BAC886C[6BAC886C,6BAC886C] lnd=6BAC8878[6BAC7354,6BAD44D0]
LIBRARY OBJECT: object=6971d23c
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
CHILDREN: size=16
child# table reference handle
------ -------- --------- --------
0 6971d1c8 6971ce7c 6bac86ac
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6bac8780 6971d2d4 I/P/A/-/- 0 NONE 00
----------------------------------------
SO: 69D62E2C, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d62e2c handle=6bacc8c0 mode=N
call pin=00000000 session pin=00000000 hpc=0000 hlc=0000
htl=69D62E7C[69D62EEC,69D4A2C4] htb=69D4A2C4 ssga=69D49EB0
user=6bd67898 session=6bd665d0 count=1 flags=[0000] savepoint=0x0
LIBRARY OBJECT HANDLE: handle=6bacc8c0 mutex=6BACC974(0)
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch#=1 hpc=0004 hlc=0004
lwt=6BACC91C[6BACC91C,6BACC91C] ltm=6BACC924[6BACC924,6BACC924]
pwt=6BACC900[6BACC900,6BACC900] ptm=6BACC908[6BACC908,6BACC908]
ref=6BACC93C[69728CE4,69728CE4] lnd=6BACC948[6BACC948,6BACC948]
LIBRARY OBJECT: object=696f16ec
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
DEPENDENCIES: count=1 size=16
READ ONLY DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6baa4c5c 696f183c I/P/A/-/- 0 NONE 00
6 696f10a0 69111654 I/-/A/-/- 0 NONE 00
----------------------------------------
SO: 69D62E9C, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d62e9c handle=6bacca04 mode=N
call pin=00000000 session pin=00000000 hpc=0000 hlc=0000
htl=69D62EEC[69D4A2C4,69D62E7C] htb=69D4A2C4 ssga=69D49EB0
user=6bd67898 session=6bd665d0 count=1 flags=[0000] savepoint=0x335
LIBRARY OBJECT HANDLE: handle=6bacca04 mutex=6BACCAB8(1)
name=select text from view$ where rowid=:1
hash=f0cfa2e63e1fda46fbf3cdf9535d1a6c timestamp=10-14-2007 12:23:44
namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/SML/KST/DBN/MTX/[120100d4]
kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=1 hpc=0004 hlc=0004
lwt=6BACCA60[6BACCA60,6BACCA60] ltm=6BACCA68[6BACCA68,6BACCA68]
pwt=6BACCA44[6BACCA44,6BACCA44] ptm=6BACCA4C[6BACCA4C,6BACCA4C]
ref=6BACCA80[6BACCA80,6BACCA80] lnd=6BACCA8C[6BACA070,6BACCBE4]
LIBRARY OBJECT: object=697290a4
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
CHILDREN: size=16
child# table reference handle
------ -------- --------- --------
0 69729030 69728ce4 6bacc8c0
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6bacc994 6972913c I/P/A/-/- 0 NONE 00
----------------------------------------
SO: 69D6313C, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d6313c handle=6ba7e544 mode=N
call pin=69D150E8 session pin=00000000 hpc=0000 hlc=0000
htl=69D6318C[69D4A64C,69D4A64C] htb=69D4A64C ssga=69D49EB0
user=6bd67898 session=6bd67898 count=1 flags=[0000] savepoint=0x2c5
LIBRARY OBJECT HANDLE: handle=6ba7e544 mutex=6BA7E5F8(0)
name=SYS.PLITBLM
hash=3b4ff668552ec0feac34b7c0b8c39fdd timestamp=02-07-2006 22:14:09
namespace=TABL flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0011-0011 lock=N pin=0 latch#=1 hpc=0000 hlc=0000
lwt=6BA7E5A0[6BA7E5A0,6BA7E5A0] ltm=6BA7E5A8[6BA7E5A8,6BA7E5A8]
pwt=6BA7E584[6BA7E584,6BA7E584] ptm=6BA7E58C[6BA7E58C,6BA7E58C]
ref=6BA7E5C0[6BA7E5C0,6BA7E5C0] lnd=6BA7E5CC[6BA7E3B0,6BA7E724]
LIBRARY OBJECT: object=695d2970
type=PCKG flags=EXS/LOC[0005] pflags=NST[0001] status=VALD load=0
DEPENDENCIES: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6b9dd82c 695d2a2c I/-/A/-/- 0 NONE 00
4 695d2b1c 69207e74 I/-/A/-/- 0 NONE 00
----------------------------------------
SO: 69D6202C, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d6202c handle=6b925954 mode=N
call pin=69D4CBFC session pin=00000000 hpc=0000 hlc=0000
htl=69D6207C[69D4A6BC,69D4A6BC] htb=69D4A6BC ssga=69D49EB0
user=6bd67898 session=6bd67898 count=1 flags=[0000] savepoint=0x257
LIBRARY OBJECT HANDLE: handle=6b925954 mutex=6B925A08(0)
name=SYS.DBMS_OUTPUT
hash=ca5f8059a062c260dd56ff3c1b9e6feb timestamp=02-07-2006 22:14:51
namespace=BODY flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0011-0011 lock=N pin=0 latch#=1 hpc=0004 hlc=0004
lwt=6B9259B0[6B9259B0,6B9259B0] ltm=6B9259B8[6B9259B8,6B9259B8]
pwt=6B925994[6B925994,6B925994] ptm=6B92599C[6B92599C,6B92599C]
ref=6B9259D0[6B9259D0,6B9259D0] lnd=6B9259DC[6B9259DC,6B9259DC]
LIBRARY OBJECT: object=69452b64
type=PKBD flags=EXS/LOC[0005] pflags=/SWR[0008] status=VALD load=0
DEPENDENCIES: count=4 size=16
ACCESSES: count=3 size=16
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6b9258e4 69452c20 I/-/A/-/- 0 NONE 00
4 69452dec 68e59d8c I/-/A/-/- 0 NONE 00
----------------------------------------
SO: 69D38EE8, type: 54, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=69d38ee8 handle=6ba8e0c4 mode=S lock=0
user=6bd67898 session=6bd67898 count=1 mask=0041 savepoint=0x235 flags=[04]
----------------------------------------
SO: 69D60CEC, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d60cec handle=6ba8e0c4 mode=N
call pin=00000000 session pin=00000000 hpc=0000 hlc=0000
htl=69D60D3C[69D60DAC,69D49FA4] htb=69D49FA4 ssga=69D49EB0
user=6bd67898 session=6bd67898 count=1 flags=[0000] savepoint=0x0
LIBRARY OBJECT HANDLE: handle=6ba8e0c4 mutex=6BA8E178(0)
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=S latch#=1 hpc=0008 hlc=0008
lwt=6BA8E120[6BA8E120,6BA8E120] ltm=6BA8E128[6BA8E128,6BA8E128]
pwt=6BA8E104[6BA8E104,6BA8E104] ptm=6BA8E10C[6BA8E10C,6BA8E10C]
ref=6BA8E140[696B22B4,696B22B4] lnd=6BA8E14C[6BA8E14C,6BA8E14C]
LIBRARY OBJECT: object=696b1e14
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
DEPENDENCIES: count=1 size=16
READ ONLY DEPENDENCIES: count=1 size=16
SCHEMA: count=1 size=16 entrysize=4
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6ba8e054 696b1f64 I/P/A/-/- 0 NONE 00
6 696b1b50 696abd30 I/P/A/-/- 3 NONE 00
----------------------------------------
SO: 69D60D5C, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d60d5c handle=6ba8e208 mode=N
call pin=00000000 session pin=00000000 hpc=0000 hlc=0000
htl=69D60DAC[69D49FA4,69D60D3C] htb=69D49FA4 ssga=69D49EB0
user=6bd67898 session=6bd67898 count=1 flags=[0000] savepoint=0x234
LIBRARY OBJECT HANDLE: handle=6ba8e208 mutex=6BA8E2BC(0)
name=table_1_ff_14f_0_0_0
hash=aea003b000399a6247b4cb0dca3f6508 timestamp=10-14-2007 12:23:49
namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/SML/DBN/[12010044]
kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=1 hpc=0008 hlc=0008
lwt=6BA8E264[6BA8E264,6BA8E264] ltm=6BA8E26C[6BA8E26C,6BA8E26C]
pwt=6BA8E248[6BA8E248,6BA8E248] ptm=6BA8E250[6BA8E250,6BA8E250]
ref=6BA8E284[6BA8E284,6BA8E284] lnd=6BA8E290[6BA8D240,6BA8F554]
LIBRARY OBJECT: object=696b2674
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
CHILDREN: size=16
child# table reference handle
------ -------- --------- --------
0 696b2600 696b22b4 6ba8e0c4
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6ba8e198 696b270c I/P/A/-/- 0 NONE 00
----------------------------------------
SO: 69D4C1EC, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d4c1ec handle=6ba7e7f4 mode=N
call pin=69D38E38 session pin=00000000 hpc=0000 hlc=0000
htl=69D4C23C[69D4A43C,69D38B38] htb=69D4A43C ssga=69D49EB0
user=6bd67898 session=6bd67898 count=1 flags=[0000] savepoint=0x1f8
LIBRARY OBJECT HANDLE: handle=6ba7e7f4 mutex=6BA7E8A8(0)
name=SYS.DBMS_OUTPUT
hash=604faccdb7c0be2e85bfbdc4e6cdd69b timestamp=02-07-2006 22:14:38
namespace=TABL flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0015-0015 lock=N pin=0 latch#=1 hpc=0004 hlc=0004
lwt=6BA7E850[6BA7E850,6BA7E850] ltm=6BA7E858[6BA7E858,6BA7E858]
pwt=6BA7E834[6BA7E834,6BA7E834] ptm=6BA7E83C[6BA7E83C,6BA7E83C]
ref=6BA7E870[6BA7E870,6BA7E870] lnd=6BA7E87C[6BA7E724,6BA7E9D4]
LIBRARY OBJECT: object=69452f94
type=PCKG flags=EXS/LOC[0005] pflags=NST[0001] status=VALD load=0
DEPENDENCIES: count=2 size=16
ACCESSES: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6b927308 6945302c I/-/A/-/- 0 NONE 00
2 69453194 68e5edd0 I/-/A/-/- 0 NONE 00
4 69453208 68e5ad8c I/-/A/-/- 0 NONE 00
----------------------------------------
SO: 69D54A0C, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d54a0c handle=6ba465a0 mode=N
call pin=69D390A0 session pin=00000000 hpc=0000 hlc=0000
htl=69D54A5C[69D4A4CC,69D22A50] htb=69D4A4CC ssga=69D49EB0
user=6bd67898 session=6bd67898 count=1 flags=CBB/[0200] savepoint=0x66
LIBRARY OBJECT HANDLE: handle=6ba465a0 mutex=6BA46654(0)
name=SYS.DATABASE
hash=b5a9f7312f29be8a9555e4f6d62cc3ad timestamp=12-31-4712 23:59:59
namespace=EVNT flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0009-0009 lock=N pin=0 latch#=1 hpc=0008 hlc=0008
lwt=6BA465FC[6BA465FC,6BA465FC] ltm=6BA46604[6BA46604,6BA46604]
pwt=6BA465E0[6BA465E0,6BA465E0] ptm=6BA465E8[6BA465E8,6BA465E8]
ref=6BA4661C[6BA4661C,6BA4661C] lnd=6BA46628[6BA46628,6BA46628]
LIBRARY OBJECT: object=69620c24
type=EVNT flags=EXS/LOC[0005] pflags=[0000] status=VALD load=0
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6ba46530 69620ce0 I/-/A/-/- 0 NONE 00
3 69620d1c 69694e50 I/-/A/-/- 0 NONE 00
----------------------------------------
SO: 69D6321C, type: 53, owner: 6BD67898, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=69d6321c handle=6b953e98 mode=N
call pin=69D4C9EC session pin=00000000 hpc=0000 hlc=0000
htl=69D6326C[69D4A544,69D4A544] htb=69D4A544 ssga=69D49EB0
user=6bd67898 session=6bd67898 count=1 flags=CBB/[0200] savepoint=0x66
LIBRARY OBJECT HANDLE: handle=6b953e98 mutex=6B953F4C(0)
name=TESTUSER1.TESTUSER1
hash=b41cc8de849c268e3d752036069b96bc timestamp=12-31-4712 23:59:59
namespace=EVNT flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0009-0009 lock=N pin=0 latch#=1 hpc=0006 hlc=0006
lwt=6B953EF4[6B953EF4,6B953EF4] ltm=6B953EFC[6B953EFC,6B953EFC]
pwt=6B953ED8[6B953ED8,6B953ED8] ptm=6B953EE0[6B953EE0,6B953EE0]
ref=6B953F14[6B953F14,6B953F14] lnd=6B953F20[6B953F20,6B953F20]
LIBRARY OBJECT: object=694cd014
type=EVNT flags=EXS/LOC[0005] pflags=[0000] status=VALD load=0
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 6b953e28 694cd0d0 I/-/A/-/- 0 NONE 00
3 694cd10c 694ccbe4 I/-/A/-/- 0 NONE 00
----------------------------------------
SO: 6B94F980, type: 52, owner: 6BD67898, flag: INIT/-/-/0x00
user lock: lock=6b94f980 mode=S
user resource: user=69d5f6a4 uid=44 mode=S
----------------------------------------
SO: 6B9AD004, type: 52, owner: 6BD67898, flag: INIT/-/-/0x00
user lock: lock=6b9ad004 mode=S
user resource: user=69d5f6a4 uid=44 mode=S
----------------------------------------
SO: 6ADB8D74, type: 41, owner: 6BD67898, flag: INIT/-/-/0x00
(dummy) nxc=0, nlb=0
----------------------------------------
SO: 6BE4CCCC, type: 11, owner: 6BD35D34, flag: INIT/-/-/0x00
(broadcast handle) flag: (2) ACTIVE SUBSCRIBER, owner: 6BD35D34,
event: 27, last message event: 27,
last message waited event: 27, messages read: 0
channel: (6BE4D5CC) system events broadcast channel
scope: 2, event: 28, last mesage event: 20,
publishers/subscribers: 0/19,
messages published: 1
----------------------------------------
SO: 6BD86EA8, type: 3, owner: 6BD35D34, flag: INIT/-/-/0x00
(call) sess: cur 6bd67898, rec 0, usr 6bd67898; depth: 0
----------------------------------------
SO: 6B707B80, type: 16, owner: 6BD35D34, flag: INIT/-/-/0x00
(osp req holder)
===================================================
CURRENT SESSION'S INSTANTIATION STATE
-------------------------------------
current session=6BD67898
KGI STATE DUMP for session=6BD67898
-------------------------------------
INSTANTIATION OBJECT: object=07BB7858
type="PL/SQL"[0] lock=69D60C0C handle=6BA2C9FC spec=08055040 level=0
flags=SHR/BDY/[43] executions=1
REST OF INSTANTIATION OBJECT:
address=07BB78C4 size=88
0000001B 08055040 084C6130 00000000 07BB80E8 00000000 00190020 00000019
692F81C0 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 692F8370 07BB7FB8 00000000 00000000 00000000
-------------------------------------
INSTANTIATION OBJECT: object=08055040
type="PL/SQL"[0] lock=69D54CAC handle=6BA2E45C body=07BB7858 level=0
flags=SHR/[41] executions=2
REST OF INSTANTIATION OBJECT:
address=080550AC size=88
FFFFFFFF 08055040 084C6130 00000000 08054A7C 00000000 00180020 00000018
692F91C0 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 692F920C 08054A0C 00000000 00000000 00000000
-------------------------------------
INSTANTIATION OBJECT: object=0805188C
type="PL/SQL"[0] lock=69D6313C handle=6BA7E544 body=00000000 level=0
flags=SHR/NST/LRU[1045] executions=2
REST OF INSTANTIATION OBJECT:
address=080518F8 size=88
0000000D 0805188C 084C6130 00000000 08057084 00000000 00160022 00000016
69207F80 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000
-------------------------------------
INSTANTIATION OBJECT: object=0805195C
type="PL/SQL"[0] lock=69D6202C handle=6B925954 spec=08051A2C level=0
flags=SHR/BDY/[43] executions=1
DEPENDENCIES: size=4
dependency# instantiation flags
----------- ------------- -------
0 00000000 [00]
1 00000000 [00]
2 0805188C [00]
3 00000000 [00]
REST OF INSTANTIATION OBJECT:
address=080519C8 size=88
FFFFFFFF 08051A2C 084C6130 00000000 080581E0 00000000 00150020 00000015
68E59E98 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000001 68E5A50C 08057B60 00000000 00000000 00000000
-------------------------------------
INSTANTIATION OBJECT: object=08051A2C
type="PL/SQL"[0] lock=69D4C1EC handle=6BA7E7F4 body=0805195C level=0
flags=SHR/[41] executions=2
REST OF INSTANTIATION OBJECT:
address=08051A98 size=88
FFFFFFFF 08051A2C 084C6130 00000000 08058B1C 00000000 00140020 00000014
68E5AE98 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000
-------------------------------------
INSTANTIATION OBJECT: object=07BBCB38
type="KOKA open cursor"[1] lock=00000000 handle=00000000 body=00000000 level=0
flags=[40] executions=0
REST OF INSTANTIATION OBJECT:
address=07BBCBA4 size=12
00000000 00000005 0000000A
-------------------------------------
INSTANTIATION OBJECT: object=07BBCAB4
type="KOKA pseudo cursor"[2] lock=00000000 handle=00000000 body=00000000 level=0
flags=[40] executions=0
CURSORS: size=4 count=1 next=2
index cursor tag context flags
----- ------ -------- -------- ---------------
1 3 00000000 08054030 LRU/PRS/PST[07]
REST OF INSTANTIATION OBJECT:
address=07BBCB20 size=12
00000001 00000005 0000000A
KGI STATE DUMP DONE for session=6BD67898
******************** Session Cursor Dump **********************
Current cursor: 4, pgadep: 0
Open cursors(pls, sys, hwm, max): 2(0, 0, 64, 300)
NULL 1 SYNTAX 0 PARSE 0 BOUND 1 FETCH 0 ROW 0
Cached frame pages(total, free):
4k(5, 5), 8k(0, 0), 16k(0, 0), 32k(0, 0)
pgactx: 68E44AAC ctxcbk: 68E44904 ctxqbc: 00000000 ctxrws: 68E4390C
Explain plan:


Dumping stream from 0 to 76
----------------------------------

0000: 143 12 57 228 104 137 119 1 0 16 0 0 0 3 1 2 0 0 0 0 ..9.h.w.............
0020: 0 50 7 3 5 11 8 106 108 109 224 152 228 161 113 111 3 101 3 3 .2.....jlm....qo.e..
0040: 2 5 2 2 5 2 4 34 0 0 143 4 59 228 104 134 124 2 23 11 ......."....;.h.|...
0060: 0 128 200 0 1 40 3 1 6 192 122 217 3 2 1 142 .....(....z.....

============
Plan Table
============
------------------------------------------+-----------------------------------+
| Id | Operation | Name | Rows | Bytes | Cost | Time |
------------------------------------------+-----------------------------------+
| 0 | DELETE STATEMENT | | | | 1 | |
| 1 | DELETE | CHILD_GROUP | | | | |
| 2 | INDEX FULL SCAN | XPKCHILD_GROUP| 1 | 40 | 0 | |
------------------------------------------+-----------------------------------+

Content of other_xml column
===========================
db_version : 10.2.0.1
parse_schema : TESTUSER1
plan_hash : 3452016767
Outline Data:
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('10.2.0.1')
ALL_ROWS
OUTLINE_LEAF(@"DEL$1")
INDEX(@"DEL$1" "CHILD_GROUP"@"DEL$1" ("CHILD_GROUP"."GROUP_ID" "CHILD_GROUP"."PARENT_ID"))
END_OUTLINE_DATA
*/

Optimizer environment:
optimizer_mode_hinted = false
optimizer_features_hinted = 0.0.0
parallel_execution_enabled = false
parallel_query_forced_dop = 0
parallel_dml_forced_dop = 0
parallel_ddl_forced_degree = 0
parallel_ddl_forced_instances = 0
_query_rewrite_fudge = 90
optimizer_features_enable = 10.2.0.1
_optimizer_search_limit = 5
cpu_count = 1
active_instance_count = 1
parallel_threads_per_cpu = 2
hash_area_size = 131072
bitmap_merge_area_size = 1048576
sort_area_size = 65536
sort_area_retained_size = 0
_sort_elimination_cost_ratio = 0
_optimizer_block_size = 8192
_sort_multiblock_read_count = 2
_hash_multiblock_io_count = 0
_db_file_optimizer_read_count = 8
_optimizer_max_permutations = 2000
pga_aggregate_target = 40960 KB
_pga_max_size = 204800 KB
_query_rewrite_maxdisjunct = 257
_smm_auto_min_io_size = 56 KB
_smm_auto_max_io_size = 248 KB
_smm_min_size = 128 KB
_smm_max_size = 8192 KB
_smm_px_max_size = 20480 KB
_cpu_to_io = 0
_optimizer_undo_cost_change = 10.2.0.1
parallel_query_mode = enabled
parallel_dml_mode = disabled
parallel_ddl_mode = enabled
optimizer_mode = all_rows
sqlstat_enabled = false
_optimizer_percent_parallel = 101
_always_anti_join = choose
_always_semi_join = choose
_optimizer_mode_force = true
_partition_view_enabled = true
_always_star_transformation = false
_query_rewrite_or_error = false
_hash_join_enabled = true
cursor_sharing = exact
_b_tree_bitmap_plans = true
star_transformation_enabled = false
_optimizer_cost_model = choose
_new_sort_cost_estimate = true
_complex_view_merging = true
_unnest_subquery = true
_eliminate_common_subexpr = true
_pred_move_around = true
_convert_set_to_join = false
_push_join_predicate = true
_push_join_union_view = true
_fast_full_scan_enabled = true
_optim_enhance_nnull_detection = true
_parallel_broadcast_enabled = true
_px_broadcast_fudge_factor = 100
_ordered_nested_loop = true
_no_or_expansion = false
optimizer_index_cost_adj = 100
optimizer_index_caching = 0
_system_index_caching = 0
_disable_datalayer_sampling = false
query_rewrite_enabled = true
query_rewrite_integrity = enforced
_query_cost_rewrite = true
_query_rewrite_2 = true
_query_rewrite_1 = true
_query_rewrite_expression = true
_query_rewrite_jgmigrate = true
_query_rewrite_fpc = true
_query_rewrite_drj = true
_full_pwise_join_enabled = true
_partial_pwise_join_enabled = true
_left_nested_loops_random = true
_improved_row_length_enabled = true
_index_join_enabled = true
_enable_type_dep_selectivity = true
_improved_outerjoin_card = true
_optimizer_adjust_for_nulls = true
_optimizer_degree = 0
_use_column_stats_for_function = true
_subquery_pruning_enabled = true
_subquery_pruning_mv_enabled = false
_or_expand_nvl_predicate = true
_like_with_bind_as_equality = false
_table_scan_cost_plus_one = true
_cost_equality_semi_join = true
_default_non_equality_sel_check = true
_new_initial_join_orders = true
_oneside_colstat_for_equijoins = true
_optim_peek_user_binds = true
_minimal_stats_aggregation = true
_force_temptables_for_gsets = false
workarea_size_policy = auto
_smm_auto_cost_enabled = true
_gs_anti_semi_join_allowed = true
_optim_new_default_join_sel = true
optimizer_dynamic_sampling = 2
_pre_rewrite_push_pred = true
_optimizer_new_join_card_computation = true
_union_rewrite_for_gs = yes_gset_mvs
_generalized_pruning_enabled = true
_optim_adjust_for_part_skews = true
_force_datefold_trunc = false
statistics_level = typical
_optimizer_system_stats_usage = true
skip_unusable_indexes = true
_remove_aggr_subquery = true
_optimizer_push_down_distinct = 0
_dml_monitoring_enabled = true
_optimizer_undo_changes = false
_predicate_elimination_enabled = true
_nested_loop_fudge = 100
_project_view_columns = true
_local_communication_costing_enabled = true
_local_communication_ratio = 50
_query_rewrite_vop_cleanup = true
_slave_mapping_enabled = true
_optimizer_cost_based_transformation = linear
_optimizer_mjc_enabled = true
_right_outer_hash_enable = true
_spr_push_pred_refspr = true
_optimizer_cache_stats = false
_optimizer_cbqt_factor = 50
_optimizer_squ_bottomup = true
_fic_area_size = 131072
_optimizer_skip_scan_enabled = true
_optimizer_cost_filter_pred = false
_optimizer_sortmerge_join_enabled = true
_optimizer_join_sel_sanity_check = true
_mmv_query_rewrite_enabled = true
_bt_mmv_query_rewrite_enabled = true
_add_stale_mv_to_dependency_list = true
_distinct_view_unnesting = false
_optimizer_dim_subq_join_sel = true
_optimizer_disable_strans_sanity_checks = 0
_optimizer_compute_index_stats = true
_push_join_union_view2 = true
_optimizer_ignore_hints = false
_optimizer_random_plan = 0
_query_rewrite_setopgrw_enable = true
_optimizer_correct_sq_selectivity = true
_disable_function_based_index = false
_optimizer_join_order_control = 3
_optimizer_cartesian_enabled = true
_optimizer_starplan_enabled = true
_extended_pruning_enabled = true
_optimizer_push_pred_cost_based = true
_sql_model_unfold_forloops = run_time
_enable_dml_lock_escalation = false
_bloom_filter_enabled = true
_update_bji_ipdml_enabled = 0
_optimizer_extended_cursor_sharing = udo
_dm_max_shared_pool_pct = 1
_optimizer_cost_hjsmj_multimatch = true
_optimizer_transitivity_retain = true
_px_pwg_enabled = true
optimizer_secure_view_merging = true
_optimizer_join_elimination_enabled = true
flashback_table_rpi = non_fbt
_optimizer_cbqt_no_size_restriction = true
_optimizer_enhanced_filter_push = true
_optimizer_filter_pred_pullup = true
_rowsrc_trace_level = 0
_simple_view_merging = true
_optimizer_rownum_pred_based_fkr = true
_optimizer_better_inlist_costing = all
_optimizer_self_induced_cache_cost = false
_optimizer_min_cache_blocks = 10
_optimizer_or_expansion = depth
_optimizer_order_by_elimination_enabled = true
_optimizer_outer_to_anti_enabled = true
_selfjoin_mv_duplicates = true
_dimension_skip_null = true
_force_rewrite_enable = false
_optimizer_star_tran_in_with_clause = true
_optimizer_complex_pred_selectivity = true
_gby_hash_aggregation_enabled = true
_enable_row_shipping = false
***************** dump of cursor xsc=7bbb034 **********************
------------- dump of shared cursor ------------------
Re: Deadlock during DELETE operation [message #274133 is a reply to message #273773] Sun, 14 October 2007 05:39 Go to previous messageGo to next message
sagimann
Messages: 8
Registered: October 2007
Junior Member
small correct from the procedure above:
A: delete from CHILD;
B: delete from CHILD;
A: delete from CHILD_GROUP;
B: delete from CHILD_GROUP (and not from CHILD)
tnx
Re: Deadlock during DELETE operation [message #274185 is a reply to message #274133] Sun, 14 October 2007 23:10 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
So this tells us that the CHILD_GROUP of the deleted CHILD rows of each session are locked in SHARE mode. Similarly the PARENT of those CHILD_GROUPs are also locked in SHARE mode.

Since the locks are in SHARE mode, we cannot tell whether the same rows are being locked by both sessions. All we can see is that the two sessions are deleting different CHILD rows.

When you delete the CHILD rows, how can you be sure that rows from session A and B do not belong to the same CHILD_GROUP.

When you go to delete the CHILD_GROUP rows, how do you ensure that you are only deleting the rows previously locked during the CHILD deletion.

Ross Leishman
Re: Deadlock during DELETE operation [message #274208 is a reply to message #274185] Mon, 15 October 2007 01:47 Go to previous messageGo to next message
sagimann
Messages: 8
Registered: October 2007
Junior Member
"So this tells us that the CHILD_GROUP of the deleted CHILD rows of each session are locked in SHARE mode. Similarly the PARENT of those CHILD_GROUPs are also locked in SHARE mode."

Not exactly:
I verified that only "immediate parents" (i.e. fk's) of the CHILD table become locked upon deletion. In other words, if there was no 'parent_id_fk' in CHILD, the PARENT table would not have been locked - only CHILD_GROUP would have been locked.

"When you delete the CHILD rows, how can you be sure that rows from session A and B do not belong to the same CHILD_GROUP."

You may assume that I can. In my tests it didn't make any difference. Client A did 'delete from CHILD where group_id_fk = X', whereas client B did the same, only group_id_fk = Y. Even the PARENT records of the deleted CHILD/CHILD_GROUP records were unrelated in any way. Still, the same deadlock occured.

"When you go to delete the CHILD_GROUP rows, how do you ensure that you are only deleting the rows previously locked during the CHILD deletion."

Same answer. Assume that I know for a fact that I never delete ANY related rows via any relationship path, using the 2 different clients. The problem is, only I know this Smile there is no way of telling from the sql queries themselves...

[Updated on: Mon, 15 October 2007 01:51]

Report message to a moderator

Re: Deadlock during DELETE operation [message #274242 is a reply to message #274208] Mon, 15 October 2007 03:32 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Replace the delete:
DELETE FROM CHILD WHERE child_grp = 'val'

with
FOR chld IN (
  SELECT child_grp
  FROM child
  WHERE child_grp = 'val'
) LOOP
    dbms_output.put_line('Deleting ' || chld.rowid);

    SELECT child_grp
    INTO   dummy
    FROM   child_grp
    WHERE  child_grp = chld.child_grp
    FOR UPDATE NOWAIT;

    DELETE FROM chld WHERE rowid = chld.rowid;
END LOOP;

When you run it, no child will be deleted without first acquiring an exclusive lock on its child group.

If you get a failure during the CHILD delete, then A and B are trying to lock the same child groups.

If the CHILD delete succeeds and the CHILD_GROUP delete gets blocked, then you are trying to delete CHILD_GROUP rows that you have not already locked in the CHILD delete.

Also, try your original test after disabling the FK between PARENT and CHILD_GROUP just to make sure this isn't involved.

Ross Leishman
Re: Deadlock during DELETE operation [message #275065 is a reply to message #274242] Thu, 18 October 2007 04:00 Go to previous messageGo to next message
sagimann
Messages: 8
Registered: October 2007
Junior Member
Hi,
I haven't had a chance to try out the SQL you gave me, but I was able to resolve the issue (hopefully, this is the correct way):

Turns out that although my FK columns were indexed as apart of the table's PK, I had to create ANOTHER index to exclusively hold them. I've gone through the Data Integrity chapter of Oracle 10g docs and am still unable to figure out why this is needed. Any ideas?
Re: Deadlock during DELETE operation [message #275102 is a reply to message #275065] Thu, 18 October 2007 05:12 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Were the FK columns the leading columns in the index, or (as I suspect) just present at some point in the index.
Re: Deadlock during DELETE operation [message #275120 is a reply to message #275102] Thu, 18 October 2007 06:48 Go to previous messageGo to next message
sagimann
Messages: 8
Registered: October 2007
Junior Member
There was no explicit index creation for the PK, so I don't know how the index was defined. How can I find out?
Re: Deadlock during DELETE operation [message #275133 is a reply to message #275120] Thu, 18 October 2007 08:01 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
USER_IND_COLUMNS will tell you how the definition of the INDEX was created. Make note of COLUMN_POSITION.
Re: Deadlock during DELETE operation [message #275143 is a reply to message #273773] Thu, 18 October 2007 08:56 Go to previous messageGo to next message
sagimann
Messages: 8
Registered: October 2007
Junior Member
In the initial PK index, the columns belonging to the FK start at position 2. In position 1 is a column that is specific to that table.

For example, for 'CHILD' table, index for PK(child_name, parent_name) is:
pos1: child_name
pos2: parent_name <-- fk to parent table

I guess this is a result of how the PK was defined in the SQL statement that created the table?

Anyway, do the FK's need to be leading to address the locking issue (is this documented)?

In case of multiple FK's, I guess there is no escape from creating multiple indexes, correct?

tnx.
Re: Deadlock during DELETE operation [message #276051 is a reply to message #273773] Tue, 23 October 2007 15:21 Go to previous messageGo to next message
Kevin Meade
Messages: 2101
Registered: December 1999
Location: Connecticut USA
Senior Member
OK I am frustrated. I wanted to check this out but you have made it difficult. If I may ask a favor.

You said you had a simple example that causes the error, please post it so I (and others) can try it out.

Kevin
Re: Deadlock during DELETE operation [message #276052 is a reply to message #273773] Tue, 23 October 2007 15:34 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
Check out contents of this thread http://www.orafaq.com/forum/m/275384/74940/#msg_275384

I did not test using DELETE, but I strongly suspect results of ORA-00060 would be the same.
Re: Deadlock during DELETE operation [message #276055 is a reply to message #276052] Tue, 23 October 2007 15:58 Go to previous messageGo to next message
Kevin Meade
Messages: 2101
Registered: December 1999
Location: Connecticut USA
Senior Member
This thread has no information. I see no script file with the replayable example. No create table/create index/create constraint/... statements. Maybe I missed them but I don't see them.

When posting this kind of issue, and you have a working sample, you should post the working sample. Then people can try the sample and work it for a solution.

Do you have these artificacts? I wanted to try and duplicate.

Thanks, Kevin
Re: Deadlock during DELETE operation [message #276062 is a reply to message #273773] Tue, 23 October 2007 16:11 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>"feature" documented in Note:392816.1
It uses INSERT, but I am certain the ORA-00060 would result using DELETE or UPDATE, too.
It is NOTHING fancy or sophisticated, just a simple straightforward deadlock; where SESS1 blocks SESS2 then SESS2 blocks SESS1 (or vice versa).
Re: Deadlock during DELETE operation [message #276094 is a reply to message #276062] Tue, 23 October 2007 23:06 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Try this AS IS, then uncomment the CREATE INDEX statement to make it work properly.


drop table dl2 purge;
drop table dl1 purge;

create table dl1 ( a number, b number, c number
        ,primary key (a,b)
);

create table dl2 ( a number, b number, c number
        ,primary key (c, a, b)
        ,foreign key (a,b) references dl1(a,b)
);

--create index dl2_i1 on dl2(a,b);

insert into dl1 values (1 , 2, 3);
insert into dl1 values (4 , 5, 6);

insert into dl2 values (1 , 2, 3);
insert into dl2 values (4 , 5, 6);

commit;

prompt RUN THIS IN SESSION 1: delete from dl2 where a = 4;
prompt RUN THIS IN SESSION 2: delete from dl2 where a = 1;
prompt RUN THIS IN SESSION 1: delete from dl1 where a = 4;
prompt RUN THIS IN SESSION 2: delete from dl1 where a = 1;


Ross Leishman
Re: Deadlock during DELETE operation [message #276129 is a reply to message #276094] Wed, 24 October 2007 01:34 Go to previous messageGo to next message
sagimann
Messages: 8
Registered: October 2007
Junior Member
Sorry guys, for the lack of info. Following, is the simplest scenario that reproduced the problem. The CREATE INDEX command solved the ORA-00060 issue, but if I understand correctly, I may avoid the additional index simply by reorganizing existing PK indexes. I'll try it out asap. Anyway, here's the script:

CREATE TABLE COMPANY (
COMPANY_ID NUMBER NOT NULL ,
COMP_NAME CHAR(18) NOT NULL ,
CONSTRAINT XPKCOMPANY PRIMARY KEY (COMPANY_ID,COMP_NAME)
);

CREATE TABLE EMPLOYEE (
EMP_ID NUMBER NOT NULL ,
COMPANY_ID NUMBER NOT NULL ,
COMP_NAME CHAR(18) NOT NULL ,
CONSTRAINT XPKEMPLOYEE PRIMARY KEY (EMP_ID,COMPANY_ID,COMP_NAME)
);

// remove this to get ORA-00060 during DELETEs:
CREATE INDEX XIF1EMPLOYEE ON EMPLOYEE (
COMPANY_ID ASC, COMP_NAME ASC
);


ALTER TABLE EMPLOYEE
ADD (CONSTRAINT R_4 FOREIGN KEY (COMPANY_ID,COMP_NAME) REFERENCES COMPANY(COMPANY_ID,COMP_NAME));

insert into company values (1,'c1');
insert into company values (2,'c2');
insert into employee values (11,1,'c1');
insert into employee values (22,2,'c2');
commit;

Using 2 sessions, A and B:
A: delete from employee where company_id=1;
B: delete from employee where company_id=2;
A: delete from company where company_id=1;
B: delete from company where company_id=2;
Re: Deadlock during DELETE operation [message #276133 is a reply to message #276129] Wed, 24 October 2007 01:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Thu, 11 October 2007 18:38

First, index your foreign keys.

Regards
Michel


Re: Deadlock during DELETE operation [message #276272 is a reply to message #276094] Wed, 24 October 2007 10:29 Go to previous message
Kevin Meade
Messages: 2101
Registered: December 1999
Location: Connecticut USA
Senior Member
thanks

Kevin
Previous Topic: Major issues with Merge - please help!!
Next Topic: Need to compare the values with previous recrod with cursor.
Goto Forum:
  


Current Time: Sun Dec 04 22:55:19 CST 2016

Total time taken to generate the page: 0.10854 seconds