Oracle parameters that govern the behavior of the result cache are:
RESULT_CACHE_ |
Valid values are:
|
RESULT_CACHE_ MAX_RESULT |
The maximum percentage of memory in the result cache that can be used by any result set, and ensures that new result sets are small enough so that they do not force most existing cache entries out of the cache. Valid values can be any number between 1 and 100. The default value is usually 5. |
RESULT_CACHE_ MAX_SIZE |
The maximum size (measured in bytes) allocated to the Result Cache. If this is initially set to 0, the result cache is disabled. |
RESULT_CACHE_ REMOTE_EXPIRATION |
An Oracle parameter that specifies how long a query from a remote database should be retained in the result cache. |
Note: You can view the values of these parameters for the database under investigation in the Configuration & Memory | Oracle Parameters Page.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. 이용 약관 개인정보 보호정책 Cookie Preference Center