X hits on this document

89 views

0 shares

0 downloads

0 comments

17 / 38

17

juliandyke.com

© 2007 Julian Dyke

Result Cache DBMS_RESULT_CACHE Package

To print a detailed memory report use

SET SERVEROUTPUT ON EXECUTE DBMS_RESULT_CACHE.MEMORY_REPORT (TRUE);

... Fixed Memory = 5132 bytes [0.002% of the Shared Pool]                       ....... Cache Mgr  = 108 bytes                                                  ....... Memory Mgr = 124 bytes                                                  ....... Bloom Fltr = 2K bytes                                                   ....... State Objs = 2852 bytes                                                 ... Dynamic Memory = 98396 bytes [0.046% of the Shared Pool]                    ....... Overhead = 65628 bytes                                                  ........... Hash Table    = 32K bytes (4K buckets)                              ........... Chunk Ptrs    = 12K bytes (3K slots)                                ........... Chunk Maps    = 12K bytes                                           ........... Miscellaneous = 8284 bytes

Includes more detail for:

Fixed Memory

Dynamic Memory

Document info
Document views89
Page views89
Page last viewedSun Dec 04 13:20:35 UTC 2016
Pages38
Paragraphs703
Words2667

Comments