Need advice about Result Cache size allocation
- From: Michael Moore <michaeljmoore@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 30 Mar 2011 12:49:47 -0700
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
Other related posts: