Dump file e:\oracle\admin\TEST\udump\ORA00138.TRC Sat Aug 11 16:07:56 2001 ORACLE V8.1.7.0.0 - Production vsnsta=0 vsnsql=e vsnxtr=3 Windows NT Version 4.0 Service Pack 6, CPU type 586 Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production Windows NT Version 4.0 Service Pack 6, CPU type 586 Instance name: test Redo thread mounted by this instance: 1 Oracle process number: 8 ! v$process.pid Windows thread id: 138, image: ORACLE.EXE ! v$process.spid *** 2001-08-11 16:07:56.821 *** SESSION ID:(7.4) 2001-08-11 16:07:56.801 ! sid.serial# =================================================== PROCESS STATE ------------- Process global information: process: 2caecbc, call: 2ccb658, xact: 0, curses: 2cb9d40, usrses: 2cb9d40 ! v$session.paddr v$session.taddr v$session.saddr same ---------------------------------------- SO: 2caecbc, type: 1, owner: 0, pt: 0, flag: INIT/-/-/0x00 ! state object, type 1 = process; owner of process is always 0 since it's top in ! process state hierarchy. Type is really meaningless since it may be different for ! different platform/version; just look at the first word or phrase on next line. ! flag INIT: initialized; FLST: on freelist; CLN: cleaned by pmon ! [from www.cnoug.org/viewthread.php?tid=80059 by fly115] (process) Oracle pid=8, calls cur/top: 2ccb658/2ccb658, flag: (0) - ! SQL call current and top level: if equals, no recursive SQL i.e. depth=0 ! flag 0x01: dead process; 0x02: system process; 0x04: pmon; 0x08: smon; ! 0x10: pseudo; 0x20: shared server; 0x40: dispatcher 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 ! if not none, v$process.addr of the posting process would be shown here last post sent: 0 0 13 last post sent-location: ksasnd last process posted by me: 2cadcf4 1 2 ! This process posted 2cadcf4 some time ago. (latch info) wait_event=0 bits=0 Process Group: DEFAULT, pseudo proc: 2cb3240 ! If Process Group is not DEFAULT, there may be a process (session) leak. (Ref: Note:403995.1) O/S info: user: SYSTEM, term: CRYSTAL, ospid: 138 OSD pid info: 138 ! There may be more info here in newer version, such as FOB state object for ! file objects. ---------------------------------------- SO: 2cb9d40, type: 3, owner: 2caecbc, pt: 0, flag: INIT/-/-/0x00 ! Look at indentation from this point on: ! Process owns session (whose owner in hex number is v$process.addr), which in turn owns ! library cache pin and lock or user lock. Process also owns broadcast handle and call. (session) trans: 0, creator: 2caecbc, flag: (41) USR/- BSY/-/-/-/-/- DID: 0001-0008-00000002, short-term DID: 0000-0000-00000000 ! The middle number of DID is v$process.pid in hex; I don't know the first number, ! (DID probably means descriptor ID?) ! flag USR: user session; BSY: session is busy; DED: marked dead; ! DEL: deleted; KIL: killed; REC: recursive (Ref: ! http://tech.e2sn.com/oracle/oracle-internals-and-architecture/recursive-sessions-and-ora-00018-maximum-number-of-sessions-exceeded) txn branch: 0 oct: 42, prv: 0, user: 25/YONG ! oracle command type, 42=alter session, from v$session documentation O/S info: user: CRYSTAL\yong, term: CRYSTAL, ospid: 44:133, machine: WORKGROUP\CRYSTAL program: SQLPLUS.EXE application name: SQL*Plus, hash value=3669949024 last wait for 'SQL*Net message from client' blocking sess=0x0 seq=318 wait_time=3104 driver id=42455100, #bytes=1, =0 ! In newer version, you would see "waiting for" with p1,p2,p3, plus session wait ! history dump (in 10g). If the session has a transaction, a trans SO would ! also be shown followed by List of Blocks SO(s). See bottom of ./ModifiedBlockList.txt for example. ---------------------------------------- SO: 2d8a4c0, type: 36, owner: 2cb9d40, flag: INIT/-/-/0x00 LIBRARY OBJECT PIN: pin=2d8a4c0 handle=2ebd3e4 mode=S lock=2d895f0 user=2cb9d40 session=2cb9d40 count=1 mask=0041 savepoint=8696 flags=[00] ! user, session and savepoint correspond to kgllkuse, kgllkses and kgllkspn of x$kgllk, ! respectively, or similar columns of x$kglpn. ---------------------------------------- SO: 2d895f0, type: 35, owner: 2cb9d40, flag: INIT/-/-/0x00 ! For x$kgllk.kgllkadr 02D895F0 LIBRARY OBJECT LOCK: lock=2d895f0 handle=2ebd3e4 mode=N ! handle=x$kgllk.kgllkhdl; Null mode. Whenever you see handle, identify name of object ! by matching x$kgllk.kgllkhdl to get kglnaobj call pin=0 session pin=2d8a4c0 ! x$kgllk.kgllkpnc x$kgllk.kgllkpns user=2cb9d40 session=2cb9d40 count=1 flags=PNS/[08] savepoint=8695 ! Savepoint says this lock is acquired when this far into a transaction; use savepoint ! to establish the order of events that happened in the instance LIBRARY OBJECT HANDLE: handle=2ebd3e4 ! There should be two more lines here giving object name (in this case it's ! select * from v$process where addr = '02CAECBC', by looking at x$kgllk), ! hash and timestamp. Not sure why it's not shown. namespace=CRSR flags=RON/KGHP/PN0/[10010000] ! library cache object type: cursor ! Guess of flags: RON=read only; "isn't stored within the parent structure"? ! KGHP=KG layer heap, PN0=heap 0 pinned ! Other possible flags: BRO=broken ! Ref: www.freelists.org/archives/oracle-l/04-2004/msg00704.html ! sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!501.entry ! sql.ru/forum/actualthread.aspx?tid=457444&pg=2 ! RON/KGHP/TIM/[00010000] read only ! REM/KGHP/TIM/[00020000] remote object ! KGHP/FIX/TIM/[00040000] fixed object ! KGHP/CGA/TIM/[00080000] object in CGA memory ! PKP/KGHP/TIM/[00100000] permanently kept object ! KGHP/TIM/OBS/[00400000] has been marked obsolete ! KGHP/TIM/KEP/[00800000] is marked to be kept in the shared pool ! SEC/KGHP/TIM/[01000000] this object is secondary ! KGHP/TIM/SML/[02000000] SML/MED/LRG: small/medium/large indicates size of the handle ! KGHP/TIM/FUL/[04000000] object should be freed upon unlock ! KGHP/TIM/FUP/[08000000] object should be freed upon unpin ! KGHP/TIM/PN0/[10000000] heap 0 should be kept pinned as long as any user has a lock on the handle ! KGHP/TIM/USE/[20000000] in use (do not unpin) ! sunmoonking.spaces.live.com/blog/cns!E3BD9CBED01777CA!501.entry ! TIM valid timestamp; PTM has logged a previous timestamp ! OBS has been marked obsolete; KEP is marked to be kept in the shared pool; ! FUL/FUP object should be freed upon unlock or unpin; PN0 heap 0 should be ! kept pinned as long as any user has a lock on the handle; SML/MED/LRG small ! /medium/large indicates size of the handle; SEC: this object is secondary kkkk-dddd-llll=0000-0041-0041 lock=N pin=S latch=0 ! kkkk: kept; dddd: loaded; llll: ever loaded ! 0x41=1000001[bin], heap 0 and 6 loaded ! Null mode lock, Shared mode pin, no latch held lwt=2ebd3fc[2ebd3fc,2ebd3fc] ltm=2ebd404[2ebd404,2ebd404] pwt=2ebd414[2ebd414,2ebd414] ptm=2ebd46c[2ebd46c,2ebd46c] ref=2ebd3ec[2ebc7c8,2ebc7c8] lnd=2ebd478[2ebd478,2ebd478] ! These acronyms are linked lists for lock waiter, pin waiter, reference ! l: lock; tm: temporary; p: pin LIBRARY OBJECT: object=2ebc3b0 type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0 ! EXS: exist; NEX: not exist. There's no load lock. DATA BLOCKS: data# heap pointer status pins change ----- -------- -------- ------ ---- ------ 0 2ebc5b8 2ebb7f4 I/P/A 0 NONE 6 2ebc444 2eba7d4 I/P/A 1 NONE ---------------------------------------- ! SQL (not PL/SQL) cursors can only have heaps 0 and 6. ! Heap means heap descriptor; may be found in HEAP DUMP section; see e.g. 2ebc444 below, ! or in a separate heap dump at level 2 (SGA) ! Status is initialized, pinned, allocated. No pin. SO: 2d89974, type: 35, owner: 2cb9d40, flag: INIT/-/-/0x00 LIBRARY OBJECT LOCK: lock=2d89974 handle=2ebc858 mode=N call pin=2d8a8f8 session pin=0 user=2cb9d40 session=2cb9d40 count=1 flags=[00] savepoint=8695 LIBRARY OBJECT HANDLE: handle=2ebc858 name=alter session set events 'immediate trace name processstate level 10' hash=3ea15424 timestamp=08-11-2001 16:07:56 namespace=CRSR flags=RON/KGHP/TIM/PN0/MED/[50010000] kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=0 lwt=2ebc870[2ebc870,2ebc870] ltm=2ebc878[2ebc878,2ebc878] pwt=2ebc888[2ebc888,2ebc888] ptm=2ebc8e0[2ebc8e0,2ebc8e0] ref=2ebc860[2ebc860,2ebc860] lnd=2ebc8ec[2ebc8ec,2ebc8ec] LIBRARY OBJECT: object=2ebc640 type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0 CHILDREN: size=16 child# table reference handle ------ -------- --------- -------- 0 2ebc7fc 2ebc7c8 2ebd3e4 DATA BLOCKS: data# heap pointer status pins change ----- -------- -------- ------ ---- ------ 0 2ebd490 2ebc6c4 I/P/A 0 NONE ---------------------------------------- SO: 2d89cf8, type: 35, owner: 2cb9d40, flag: INIT/-/-/0x00 LIBRARY OBJECT LOCK: lock=2d89cf8 handle=2eb49d8 mode=N call pin=2d8ad30 session pin=0 user=2cb9d40 session=2cb9d40 count=1 flags=[00] savepoint=8452 LIBRARY OBJECT HANDLE: handle=2eb49d8 name=SYS.DBMS_APPLICATION_INFO hash=fcfd1282 timestamp=04-15-2001 22:58:49 namespace=BODY/TYBD flags=KGHP/TIM/SML/[02000000] kkkk-dddd-llll=0000-0011-0011 lock=N pin=0 latch=0 lwt=2eb49f0[2eb49f0,2eb49f0] ltm=2eb49f8[2eb49f8,2eb49f8] pwt=2eb4a08[2eb4a08,2eb4a08] ptm=2eb4a60[2eb4a60,2eb4a60] ref=2eb49e0[2eb49e0,2eb49e0] lnd=2eb4a6c[2eb4a6c,2eb4a6c] LIBRARY OBJECT: object=2eb4754 type=PKBD flags=EXS/LOC[0005] pflags=NST/SWR [09] status=VALD load=0 DEPENDENCIES: count=2 size=16 ACCESSES: count=1 size=16 DATA BLOCKS: data# heap pointer status pins change ----- -------- -------- ------ ---- ------ 0 2eb4968 2eb4838 I/-/A 0 NONE 4 2eb47e8 2ebf514 I/-/A 0 NONE ---------------------------------------- SO: 2d89b54, type: 35, owner: 2cb9d40, flag: INIT/-/-/0x00 LIBRARY OBJECT LOCK: lock=2d89b54 handle=2eb8b58 mode=N call pin=2d8ab38 session pin=0 user=2cb9d40 session=2cb9d40 count=1 flags=[00] savepoint=8343 LIBRARY OBJECT HANDLE: handle=2eb8b58 name=SYS.DBMS_APPLICATION_INFO hash=fcfd1281 timestamp=04-15-2001 22:57:58 namespace=TABL/PRCD/TYPE flags=KGHP/TIM/SML/[02000000] kkkk-dddd-llll=0000-0215-0215 lock=N pin=0 latch=0 lwt=2eb8b70[2eb8b70,2eb8b70] ltm=2eb8b78[2eb8b78,2eb8b78] pwt=2eb8b88[2eb8b88,2eb8b88] ptm=2eb8be0[2eb8be0,2eb8be0] ref=2eb8b60[2eb8b60,2eb8b60] lnd=2eb8bec[2d6f0f0,2eb97dc] LIBRARY OBJECT: object=2eb89b8 type=PCKG flags=EXS/LOC[0005] pflags= [00] status=VALD load=0 DEPENDENCIES: count=1 size=16 DATA BLOCKS: data# heap pointer status pins change ----- -------- -------- ------ ---- ------ 0 2eb8ae8 2eb8a9c I/-/A 0 NONE 2 2eb8a4c 2eb8134 I/-/A 0 NONE 4 2eb8324 2eb4364 I/-/A 0 NONE 9 2eb82c4 2eb42f0 I/-/A 0 NONE ---------------------------------------- SO: 2d89a64, type: 35, owner: 2cb9d40, flag: INIT/-/-/0x00 LIBRARY OBJECT LOCK: lock=2d89a64 handle=2ecb4a8 mode=N call pin=2d8aa18 session pin=0 user=2cb9d40 session=2cb9d40 count=1 flags=[00] savepoint=6621 LIBRARY OBJECT HANDLE: handle=2ecb4a8 name=SYS.DBMS_OUTPUT hash=5e736e8a timestamp=04-15-2001 22:59:02 namespace=BODY/TYBD flags=KGHP/TIM/SML/[02000000] kkkk-dddd-llll=0000-0011-0011 lock=N pin=0 latch=0 lwt=2ecb4c0[2ecb4c0,2ecb4c0] ltm=2ecb4c8[2ecb4c8,2ecb4c8] pwt=2ecb4d8[2ecb4d8,2ecb4d8] ptm=2ecb530[2ecb530,2ecb530] ref=2ecb4b0[2ecb4b0,2ecb4b0] lnd=2ecb53c[2ecb53c,2ecb53c] LIBRARY OBJECT: object=2ecb258 type=PKBD flags=EXS/LOC[0005] pflags=/SWR [08] status=VALD load=0 DEPENDENCIES: count=3 size=16 ACCESSES: count=1 size=16 DATA BLOCKS: data# heap pointer status pins change ----- -------- -------- ------ ---- ------ 0 2ecb438 2ecb33c I/-/A 0 NONE 4 2ecb2ec 2ed9e04 I/-/A 0 NONE ---------------------------------------- SO: 2d896e0, type: 35, owner: 2cb9d40, flag: INIT/-/-/0x00 LIBRARY OBJECT LOCK: lock=2d896e0 handle=2ecdd98 mode=N call pin=2d8a5e0 session pin=0 user=2cb9d40 session=2cb9d40 count=1 flags=[00] savepoint=6512 LIBRARY OBJECT HANDLE: handle=2ecdd98 name=SYS.DBMS_OUTPUT hash=5e736e89 timestamp=04-15-2001 22:58:01 namespace=TABL/PRCD/TYPE flags=KGHP/TIM/SML/[02000000] kkkk-dddd-llll=0000-0215-0215 lock=N pin=0 latch=0 lwt=2ecddb0[2ecddb0,2ecddb0] ltm=2ecddb8[2ecddb8,2ecddb8] pwt=2ecddc8[2ecddc8,2ecddc8] ptm=2ecde20[2ecde20,2ecde20] ref=2ecdda0[2ecdda0,2ecdda0] lnd=2ecde2c[2ed4fb8,2ecfa18] LIBRARY OBJECT: object=2ecdbf8 type=PCKG flags=EXS/LOC[0005] pflags=NST [01] status=VALD load=0 DEPENDENCIES: count=1 size=16 DATA BLOCKS: data# heap pointer status pins change ----- -------- -------- ------ ---- ------ 0 2ecdd28 2ecdcdc I/-/A 0 NONE 2 2ecdc8c 2ecd368 I/-/A 0 NONE 4 2ecd564 2f3738c I/-/A 0 NONE 9 2ecd504 2ecc4d4 I/-/A 0 NONE ---------------------------------------- SO: 2d89cbc, type: 35, owner: 2cb9d40, flag: INIT/-/-/0x00 LIBRARY OBJECT LOCK: lock=2d89cbc handle=2f659bc mode=N call pin=2d8ace8 session pin=0 user=2cb9d40 session=2cb9d40 count=1 flags=CBB/[02] savepoint=2170 LIBRARY OBJECT HANDLE: handle=2f659bc name=SYS.DATABASE hash=aea96fa0 timestamp=12-31-4712 23:59:59 namespace=EVNT flags=KGHP/TIM/SML/[02000000] kkkk-dddd-llll=0000-0009-0009 lock=N pin=0 latch=0 lwt=2f659d4[2f659d4,2f659d4] ltm=2f659dc[2f659dc,2f659dc] pwt=2f659ec[2f659ec,2f659ec] ptm=2f65a44[2f65a44,2f65a44] ref=2f659c4[2f659c4,2f659c4] lnd=2f65a50[2f65a50,2f65a50] LIBRARY OBJECT: object=2f657a4 type=EVNT flags=EXS/LOC[0005] pflags= [00] status=VALD load=0 DATA BLOCKS: data# heap pointer status pins change ----- -------- -------- ------ ---- ------ 0 2f64170 2f65888 I/-/A 0 NONE 3 2f65838 2f62ae4 I/-/A 0 NONE ---------------------------------------- SO: 2d89d34, type: 35, owner: 2cb9d40, flag: INIT/-/-/0x00 LIBRARY OBJECT LOCK: lock=2d89d34 handle=2f40e0c mode=N call pin=2d8ad78 session pin=0 user=2cb9d40 session=2cb9d40 count=1 flags=CBB/[02] savepoint=2161 LIBRARY OBJECT HANDLE: handle=2f40e0c name=YONG.YONG hash=e25c1fbf 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=0 lwt=2f40e24[2f40e24,2f40e24] ltm=2f40e2c[2f40e2c,2f40e2c] pwt=2f40e3c[2f40e3c,2f40e3c] ptm=2f40e94[2f40e94,2f40e94] ref=2f40e14[2f40e14,2f40e14] lnd=2f40ea0[2f40ea0,2f40ea0] LIBRARY OBJECT: object=2f40b94 type=EVNT flags=EXS/LOC[0005] pflags= [00] status=VALD load=0 DATA BLOCKS: data# heap pointer status pins change ----- -------- -------- ------ ---- ------ 0 2f40d9c 2f40c78 I/-/A 0 NONE 3 2f40c28 2f40808 I/-/A 0 NONE ---------------------------------------- SO: 2f595a4, type: 34, owner: 2cb9d40, pt: 0, flag: INIT/-/-/0x00 user lock: lock=2f595a4 mode=S user resource: user=2d8e0c4 uid=25 mode=S ---------------------------------------- SO: 2f74b34, type: 34, owner: 2cb9d40, pt: 0, flag: INIT/-/-/0x00 user lock: lock=2f74b34 mode=S user resource: user=2d8e0c4 uid=25 mode=S ---------------------------------------- SO: 2cfd430, type: 9, owner: 2caecbc, pt: 0, flag: INIT/-/-/0x00 (broadcast handle) flag: (2) ACTIVE SUBSCRIBER, owner: 2caecbc, event: 9, last message event: 9, messages read: 0 channel: (2cfd558) system events broadcast channel scope: 101, event: 9, last mesage event: 0, publishers/subscribers: 0/7, messages published: 0 ---------------------------------------- SO: 2ccb658, type: 2, owner: 2caecbc, pt: 0, flag: INIT/-/-/0x00 (call) sess: cur 2cb9d40, rec 0, usr 2cb9d40; depth: 0 =================================================== CURRENT SESSION'S INSTANTIATION STATE ------------------------------------- current session=2cb9d40 ------------------------------------- INSTANTIATION OBJECT: object=47b3030 type="PL/SQL"[0] lock=2d89cf8 handle=2eb49d8 spec=47b2ec4 level=0 flags=SHR/BDY/FST[63] executions=3 ! If SHaRed, executions must be > 0 REST OF INSTANTIATION OBJECT: address=47b307c size=72 0000001b 047b2ec4 0014ada8 00000000 047ad120 00000000 00140000 00000014 02ebf61c 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 ------------------------------------- INSTANTIATION OBJECT: object=47b2ec4 type="PL/SQL"[0] lock=2d89b54 handle=2eb8b58 body=47b3030 level=0 flags=SHR/[01] executions=6 REST OF INSTANTIATION OBJECT: address=47b2f10 size=72 ffffffff 047b2ec4 0014ada8 00000000 047ada5c 00000000 00130000 00000013 02eb446c 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 ------------------------------------- INSTANTIATION OBJECT: object=47b2f64 type="PL/SQL"[0] lock=2d89a64 handle=2ecb4a8 spec=47ac0c4 level=0 flags=SHR/BDY/FST[63] executions=1 REST OF INSTANTIATION OBJECT: address=47b2fb0 size=72 ffffffff 047ac0c4 0014ada8 00000000 047b1814 00000000 00120000 00000012 02ed9f0c 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 ------------------------------------- INSTANTIATION OBJECT: object=47ac0c4 type="PL/SQL"[0] lock=2d896e0 handle=2ecdd98 body=47b2f64 level=0 flags=SHR/[41] executions=2 REST OF INSTANTIATION OBJECT: address=47ac110 size=72 ffffffff 047ac0c4 0014ada8 00000000 047b2150 00000000 00110000 00000011 02f37494 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 ------------------------------------- INSTANTIATION OBJECT: object=47a6670 type="KOKA open cursor"[3] lock=0 handle=0 body=0 level=0 flags=FST[60] executions=0 ! If FirST time, executions must be 0 REST OF INSTANTIATION OBJECT: address=47a66bc size=12 00000000 00000005 0000000a ------------------------------------- INSTANTIATION OBJECT: object=47aa130 type="KOKA pseudo cursor"[4] lock=0 handle=0 body=0 level=0 flags=FST[60] executions=0 REST OF INSTANTIATION OBJECT: address=47aa17c size=12 00000000 00000005 0000000a ------------------------------------- INSTANTIATION OBJECT: object=47a904c type="cursor"[2] lock=2d89974 handle=2ebc858 body=0 level=0 flags=FST[60] executions=0 REST OF INSTANTIATION OBJECT: address=47a9098 size=356 02ebd3e4 02d895f0 02d8a4c0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00100064 04000408 00000000 00000000 00000000 00000000 00000000 00000000 047b3004 047a90fc 047b3004 00000002 00000000 00000000 00000000 047a63e0 00000000 047a6928 00000006 0000002a 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 047ab734 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000019 00000019 00000000 00000000 00000000 00000000 00000000 047a76ac 00000000 00000000 00000000 00000000 00000000 ******************** Cursor Dump ************************ Current cursor: 1, pgadep: 0 pgactx: 2eba7d4 ctxcbk: 2eba960 ctxqbc: 0 ctxrws: 0 Cursor Dump: ---------------------------------------- Cursor 1 (47a6928): CURBOUND curiob: 47a904c !CURBOUND is cursor status (as in v$sql_cursor), "there were bind variables and they are now defined" !curiob: cursor instantiation object curflg: 4c curpar: 0 curusr: 0 curses 2cb9d40 cursor name: alter session set events 'immediate trace name processstate level 10' child pin: 2d8a4c0, child lock: 2d895f0, parent lock: 2d89974 xscflg: 100064, parent handle: 2ebc858, xscfl2: 4000408 nxt: 1.0x000000a4 Cursor frame allocation dump: frm: -------- Comment -------- Size Seg Off End of cursor dump ***************** dump of cursor xsc=47a904c ********************** ------------- dump of ephemeral frame ------------------ Frame #1 offset #16 Dump of memory from 0x47A0060 to 0x47A0104 47A0060 000000A4 00000400 00000000 00000000 [................] 47A0070 00000000 00000000 00000000 00000000 [................] 47A0080 00000000 00000001 00000001 00000000 [................] 47A0090 00000000 00000000 00000000 00000000 [................] Repeat 1 times 47A00B0 00000000 00000000 00000000 047A76AC [.............vz.] 47A00C0 00000000 00000000 00000000 00000000 [................] Repeat 1 times 47A00E0 000021F8 00000000 00000000 00000000 [.!..............] 47A00F0 00000000 00000000 00000000 00000000 [................] 47A0100 00000000 [....] ------------- dump of persistent frame ------------------ Frame #1 offset #16 Dump of memory from 0x47A63E0 to 0x47A63E8 47A63E0 00000008 00000000 [........] ------------- dump of shared cursor ------------------ ****************************************************** HEAP DUMP heap name="sql area" desc=0x2ebc444 extent sz=0x1024 alt=32767 het=8 rec=0 flg=2 opc=5 parent=139d420 owner=2ebc3b0 nex=0 xsz=0x0 EXTENT 0 Chunk 2eba7c4 sz= 2240 perm "perm " alo=532 2EBA7C0 500008C1 00000000 00000000 [...P........] 2EBA7D0 00000214 00000010 00000004 00000010 [................] 2EBA7E0 00000004 00000000 00000000 00000000 [................] 2EBA7F0 00000000 00000000 00000000 00000000 [................] Repeat 1 times 2EBA810 00000000 00000000 02EBA960 02EBA93C [........`...<...] 2EBA820 00000000 00000000 00000110 0000002A [............*...] 2EBA830 00000000 00000000 00000000 00000000 [................] Repeat 1 times 2EBA850 00000000 00000000 00000000 02EBA91C [................] 2EBA860 00000000 00000000 00000000 02EBA92C [............,...] 2EBA870 00000000 00000000 00000000 00000000 [................] 2EBA880 00000000 00000000 00000000 02EBB884 [................] 2EBA890 00000000 00000000 00000000 00000000 [................] Repeat 3 times 2EBA8D0 00000000 0000002F 00000000 00000000 [..../...........] 2EBA8E0 00000000 00000000 00000000 00000000 [................] Repeat 3 times 2EBA920 00000005 00000001 000000A4 00000000 [................] 2EBA930 00000001 00000001 00000008 474E4F59 [............YONG] 2EBA940 00000000 00000000 00000000 00000000 [................] 2EBA950 00000000 00000000 00040000 00000019 [................] 2EBA960 00000103 00000000 0000001A 0000002A [............*...] 2EBA970 00000000 02EBA97C 00000047 65746C61 [....|...G...alte] 2EBA980 65732072 6F697373 6573206E 76652074 [r session set ev] ! The way of reading memory dump: within each word (4 bytes, 32 bits), read from ! right to left if you're using a little-ending machine (Intel e.g.); e.g. ! ascii's for s,s,i,o are 73,73,69,6F, respectively 2EBA990 73746E65 6D692720 6964656D 20657461 [ents 'immediate ] 2EBA9A0 63617274 616E2065 7020656D 65636F72 [trace name proce] 2EBA9B0 74737373 20657461 6576656C 3031206C [ssstate level 10] 2EBA9C0 00000A27 3EEEEEEE 00000000 02EBA7C4 ['......>........] 2EBA9D0 02EBA9D0 02EBA9D0 00000000 00000000 [................] 2EBA9E0 00000000 00000000 00000000 00000000 [................] Repeat 5 times 2EBAA40 00000000 00000000 00020000 00070005 [................] 2EBAA50 00060001 00090002 0002000E 00070005 [................] 2EBAA60 00000000 00000000 00000000 00000000 [................] Repeat 29 times 2EBAC40 00000000 02EBACC4 00000000 00000000 [................] 2EBAC50 00000000 00000000 00000000 00000000 [................] Repeat 6 times 2EBACC0 00000000 00000000 00000065 00000065 [........e...e...] 2EBACD0 00000041 00030004 00030008 00030008 [A...............] 2EBACE0 00000000 00000000 00000000 00000000 [................] Repeat 57 times 2EBB080 00000000 [....] Total heap size = 2240 FREE LISTS: Bucket 0 size=0 Total free space = 0 UNPINNED RECREATABLE CHUNKS (lru first): PERMANENT CHUNKS: Chunk 2eba7c4 sz= 2240 perm "perm " alo=532 ! 2eba7c4: beginning of heap; only one heap in this case Permanent space = 2240 MARKS: Mark 2eba9c4 ! Not sure why there's a mark here. It corresponds to the closing single quote of ! the alter session SQL statement in heap shown above ****************************************************** END OF PROCESS STATE SEE ALSO Understanding and Reading Systemstates https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=BULLETIN&id=423153.1