Oracle result set cache: oracle adjusts the result set cache with only three parameters. RESULT_CACHE_MAX_SIZE = 500 M/* Megabytes RESULT_CACHE_MAX_RESULT = 20/* Percentage limit = 3600/* Minutes, but all queries are saved only when result_cache_mode is force, + HINT is required for enable in manual. alter session set result_cache_mode = force; show parameter result_cache name type value -------------------------------------- ------------------------------------ client_result_cache_lag big integer Explain big integer 0result_cache_max_result integer 5result_cache_max_size big integer 5984Kresult_cache_mode string explain integer 0 query memory allocation status SQL> SET SERVEROUTPUT ONSQL> execute limit e s u l t C a c h e M o r y R e p o r t [Parameters] Block Size = 1 K bytesMaximum Cache Size = 5984 K bytes (5984 blocks) maximum Resu Lt Size = 299 K bytes (299 blocks) [Memory] Total Memory = 174752 bytes [0.027% of the Shared Pool]... fixed Memory = 10696 bytes [0.002% of the Shared Pool]... dynamic Memory = 164056 bytes [0.026% of the Shared Pool] ...... overhead = 131288 bytes ....... cache Memory = 32 K bytes (32 blocks )........... unused Memory = 30 blocks ........... used Memory = 2 blocks ............... dependencies = 1 blocks (1 count )............... results = 1 blocks ................... SQL = 1 blocks (1 count) PL/SQL procedure successfully completed. it seems that only oracle has this thing, And neither DB2 nor mysql has it.