Re: Need advice about Result Cache size allocation

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Wed, 30 Mar 2011 21:08:30 +0100
Message-ID: <AANLkTin-6_4=ZFDuQVsbzh83MR8u-p0uQN5=C19C45Go_at_mail.gmail.com>

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_at_gmail.com>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

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

Received on Wed Mar 30 2011 - 15:08:30 CDT