Re: Need advice about Result Cache size allocation
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: michaeljmoore@xxxxxxxxx
- Date: Wed, 30 Mar 2011 21:08:30 +0100
I've not seen that report before but I'd be interested in what the invalid
results mean - looks like you have 1 valid cached result and 7802 invalid
cached results.
On Wed, Mar 30, 2011 at 8:49 PM, Michael Moore <michaeljmoore@xxxxxxxxx>wrote:
> 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
>
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
Other related posts:
