-----
Cursor#3(0x2b2949861aa0) state=BOUND curiob=0x2b294987c908
curflg=d fl2=200000 par=(nil) ses=0x2a5a2fe30
----- Dump Cursor sql_id=aykvshm7zsabd xsc=0x2b294987c908 cur=0x2b2949861aa0 -----
Dump Parent Cursor sql_id=aykvshm7zsabd phd=0x2a3536398 plk=0x2a38f6a20
sqltxt(0x2a3536398)=select size_for_estimate, size_factor * 100 f, estd_physical_read_time, estd_physical_reads from v$db_cache_advice where id = '3'
hash=e6a0c9e759694930af4b7884cffc296d
parent=0x287fdec20 maxchild=01 plk=0x2a38f6a20 ppn=n
cursor instantiation=0x2b294987c908 used=1388471003 exec_id=0 exec=0
child#0(0x2a35361b8) pcs=0x287fde278
clk=0x2a38f6898 ci=0x287fddf18 pn=0x2a3537e78 ctx=0x283fa0f90
kgsccflg=0 llk[0x2b294987c910,0x2b294987c910] idx=0
xscflg=100076 fl2=40000000 fl3=22004 fl4=100
Frames pfr (nil) siz=7176 efr (nil) siz=7160
Cursor frame dump
enxt: 3.0x00000b78 enxt: 2.0x00000250 enxt: 1.0x00000e30
pnxt: 1.0x00000010
----------------------------------------
Cursor#4(0x2b2949861b30) state=BOUND curiob=0x2b294987c5c8
curflg=d fl2=200000 par=(nil) ses=0x2a5a2fe30
----- Dump Cursor sql_id=772s25v1y0x8k xsc=0x2b294987c5c8 cur=0x2b2949861b30 -----
Dump Parent Cursor sql_id=772s25v1y0x8k phd=0x2a3533e18 plk=0x2a35385a8
sqltxt(0x2a3533e18)=select shared_pool_size_for_estimate s, shared_pool_size_factor * 100 f, estd_lc_load_time l, 0 from v$shared_pool_advice
hash=ae5675c671b365c6738b022ec3e07512
parent=0x287fd7f88 maxchild=01 plk=0x2a35385a8 ppn=n
cursor instantiation=0x2b294987c5c8 used=1388471003 exec_id=0 exec=0
child#0(0x2a3533c38) pcs=0x287fd75e0
clk=0x2a35384b0 ci=0x287fd7280 pn=0x2a3537eb0 ctx=0x283f872c0
kgsccflg=0 llk[0x2b294987c5d0,0x2b294987c5d0] idx=0
xscflg=100076 fl2=40000000 fl3=22004 fl4=100
Frames pfr (nil) siz=2120 efr (nil) siz=2104
Cursor frame dump
Frames pfr (nil) siz=2120 efr (nil) siz=2104
Cursor frame dump
enxt: 2.0x000000b8 enxt: 1.0x00000780
pnxt: 1.0x00000010
----------------------------------------
Cursor#5(0x2b2949861bc0) state=BOUND curiob=0x2b294987c288
curflg=d fl2=200000 par=(nil) ses=0x2a5a2fe30
----- Dump Cursor sql_id=g6gu1n3x0h1h4 xsc=0x2b294987c288 cur=0x2b2949861bc0 -----
Dump Parent Cursor sql_id=g6gu1n3x0h1h4 phd=0x2a35326d8 plk=0x2a35383b8
sqltxt(0x2a35326d8)=select streams_pool_size_for_estimate s, streams_pool_size_factor * 100 f, estd_spill_time + estd_unspill_time, 0 from v$streams_pool_advice
hash=78ee9a4289ed2031f33f41a0fa080604
parent=0x287fd2450 maxchild=01 plk=0x2a35383b8 ppn=n
cursor instantiation=0x2b294987c288 used=1388471003 exec_id=0 exec=0
child#0(0x2a35324f8) pcs=0x287fd1aa8
clk=0x2a35382c0 ci=0x287fd1748 pn=0x2a3537ee8 ctx=0x283f79000
kgsccflg=0 llk[0x2b294987c290,0x2b294987c290] idx=0
xscflg=100076 fl2=40000000 fl3=22004 fl4=100
Frames pfr (nil) siz=2208 efr (nil) siz=2192
Cursor frame dump
enxt: 2.0x000000e8 enxt: 1.0x000007a8
pnxt: 1.0x00000010
----------------------------------------
Cursor#6(0x2b2949861c50) state=BOUND curiob=0x2b294987bf48
curflg=d fl2=200000 par=(nil) ses=0x2a5a2fe30
----- Dump Cursor sql_id=5yv7yvjgjxugg xsc=0x2b294987bf48 cur=0x2b2949861c50 -----
Dump Parent Cursor sql_id=5yv7yvjgjxugg phd=0x2a352b990 plk=0x2a3538138
sqltxt(0x2a352b990)=select TIME_WAITED_MICRO from V$SYSTEM_EVENT where event = 'Shared IO Pool Memory'
hash=b670d0be0c8dd4595f6c