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 to

Setting expiration time when caching view

Source Show
◀ Wstecz