2 Replies Latest reply on Jan 28, 2016 10:41 AM by Prashanthi Kairuppala

    ttl cache on view table

    Prashanthi Kairuppala Novice

      we have updated the default cache settings to -1 in our odata war file. we have a select query in our view table. We added a ttl cache in the view but it is not taking effect.

      Below are the two select queries i tried :

      1. /*+ cache(ttl:60000) */ select col from t

      2. /* cache(tl:60000) */ select col from t

      After applying the cache in select query, i hit the odata call once, then change col from table t in database then try the odata call again, i get the new data instead of cached data.

      Please let me know if what need to be done to apply ttl cache for one view table.