Some cases query results do not insert in the cache where the logical sql query was suppose to insert into the cache. As a result, frequently cache missed occurs. Would anyone please explain the reasons for not insert a query result into the obiee12c cache.
1 Answers
The following describes some situation when this might occur
Noncacheable SQL element.
Noncacheable table.
Cache hit
Result set is too big.
Query is cancelled
More details please go through the following document.
https://docs.oracle.com/middleware/1221/biee/BIESG/configfileref.htm#BIESG357
Related