X hits on this document

86 views

0 shares

0 downloads

0 comments

16 / 38

16

juliandyke.com

© 2007 Julian Dyke

Result Cache DBMS_RESULT_CACHE Package

To print a summary memory report use

SET SERVEROUTPUT ON EXECUTE DBMS_RESULT_CACHE.MEMORY_REPORT;

R e s u l t   C a c h e   M e m o r y   R e p o r t                             [Parameters]                                                                    Block Size          = 1K bytes                                                  Maximum Cache Size  = 2080K bytes (2080 blocks)                                 Maximum Result Size = 104K bytes (104 blocks)                                   [Memory]                                                                        Total Memory = 103528 bytes [0.048% of the Shared Pool]                         ... Fixed Memory = 5132 bytes [0.002% of the Shared Pool]                       ... Dynamic Memory = 98396 bytes [0.046% of the Shared Pool]                    ....... Overhead = 65628 bytes                                                  ....... Cache Memory = 32K bytes (32 blocks)                                    ........... Unused Memory = 7 blocks                                            ........... Used Memory = 25 blocks                                             ............... Dependencies = 6 blocks (6 count)                                ............... Results = 19 blocks                                              ................... SQL     = 19 blocks (7 count)                               

Document info
Document views86
Page views86
Page last viewedSun Dec 04 04:00:36 UTC 2016
Pages38
Paragraphs703
Words2667

Comments