.
\nThe result cache is very nice when base tables are static: get the result without any buffer get, without any join or sorts. But as soon as any DML occurs on one of the tables the result is based on, then result cache is invalidated. And cache misses are quite expensive. You can think of it as a materialized view in memory. But with materialized views, you can accept to see stale results in order to avoid frequent refreshes. Let’s see how we can control stale results with undocumented options.<\/p>\n
I’m creating a basic table.<\/p>\n
22:30:44 SQL> create table DEMO as select rownum id from xmltable('1 to 100000');\nTable created.\n \n22:30:44 SQL> exec if dbms_result_cache.flush then dbms_output.put_line('Flushed.'); end if;\nPL\/SQL procedure successfully completed.\n<\/code><\/pre>\nRESULT_CACHE<\/h3>\n
On that table, I’ll do a simple select with the RESULT_CACHE hint.<\/p>\n
22:30:44 SQL> set autotrace on\n22:30:44 SQL> select \/*+ result_cache<\/b> *\/ count(*) from DEMO;\n \n COUNT(*)\n----------\n 100000\n \nExecution Plan\n----------------------------------------------------------\nPlan hash value: 2180342005\n \n------------------------------------------------------------------------------------------\n| Id | Operation | Name | Rows | Cost (%CPU)| Time |\n------------------------------------------------------------------------------------------\n| 0 | SELECT STATEMENT | | 1 | 46 (0)| 00:00:01 |\n| 1 | RESULT CACHE | 2x5f91pfn5p6882f6szxj50jwf | | | |\n| 2 | SORT AGGREGATE | | 1 | | |\n| 3 | TABLE ACCESS FULL| DEMO | 100K| 46 (0)| 00:00:01 |\n------------------------------------------------------------------------------------------\n \nResult Cache Information (identified by operation id):\n------------------------------------------------------\n \n 1 - column-count=1; dependencies=(DEMO.DEMO); attributes=(single-row); name=\"select \/*+ result_cache *\/ count(*) from DEMO\"\n \nStatistics\n----------------------------------------------------------\n 5 recursive calls\n 0 db block gets\n 159 consistent gets\n 153 physical reads\n 0 redo size\n 358 bytes sent via SQL*Net to client\n 499 bytes received via SQL*Net from client\n 2 SQL*Net roundtrips to\/from client\n 0 sorts (memory)\n 0 sorts (disk)\n 1 rows processed\n<\/code><\/pre>\nWe have read the 150 blocks of the DEMO table. The result cache has been loaded. Here are the objects and dependency:<\/p>\n
22:30:44 SQL> set autotrace off\n22:30:44 SQL> select * from v$result_cache_dependency;\n \n RESULT_ID DEPEND_ID OBJECT_NO CON_ID\n---------- ---------- ---------- ----------\n 1 0 112463 0\n \n22:30:44 SQL> select id,type,status,name,cache_id,invalidations from v$result_cache_objects order by id;\n \n ID TYPE STATUS NAME CACHE_ID INV\n--- ---------- --------- ------------------------------ --------------------------- ----\n 0 Dependency Published DEMO.DEMO DEMO.DEMO 0\n 1 Result Published select \/*+ result_cache *\/ cou 2x5f91pfn5p6882f6szxj50jwf 0<\/code><\/pre>\nWe can read it as: the query result (id=1) depends on the table (id=0).<\/p>\n
If I run it another time:<\/p>\n
22:30:45 SQL> select \/*+ result_cache *\/ count(*) from DEMO;\n \n COUNT(*)\n----------\n 100000\n \nExecution Plan\n----------------------------------------------------------\nPlan hash value: 2180342005\n \n------------------------------------------------------------------------------------------\n| Id | Operation | Name | Rows | Cost (%CPU)| Time |\n------------------------------------------------------------------------------------------\n| 0 | SELECT STATEMENT | | 1 | 46 (0)| 00:00:01 |\n| 1 | RESULT CACHE | 2x5f91pfn5p6882f6szxj50jwf | | | |\n| 2 | SORT AGGREGATE | | 1 | | |\n| 3 | TABLE ACCESS FULL| DEMO | 100K| 46 (0)| 00:00:01 |\n------------------------------------------------------------------------------------------\n \nResult Cache Information (identified by operation id):\n------------------------------------------------------\n \n 1 - column-count=1; dependencies=(DEMO.DEMO); attributes=(single-row); name=\"select \/*+ result_cache *\/ count(*) from DEMO\"\n \nStatistics\n----------------------------------------------------------\n 0 recursive calls\n 0 db block gets\n 0 consistent gets\n 0 physical reads\n 0 redo size\n 358 bytes sent via SQL*Net to client\n 499 bytes received via SQL*Net from client\n 2 SQL*Net roundtrips to\/from client\n 0 sorts (memory)\n 0 sorts (disk)\n 1 rows processed<\/code><\/pre>\nNo block get at all. The result was in cache.<\/p>\n
dependencies<\/h3>\n
If we do any kind of DML on the tables the result cache depends on:<\/p>\n
22:30:45 SQL> delete from DEMO where null is not null;\n0 rows deleted.\n \n22:30:45 SQL> commit;\nCommit complete.<\/code><\/pre>\nThen the cache is invalidated:<\/p>\n
22:30:45 SQL> select * from v$result_cache_dependency;\nno rows selected\n \n22:30:45 SQL> select id,type,status,name,cache_id,invalidations from v$result_cache_objects order by id;\n \n ID TYPE STATUS NAME CACHE_ID INV\n--- ---------- --------- ------------------------------ --------------------------- ----\n 0 Dependency Published DEMO.DEMO DEMO.DEMO 1\n 1 Result Invalid select \/*+ result_cache *\/ cou 2x5f91pfn5p6882f6szxj50jwf 0<\/code><\/pre>\nand another run will have to load the cache again:<\/p>\n
22:30:45 SQL> set autotrace on\n22:30:45 SQL> select \/*+ result_cache *\/ count(*) from DEMO;\n \n COUNT(*)\n----------\n 100000\n \nExecution Plan\n----------------------------------------------------------\nPlan hash value: 2180342005\n \n------------------------------------------------------------------------------------------\n| Id | Operation | Name | Rows | Cost (%CPU)| Time |\n------------------------------------------------------------------------------------------\n| 0 | SELECT STATEMENT | | 1 | 46 (0)| 00:00:01 |\n| 1 | RESULT CACHE | 2x5f91pfn5p6882f6szxj50jwf | | | |\n| 2 | SORT AGGREGATE | | 1 | | |\n| 3 | TABLE ACCESS FULL| DEMO | 100K| 46 (0)| 00:00:01 |\n------------------------------------------------------------------------------------------\n \nResult Cache Information (identified by operation id):\n------------------------------------------------------\n \n 1 - column-count=1; dependencies=(DEMO.DEMO); attributes=(single-row); name=\"select \/*+ result_cache *\/ count(*) from DEMO\"\n \nStatistics\n----------------------------------------------------------\n 0 recursive calls\n 0 db block gets\n 157 consistent gets\n 0 physical reads\n 0 redo size\n 358 bytes sent via SQL*Net to client\n 499 bytes received via SQL*Net from client\n 2 SQL*Net roundtrips to\/from client\n 0 sorts (memory)\n 0 sorts (disk)\n 1 rows processed\n \n22:30:46 SQL> set autotrace off\n22:30:46 SQL> select * from v$result_cache_dependency;\n \n RESULT_ID DEPEND_ID OBJECT_NO CON_ID\n---------- ---------- ---------- ----------\n 2 0 112463 0\n \n22:30:46 SQL> select id,type,status,name,cache_id,invalidations from v$result_cache_objects order by id;\n \n ID TYPE STATUS NAME CACHE_ID INV\n--- ---------- --------- ------------------------------ --------------------------- ----\n 0 Dependency Published DEMO.DEMO DEMO.DEMO 1\n 1 Result Invalid select \/*+ result_cache *\/ cou 2x5f91pfn5p6882f6szxj50jwf 0\n 2 Result Published select \/*+ result_cache *\/ cou 2x5f91pfn5p6882f6szxj50jwf 0<\/code><\/pre>\nThis is the only documented behaviour: the cache is invalidated if and only if there has been some DML on the tables it depends on.<\/p>\n
RESULT_CACHE(SHELFLIFE=seconds)<\/h3>\n
I flush the cache and run the same with the undocumented result cache hint option: SHELFLIFE=10 seconds:<\/p>\n
22:30:46 SQL> exec if dbms_result_cache.flush then dbms_output.put_line('Flushed.'); end if;\nPL\/SQL procedure successfully completed.\n \n22:30:46 SQL> set autotrace on\n22:30:46 SQL> select \/*+ result_cache(shelflife=10) *\/ count(*) from DEMO;\n \n COUNT(*)\n----------\n 100000\n \nExecution Plan\n----------------------------------------------------------\nPlan hash value: 2180342005\n \n------------------------------------------------------------------------------------------\n| Id | Operation | Name | Rows | Cost (%CPU)| Time |\n------------------------------------------------------------------------------------------\n| 0 | SELECT STATEMENT | | 1 | 46 (0)| 00:00:01 |\n| 1 | RESULT CACHE | 2x5f91pfn5p6882f6szxj50jwf | | | |\n| 2 | SORT AGGREGATE | | 1 | | |\n| 3 | TABLE ACCESS FULL| DEMO | 100K| 46 (0)| 00:00:01 |\n------------------------------------------------------------------------------------------\n \nResult Cache Information (identified by operation id):\n------------------------------------------------------\n \n 1 - column-count=1; dependencies=(DEMO.DEMO); attributes=(single-row, shelflife=10); name=\"select \/*+ result_cache(shelflife=10) *\/ count(*) from DEMO\"<\/code><\/pre>\nwe see the ‘shelflife’ attribute but the dependency is the same as without the option:<\/p>\n
22:30:46 SQL> set autotrace off\n22:30:46 SQL> select * from v$result_cache_dependency;\n \n RESULT_ID DEPEND_ID OBJECT_NO CON_ID\n---------- ---------- ---------- ----------\n 1 0 112463 0\n \n22:30:46 SQL> select id,type,status,name,cache_id,invalidations from v$result_cache_objects order by id;\n \n ID TYPE STATUS NAME CACHE_ID INV\n--- ---------- --------- ------------------------------ --------------------------- ----\n 0 Dependency Published DEMO.DEMO DEMO.DEMO 0\n 1 Result Published select \/*+ result_cache(shelfl 2x5f91pfn5p6882f6szxj50jwf 0<\/code><\/pre>\nI run the query again 5 seconds later:<\/p>\n
22:30:51 SQL> set autotrace on\n22:30:51 SQL> select \/*+ result_cache(shelflife=10) *\/ count(*) from DEMO;\n \n COUNT(*)\n----------\n 100000\n \nExecution Plan\n----------------------------------------------------------\nPlan hash value: 2180342005\n \n------------------------------------------------------------------------------------------\n| Id | Operation | Name | Rows | Cost (%CPU)| Time |\n------------------------------------------------------------------------------------------\n| 0 | SELECT STATEMENT | | 1 | 46 (0)| 00:00:01 |\n| 1 | RESULT CACHE | 2x5f91pfn5p6882f6szxj50jwf | | | |\n| 2 | SORT AGGREGATE | | 1 | | |\n| 3 | TABLE ACCESS FULL| DEMO | 100K| 46 (0)| 00:00:01 |\n------------------------------------------------------------------------------------------\n \nResult Cache Information (identified by operation id):\n------------------------------------------------------\n \n 1 - column-count=1; dependencies=(DEMO.DEMO); attributes=(single-row, shelflife=10); name=\"select \/*+ result_cache(shelflife=10) *\/ count(*) from DEMO\"\n \nStatistics\n----------------------------------------------------------\n 0 recursive calls\n 0 db block gets\n 0 consistent gets\n 0 physical reads\n 0 redo size\n 358 bytes sent via SQL*Net to client\n 499 bytes received via SQL*Net from client\n 2 SQL*Net roundtrips to\/from client\n 0 sorts (memory)\n 0 sorts (disk)\n 1 rows processed\n \n22:30:51 SQL> set autotrace off\n22:30:51 SQL> select * from v$result_cache_dependency;\n \n RESULT_ID DEPEND_ID OBJECT_NO CON_ID\n---------- ---------- ---------- ----------\n 1 0 112463 0\n \n22:30:51 SQL> select id,type,status,name,cache_id,invalidations from v$result_cache_objects order by id;\n \n ID TYPE STATUS NAME CACHE_ID INV\n--- ---------- --------- ------------------------------ --------------------------- ----\n 0 Dependency Published DEMO.DEMO DEMO.DEMO 0\n 1 Result Published select \/*+ result_cache(shelfl 2x5f91pfn5p6882f6szxj50jwf 0<\/code><\/pre>\nNothing special here. No DML occured so the result is still valid (‘published’)<\/p>\n
expiration<\/h3>\n
But let’s wait 5 more seconds and run it again:<\/p>\n
22:30:56 SQL> select * from v$result_cache_dependency;\n \n RESULT_ID DEPEND_ID OBJECT_NO CON_ID\n---------- ---------- ---------- ----------\n 1 0 112463 0\n \n22:30:56 SQL> select id,type,status,name,cache_id,invalidations from v$result_cache_objects order by id;\n \n ID TYPE STATUS NAME CACHE_ID INV\n--- ---------- --------- ------------------------------ --------------------------- ----\n 0 Dependency Published DEMO.DEMO DEMO.DEMO 0\n 1 Result Expired select \/*+ result_cache(shelfl 2x5f91pfn5p6882f6szxj50jwf 0<\/code><\/pre>\nThe status has changed, it’s now EXPIRED because the 10 seconds shelflife has passed on since the cache was loaded.<\/p>\n
22:30:56 SQL>\n22:30:56 SQL> set autotrace on\n22:30:56 SQL> select \/*+ result_cache(shelflife=10) *\/ count(*) from DEMO;\n \n COUNT(*)\n----------\n 100000\n \nExecution Plan\n----------------------------------------------------------\nPlan hash value: 2180342005\n \n------------------------------------------------------------------------------------------\n| Id | Operation | Name | Rows | Cost (%CPU)| Time |\n------------------------------------------------------------------------------------------\n| 0 | SELECT STATEMENT | | 1 | 46 (0)| 00:00:01 |\n| 1 | RESULT CACHE | 2x5f91pfn5p6882f6szxj50jwf | | | |\n| 2 | SORT AGGREGATE | | 1 | | |\n| 3 | TABLE ACCESS FULL| DEMO | 100K| 46 (0)| 00:00:01 |\n------------------------------------------------------------------------------------------\n \nResult Cache Information (identified by operation id):\n------------------------------------------------------\n \n 1 - column-count=1; dependencies=(DEMO.DEMO); attributes=(single-row, shelflife=10); name=\"select \/*+ result_cache(shelflife=10) *\/ count(*) from DEMO\"\n \nStatistics\n----------------------------------------------------------\n 0 recursive calls\n 0 db block gets\n 157 consistent gets\n 0 physical reads\n 0 redo size\n 358 bytes sent via SQL*Net to client\n 499 bytes received via SQL*Net from client\n 2 SQL*Net roundtrips to\/from client\n 0 sorts (memory)\n 0 sorts (disk)\n 1 rows processed<\/code><\/pre>\nhere I have a cache miss even if no DML occured on the tables it depends on.<\/p>\n
22:30:56 SQL> select * from v$result_cache_dependency;\n \n RESULT_ID DEPEND_ID OBJECT_NO CON_ID\n---------- ---------- ---------- ----------\n 2 0 112463 0\n \n22:30:56 SQL> select id,type,status,name,cache_id,invalidations from v$result_cache_objects order by id;\n \n ID TYPE STATUS NAME CACHE_ID INV\n--- ---------- --------- ------------------------------ --------------------------- ----\n 0 Dependency Published DEMO.DEMO DEMO.DEMO 0\n 1 Result Invalid select \/*+ result_cache(shelfl 2x5f91pfn5p6882f6szxj50jwf 0\n 2 Result Published select \/*+ result_cache(shelfl 2x5f91pfn5p6882f6szxj50jwf 0<\/code><\/pre>\nWhen I run a query using an expired result cache, that cache becomes invalid, the query is fully run (150 block gets) and new result cache populated.<\/p>\n
Note that in addition to the shelflife expiration, the dependency on DML is still invalidating the result cache:<\/p>\n
22:30:56 SQL> delete from DEMO where null is not null;\n0 rows deleted.\n \n22:30:56 SQL> commit;\nCommit complete.\n \n22:30:56 SQL> select * from v$result_cache_dependency;\nno rows selected\n \n22:30:56 SQL> select id,type,status,name,cache_id,invalidations from v$result_cache_objects order by id;\n \n ID TYPE STATUS NAME CACHE_ID INV\n--- ---------- --------- ------------------------------ --------------------------- ----\n 0 Dependency Published DEMO.DEMO DEMO.DEMO 1\n 1 Result Invalid select \/*+ result_cache(shelfl 2x5f91pfn5p6882f6szxj50jwf 0\n 2 Result Invalid select \/*+ result_cache(shelfl 2x5f91pfn5p6882f6szxj50jwf 0<\/code><\/pre>\nSo with SHELFLIFE we have two reasons for invalidations: dependency and expiration.<\/p>\n
RESULT_CACHE(SNAPSHOT=seconds)<\/h3>\n
There is another undocumented option for the result cache hint: SNAPSHOT which also taked a number of seconds. Let’s try it:<\/p>\n
22:30:56 SQL> exec if dbms_result_cache.flush then dbms_output.put_line('Flushed.'); end if;\nPL\/SQL procedure successfully completed.\n \n22:30:56 SQL> set autotrace on\n22:30:56 SQL> select \/*+ result_cache(snapshot=10) *\/ count(*) from DEMO;\n \n COUNT(*)\n----------\n 100000\n \nExecution Plan\n----------------------------------------------------------\nPlan hash value: 2180342005\n \n------------------------------------------------------------------------------------------\n| Id | Operation | Name | Rows | Cost (%CPU)| Time |\n------------------------------------------------------------------------------------------\n| 0 | SELECT STATEMENT | | 1 | 46 (0)| 00:00:01 |\n| 1 | RESULT CACHE | 2x5f91pfn5p6882f6szxj50jwf | | | |\n| 2 | SORT AGGREGATE | | 1 | | |\n| 3 | TABLE ACCESS FULL| DEMO | 100K| 46 (0)| 00:00:01 |\n------------------------------------------------------------------------------------------\n \nResult Cache Information (identified by operation id):\n------------------------------------------------------\n \n 1 - column-count=1; attributes=(single-row, snapshot=10); name=\"select \/*+ result_cache(snapshot=10) *\/ count(*) from DEMO\"\n \nStatistics\n----------------------------------------------------------\n 1 recursive calls\n 0 db block gets\n 157 consistent gets\n 0 physical reads\n 0 redo size\n 358 bytes sent via SQL*Net to client\n 499 bytes received via SQL*Net from client\n 2 SQL*Net roundtrips to\/from client\n 0 sorts (memory)\n 0 sorts (disk)\n 1 rows processed\n \n22:30:56 SQL> set autotrace off\n22:30:56 SQL> select * from v$result_cache_dependency;\nno rows selected\n \n22:30:56 SQL> select id,type,status,name,cache_id,invalidations from v$result_cache_objects order by id;\n \n ID TYPE STATUS NAME CACHE_ID INV\n--- ---------- --------- ------------------------------ --------------------------- ----\n 0 Result Published select \/*+ result_cache(snapsh 2x5f91pfn5p6882f6szxj50jwf 0<\/code><\/pre>\nThe cache has been populated here, but there is no dependency. Let’s try DML on base table:<\/p>\n
22:30:56 SQL> delete from DEMO where null is not null;\n0 rows deleted.\n \n22:30:56 SQL> commit;\nCommit complete.\n \n22:30:56 SQL> select * from v$result_cache_dependency;\nno rows selected\n \n22:30:56 SQL> select id,type,status,name,cache_id,invalidations from v$result_cache_objects order by id;\n \n ID TYPE STATUS NAME CACHE_ID INV\n--- ---------- --------- ------------------------------ --------------------------- ----\n 0 Result Published select \/*+ result_cache(snapsh 2x5f91pfn5p6882f6szxj50jwf 0<\/code><\/pre>\nA SNAPSHOT result cache is not invalidated by DML on base tables.<\/p>\n
But if we wait 10 seconds:<\/p>\n
22:31:06 SQL> select id,type,status,name,cache_id,invalidations from v$result_cache_objects order by id;\n \n ID TYPE STATUS NAME CACHE_ID INV\n--- ---------- --------- ------------------------------ --------------------------- ----\n 0 Result Expired select \/*+ result_cache(snapsh 2x5f91pfn5p6882f6szxj50jwf 0<\/code><\/pre>\nThe status is expired, as with the shelflife. Next execution will invalidate it.<\/p>\n
Conclusion<\/h3>\n
There are two reasons to invalidate a result cache: DML on dependency, or expiration after a number of seconds. And we can use any combination of them with undocumented hints. Oracle itself uses them internally. SNAPSHOT is used by Active Dynamic Sampling: stale result are acceptable for one hour. SHELFLIFE is used on dictionary views bases on X$ tables where dependency cannot be tracked.<\/p>\n
I hope it will get documented in future releases. There are some cases where we can accept stale results in order to get better performance. We already do that with materialized views, so why not do it with result cache?<\/p>\n","protected":false},"excerpt":{"rendered":"
By Franck Pachot . The result cache is very nice when base tables are static: get the result without any buffer get, without any join or sorts. But as soon as any DML occurs on one of the tables the result is based on, then result cache is invalidated. And cache misses are quite expensive. […]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198,59],"tags":[96,522],"type_dbi":[],"class_list":["post-5054","post","type-post","status-publish","format-standard","hentry","category-database-management","category-oracle","tag-oracle","tag-undocumented"],"acf":[],"yoast_head":"\n
RESULT_CACHE hint expiration options - dbi Blog<\/title>\n<meta name=\"description\" content=\"Oracle Enterprise Edition result cache: invalidation on dependency (documented) and shelflife (undocumented)\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/resultcache-hint-expiration-options\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"RESULT_CACHE hint expiration options\" \/>\n<meta property=\"og:description\" content=\"Oracle Enterprise Edition result cache: invalidation on dependency (documented) and shelflife (undocumented)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/resultcache-hint-expiration-options\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-07-05T18:22:07+00:00\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/resultcache-hint-expiration-options\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/resultcache-hint-expiration-options\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"RESULT_CACHE hint expiration options\",\"datePublished\":\"2015-07-05T18:22:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/resultcache-hint-expiration-options\/\"},\"wordCount\":569,\"commentCount\":0,\"keywords\":[\"Oracle\",\"undocumented\"],\"articleSection\":[\"Database management\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/resultcache-hint-expiration-options\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/resultcache-hint-expiration-options\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/resultcache-hint-expiration-options\/\",\"name\":\"RESULT_CACHE hint expiration options - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2015-07-05T18:22:07+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"description\":\"Oracle Enterprise Edition result cache: invalidation on dependency (documented) and shelflife (undocumented)\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/resultcache-hint-expiration-options\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/resultcache-hint-expiration-options\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/resultcache-hint-expiration-options\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"RESULT_CACHE hint expiration options\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"RESULT_CACHE hint expiration options - dbi Blog","description":"Oracle Enterprise Edition result cache: invalidation on dependency (documented) and shelflife (undocumented)","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/resultcache-hint-expiration-options\/","og_locale":"en_US","og_type":"article","og_title":"RESULT_CACHE hint expiration options","og_description":"Oracle Enterprise Edition result cache: invalidation on dependency (documented) and shelflife (undocumented)","og_url":"https:\/\/www.dbi-services.com\/blog\/resultcache-hint-expiration-options\/","og_site_name":"dbi Blog","article_published_time":"2015-07-05T18:22:07+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/resultcache-hint-expiration-options\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/resultcache-hint-expiration-options\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"RESULT_CACHE hint expiration options","datePublished":"2015-07-05T18:22:07+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/resultcache-hint-expiration-options\/"},"wordCount":569,"commentCount":0,"keywords":["Oracle","undocumented"],"articleSection":["Database management","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/resultcache-hint-expiration-options\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/resultcache-hint-expiration-options\/","url":"https:\/\/www.dbi-services.com\/blog\/resultcache-hint-expiration-options\/","name":"RESULT_CACHE hint expiration options - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2015-07-05T18:22:07+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"description":"Oracle Enterprise Edition result cache: invalidation on dependency (documented) and shelflife (undocumented)","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/resultcache-hint-expiration-options\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/resultcache-hint-expiration-options\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/resultcache-hint-expiration-options\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"RESULT_CACHE hint expiration options"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/5054","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=5054"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/5054\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=5054"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=5054"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=5054"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=5054"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}