Monthly Archives October 2015

Clear Single Use Query from Plan Cache

by Snehashish Ghosh

What is Single Use Plan

Single use plans in the Plan Cache are the plans in the Plan Cache those have been used only once for a defined period of time due to non usage of variable/bind value and use of hard coded literals in the program query.

Example:

 If we execute another query as below:

 another plan will be generated.

Instead if we use the following:

select max(order_date) fro...

Read More