X hits on this document

102 views

0 shares

0 downloads

0 comments

26 / 38

26

juliandyke.com

© 2007 Julian Dyke

Result Cache Subheap Dump

Result Cache sub heap can be dumped using:

HEAP DUMP heap name="Result Cache"  desc=0x36fc1e78 extent sz=0x8024 alt=32767 het=32767 rec=0 flg=2 opc=2 parent=0x200010b4 owner=(nil) nex=(nil) xsz=0x8024 heap=(nil) fl2=0x20, nex=(nil) EXTENT 0 addr=0x31db6448  Chunk 31db6450 sz=    32796    perm      "perm           "  alo=32784 Dump of memory from 0x31DB6450 to 0x31DBE46C 31DB6450 5000801D 00000000 31DBE480 00008010  [...P.......1....] 31DB6460 00000000 31DB6460 00000000 00000002  [....`d.1........] 31DB6470 31DBFF40 31DBFF40 36FC1F38 36FC1F38  [@..1@..18..68..6] 31DB6480 00000002 76C9A356 AD55D9D8 0015838E  [....V..v..U.....] 31DB6490 00000000 00000000 00000053 11096B78  [........S...xk..] 31DB64A0 000B1711 0001132E 00000000 00070000  [................] 31DB64B0 00000001 31DB6860 00000000 00000000  [....`h.1........] 31DB64C0 00000000 00000000 00000000 00000000  [................]        Repeat 57 times etc...

ALTER SESSION SET EVENTS

'immediate trace name heapdump_addr level 2, addr 0x36fc1e78';

For example:

Document info
Document views102
Page views102
Page last viewedThu Dec 08 04:41:22 UTC 2016
Pages38
Paragraphs703
Words2667

Comments