session cursor dump - cheeyoung/sqlplus-public GitHub Wiki
*** CLIENT DRIVER:(jdbcthin : 18.3.0.0.0) 2020-03-10T09:33:55.272289+09:00
Received ORADEBUG command (#2) 'dump errorstack 3' from process '13582'
*** 2020-03-10T09:33:55.272425+09:00
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=3, mask=0x0)
----- Error Stack Dump -----
----- Current SQL Statement for this session (sql_id=3d5z8tkjc3xz6) -----
.
.
.
----- Session Cursor Dump -----
Current cursor: 1, pgadep=0
Open cursors(pls, sys, hwm, max): 2(0, 1, 64, 2000)
NULL=0 SYNTAX=0 PARSE=0 BOUND=1 FETCH=1 ROW=0
...
----- Plan Table -----
============
Plan Table
============
----------------------------------------------------------+-----------------------------------+---------------+
| Id | Operation | Name | Rows | Bytes | Cost | Time | Pstart| Pstop |
----------------------------------------------------------+-----------------------------------+---------------+
...
----------------------------------------------------------+-----------------------------------+---------------+
Column Projection Information (identified by operation id):
-----------------------------------------------------------
...
Compilation Environment Dump
...
----- Binary dump of xsc -----
...
----- Binary dump of ctxdef -----
...
----- Binary dump of run-time heap -----
******************************************************
HEAP DUMP heap name="SQLA^a2c1f7e6" desc=0x1079df4a98
extent sz=0xfe8 alt=32767 het=608 rec=0 flg=0x2 opc=0
parent=0x60114468 owner=0x1079df4948 nex=(nil) xsz=0xfe8 heap=(nil)
...
----- Binary dump of heap 0 -----
******************************************************
HEAP DUMP heap name="KGLH0^a2c1f7e6" desc=0x107d79c158
extent sz=0xfe8 alt=32767 het=56 rec=9 flg=0x2 opc=0
parent=0x60114468 owner=0x107d79c108 nex=(nil) xsz=0xfe8 heap=(nil)
...
******************************************************
----- Session Open Cursors -----
----------------------------------------
...
----------------------------------------
Cursor#1(0x7ffff30b2778) state=FETCH curiob=0x7ffff30d0b78
curflg=0x46 fl2=0x0 fl3=0x0 par=(nil) ses=0x18e4954028
----- Dump Cursor sql_id=3d5z8tkjc3xz6 xsc=0x7ffff30d0b78 cur=0x7ffff30b2778 -----
LibraryHandle: Address=0xf8ecad7c8 Hash=a2c1f7e6 LockMode=N PinMode=0 LoadLockMode=0 Status=VALD
ObjectName: Name=
SELECT ...
...
FullHashValue=a91707787c0374663697e8cca2c1f7e6 Namespace=SQL AREA(00) Type=CURSOR(00) ContainerId=0 ContainerUid=0 Identifier=2730620902 OwnerIdn=91
Statistics: InvalidationCount=0 ExecutionCount=2 LoadCount=2 ActiveLocks=1 TotalLockCount=3 TotalPinCount=1
Counters: BrokenCount=1 RevocablePointer=1 KeepDependency=1 Version=0 BucketInUse=1 HandleInUse=1 HandleReferenceCount=0
Concurrency: DependencyMutex=0xf8ecad878(0, 1322, 0, 0) Mutex=0xf8ecad918(0, 19683, 0, 0)
Flags=RON/PIN/TIM/PN0/DBN/[10012841] Flags2=[0000]
WaitersLists:
Lock=0xf8ecad858[0xf8ecad858,0xf8ecad858]
Pin=0xf8ecad838[0xf8ecad838,0xf8ecad838]
LoadLock=0xf8ecad8b0[0xf8ecad8b0,0xf8ecad8b0]
Timestamp: Current=03-01-2020 06:00:05
HandleReference: Address=0xf8ecae8d0 Handle=(nil) Flags=[00]
LibraryObject: Address=0x1079df4370 HeapMask=0000-0001-0001-0000 Flags=EXS[0000] Flags2=[0000] Flags3=[0000] PublicFlags=[0000]
ChildTable: size='16'
Child: id='0' Table=0x1079df51f0 Reference=0x1079df4ce8 Handle=0xf90507c08
...
----- Bind Info (kkscoacd) -----
Bind#0
oacdty=01 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1000010 frm=01 csi=846 siz=160 off=0
kxsbbbfp=7ffff30d2a10 bln=32 avl=08 flg=05
value="20200201"
Bind#1
oacdty=01 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1000010 frm=01 csi=846 siz=0 off=32
kxsbbbfp=7ffff30d2a30 bln=32 avl=08 flg=01
value="20200201"
Bind#2
oacdty=01 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1000010 frm=01 csi=846 siz=0 off=64
kxsbbbfp=7ffff30d2a50 bln=32 avl=08 flg=01
value="20200231"
Bind#3
oacdty=01 mxl=32(02) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1000010 frm=01 csi=846 siz=0 off=96
kxsbbbfp=7ffff30d2a70 bln=32 avl=01 flg=01
value="5"
Bind#4
oacdty=01 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1000010 frm=01 csi=846 siz=0 off=128
kxsbbbfp=7ffff30d2a90 bln=32 avl=08 flg=01
value="20200231"
Incarnation curinc=1 instinc=1 curpdbinc=1 pdbinc=1
Frames pfr 0x7ffff30d2e58 siz=48920 efr 0x7ffff30d2cb8 siz=48888
Cursor frame dump
...
Starting SQL statement dump
SQL Information
user_id=91 user_name=... module=... action=...
sql_id=3d5z8tkjc3xz6 plan_hash_value=-1200608207 problem_type=4
----- Current SQL Statement for this session (sql_id=3d5z8tkjc3xz6) -----
SELECT ...
...
Compilation Environment Dump
...
Fine-Grained Invalidation state dump:
fine-grained dependencies:
...
cursor refresh state:
...
====================== END SQL Statement Dump ======================
----- Session Cached Cursor Dump -----
----- Generic Session Cached Cursor Dump -----
-----------------------------------------------------------
-------------- Generic Session Cached Cursors Dump --------
-----------------------------------------------------------
hash table=0x7ffff30b51f8 cnt=0 LRU=0x7ffff3099830 cnt=0 hit=38 max=200 share=Y NumberOfTypes=7
...
-----------------------------------------------------------
------Finished Dumping Generic Session Cached Cursors------
-----------------------------------------------------------
----- RDBMS Session Cached Cursor Dump -----
Symbolic dump of process state object:
...
KSFD PGA DUMPS
Number of completed I/O requests=0 flags=48
Dumping DGA FOB Allocations in current thread
(FOB) flags=0x90000502 fib=0x1767980c48 incno=4 libidx=0 pending i/o cnt=0
owner pid=3503 Consolidated FOB magic=0xbabcdefa
fname=+.../.../DATAFILE/system.260.987254189
fno=1 lblksz=8192 fsiz=3974400
...
Dumping Shareable Consolidated DGA FOB Allocations in Oracle Server Process
======= skgfdfdtr: Dump of process open file descriptors =======
fd=/proc/self/fd/0 File=/dev/null
fd=/proc/self/fd/1 File=/dev/null
fd=/proc/self/fd/2 File=/dev/null
fd=/proc/self/fd/3 File=/dev/null
fd=/proc/self/fd/4 File=socket:[757307496]
fd=/proc/self/fd/5 File=/proc/16012/fd
fd=/proc/self/fd/6 File=socket:[757307497]
...
KSFDRQ LIST DUMP
Dumping requests in repop wait list
Dumping information on ODM library configured=1 odmid=abcdefab odmfeature=0
ODM library index=0 version=16 id=2882400171 feature=1 pbsz=512
ODM dllctx=0x7ffff7f12c00 dllhandle=0x7ffff7f12978
...