Tuning the Database - Expert Oracle RAC Performance Diagnostics and Tuning - page 305

If the PL/SQL function is executed again to retrieve the new result set from the database, a new row ( ID=6 ) is
added to the result cache section. Oracle Database retains the invalid result set ( ID=1 ) until the instance is bounced,
the result cache is flushed, or the data in the result cache ages out of the buffer. As noticed in the output below, other
statements are also executed (for example ID=5 ).
In the output above, the invalid result cache entry identified by ID=1 remains in buffer until such time the cache
area is required by another operation. This is also reflected in the DBMS_RESULT_CACHE output below.
SQL> execute DBMS_RESULT_CACHE.MEMORY_REPORT(TRUE);
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 = 14432K bytes (14432 blocks)
Maximum Result Size = 721K bytes (721 blocks)
[Memory]
Total Memory = 176312 bytes [0.035% of the Shared Pool]
... Fixed Memory = 12360 bytes [0.002% of the Shared Pool]
....... Memory Mgr = 208 bytes
....... Cache Mgr = 256 bytes
....... = 680 bytes
....... Bloom Fltr = 2K bytes
....... RAC Cbk = 6240 bytes
....... State Objs = 2928 bytes
... Dynamic Memory = 163952 bytes [0.033% of the Shared Pool]
....... Overhead = 131184 bytes
........... Hash Table = 64K bytes (4K buckets)
........... Chunk Ptrs = 24K bytes (3K slots)
........... Chunk Maps = 12K bytes
........... Miscellaneous = 131184 bytes
....... Cache Memory = 32K bytes (32 blocks)
........... Unused Memory = 25 blocks
........... Used Memory = 7 blocks
............... Dependencies = 4 blocks (4 count)
............... Results = 3 blocks
................... SQL = 1 blocks (1 count)
................... PLSQL = 1 blocks (1 count)
................... Invalid = 1 blocks (1 count)
PL/SQL procedure successfully completed.