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 >