Question: Setting expiration time when caching view

Question

Setting expiration time when caching view

Answers 0
Added at 2017-01-03 09:01
Tags
Question

I want to cache the result from a view in Oracle. My view is declared as:

CREATE VIEW SOME_VIEW AS
SELECT
    /*+ RESULT_CACHE */
    u.name
    c.info
FROM
    Users u
    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?

Answers
Source Show
◀ Wstecz