Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Reg: SQL Result Cache -

915396Feb 12 2016 — edited Feb 20 2016

Hi Experts,

I was reading this article on SQL Result Cache, and trying to incorporate this in one of our application.

Problem -

We have a java application which has a selection button. On pressing the button, a pop up comes which displays a list of values. This list is fetched by executing a SQL query on the database.

It's a simple query involving 2 tables. But, one of the table contains 35M records and index is also getting appropriately used. (But, one thing- the table data gets changes once in 3 or 4 months.)

Still it takes 20s to display the result in the popup...

Now, i'm just trying to use /*+ RESULT_CACHE */ in the query.

Will it be beneficial ? Any caveats ?

Thanks and Regards,

-Ranit

( on Oracle 11.2.0.4.0 )

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 19 2016
Added on Feb 12 2016
#11g, #cache, #performance
46 comments
7,140 views