SQL query Result Cache
You can store the results of a SQL query in the SQL query result cache in three ways:
- Enabling automatic result cache at the database level: Automatic SQL result caching is enabled by setting the initialization parameter
FORCE, which enforces caching for all the SQL statements. However, you can prevent specific SQL queries from exhausting the Server Result Cache by using the
- Enabling automatic result cache at the table level: You can set
FORCEfor a particular table so that the results from the queries on this table will be cached in the query result cache.
ALTER TABLE my_objects RESULT_CACHE (MODE FORCE) /
You can specify a
NO_RESULT_CACHEhint to avoid the cache ...