Skip to Main Content

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Result Cache Hint in Procedure

996283Jul 20 2016 — edited Jul 20 2016

Hi,

I have a query where i am using result_cache hint, so for the first time it is taking normal execution time and for the second time onward, its execution time gets reduced to a great extent.

but when i am using the same query in a procedure and returning the result set with ref cursor, its execution time remains the same even after the first execution. but my understanding is that time should reduce after first execution.

In all execution, i am keeping all constant values as same.

Please let me know why is this behavior different in query and procedure.

Thanks,

Vipin Kumar Rai

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 17 2016
Added on Jul 20 2016
5 comments
505 views