Verify yourself to prove that you are not a ROBOT! After verification the page will apear. Thanks for understanding.
I want to cache the result from a view in Oracle. My view is declared as:
CREATE VIEW SOME_VIEW AS
/*+ RESULT_CACHE */
LEFT OUT JOIN Contacts c ON c.user_id = u.id
Now I want to explicitly set the cache expiration time of the for this view. If I have understood it right, the expiration is applied to the cache globaly.
Is it possible to set the expiration time per query?