Oracle result set Cache

Source: Internet
Author: User

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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.