Ellis, makes sense. I'll see If I can get that changed. Niall, thanks for the link, I'll check it out. Mike On Wed, Mar 30, 2011 at 2:24 PM, Niall Litchfield < niall.litchfield@xxxxxxxxx> wrote: > Hi Michael > > Thanks - possibly this article > http://www.oracle-developer.net/display.php?id=503 might give more help. > I'm afraid I don't know squat about result cache (other than what it is) to > help more, hence my earlier curiosity. A brief read of the docs suggests > that the designers of the feature expect developers to know how much and > what size is going to be cached. A brief read of the available blogs > suggests this might be optimistic. > > On Wed, Mar 30, 2011 at 9:15 PM, Michael Moore <michaeljmoore@xxxxxxxxx>wrote: > >> Niall, >> this produces the report. >> >> >> BEGIN >> SYS.DBMS_Result_Cache.Memory_Report(Detailed=>TRUE); >> END; >> / >> >> I just ran it again and the results are very different in the last two >> lines. >> >> 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 = 9657800 bytes [0.593% 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 = 9652448 bytes [0.593% of the Shared Pool] >> ....... Overhead = 149728 bytes >> ........... Hash Table = 64K bytes (4K buckets) >> ........... Chunk Ptrs = 24K bytes (3K slots) >> ........... Chunk Maps = 12K bytes >> ........... Miscellaneous = 47328 bytes >> ....... Cache Memory = 9280K bytes (9280 blocks) >> ........... Unused Memory = 29 blocks >> ........... Used Memory = 9251 blocks >> ............... Dependencies = 5 blocks (5 count) >> ............... Results = 9246 blocks >> ................... PLSQL = 9246 blocks (9246 count) >> PL/SQL procedure successfully completed. >> >> On Wed, Mar 30, 2011 at 1:08 PM, Niall Litchfield < >> niall.litchfield@xxxxxxxxx> wrote: >> >>> 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 >>> >> >> > > > -- > Niall Litchfield > Oracle DBA > http://www.orawin.info >