Need advice about Result Cache size allocation

From: Michael Moore <michaeljmoore_at_gmail.com>
Date: Wed, 30 Mar 2011 12:49:47 -0700
Message-ID: <AANLkTimq21z4_5Mn=zNZHOmv-DLTMNYVfbZ6JmwOOwTm_at_mail.gmail.com>

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  = 10M bytes (10K blocks)
Maximum Result Size = 512K bytes (512 blocks)

[Memory]
Total Memory = 8147504 bytes [0.501% of the Shared Pool]

... Fixed Memory = 5352 bytes [0.000% of the Shared Pool]


....... Memory Mgr = 200 bytes

....... Cache Mgr  = 208 bytes

....... Bloom Fltr = 2K bytes

....... State Objs = 2896 bytes

... Dynamic Memory = 8142152 bytes [0.500% of the Shared Pool]

....... Overhead = 146760 bytes

........... Hash Table    = 64K bytes (4K buckets)
........... Chunk Ptrs    = 24K bytes (3K slots)
........... Chunk Maps    = 12K bytes
........... Miscellaneous = 44360 bytes

....... Cache Memory = 7808K bytes (7808 blocks)

........... Unused Memory = 0 blocks
........... Used Memory = 7808 blocks
............... Dependencies = 5 blocks (5 count)
............... Results = 7803 blocks
................... PLSQL   = 1 blocks (1 count)
................... Invalid = 7802 blocks (7802 count)

PL/SQL procedure successfully completed.

How can I tell if the DBA's have allocated enough space?

Regards,
Mike

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Mar 30 2011 - 14:49:47 CDT