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!

When I run the same query for the second time it's faster, I want to reset this behavior

user9359353Aug 5 2013 — edited Aug 5 2013

I am running a query in oracle 11g select A from B where C = ':D' B has millions of records.

The first time i run it it takes about 30 seconds, the second time i run the query it takes about 1 second.

Obviously it's caching something and i want it to stop that, each time i run the query i want it to take 30s - just like it was running for the first time.

The reason I want to reset this is because for testing purposes I want to measure this query at the very first time.

Please help.

Thanks & Best Regards,

Dark

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 2 2013
Added on Aug 5 2013
3 comments
1,590 views