How to Clear All Cached Items in Oracle

How to clear all cached items in Oracle

Flushing the shared pool should do it, but Tom Kyte lists a couple reasons below why you may not get the result you are expecting in some cases:

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:6349391411093

Clear oracle cache between queries

ALTER SYSTEM FLUSH BUFFER_CACHE

More details in the manual:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_2013.htm#i2053602

Oracle 11g - query appears to cache even with NOCACHE hint

From the documentation:

The NOCACHE hint specifies that the blocks retrieved for the table are
placed at the least recently used end of the LRU list in the buffer
cache when a full table scan is performed. This is the normal behavior
of blocks in the buffer cache.

It seems from this that the nocache hint simply doesn't do what you expect it to.

You can clear the shared cache by running ALTER SYSTEM FLUSH SHARED_POOL and the buffer cache by running ALTER SYSTEM FLUSH BUFFER_CACHE. You'll need to do this between each query to prevent the cache from being used.

How to manage clear cache only when the page is loaded the first time Oracle Apex

I've found a solution for this question. I Hope, it'll be useful to everybody.

1)Before Region - Set the Run Process execution option on the process to Once Per Session or When Reset.

2)Shared Components - Navigation Menu - Include the page number in the Clear Cache properties of the navigation list entries that link to the page.

---

Related Topics