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.
Asked
Active
Viewed 20 times
1 Answers
0
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
Reja
- 534
- 1
- 9
- 18