To invalidate any cursor, one of the followings can be done:

1. Issue the command Alter System Flush Shared_Pool;
2. Delete or change the cursor underlying objects statistics
3. Grant and/or revoke privileges on any of the cursor underlying objects
4. Alter cursor underlying objects
5. Bounce the instance

Alternatively we can either add dummy hint to the same query or change the query
text(such as replace small letters with capitals) to enforce hard parsing it.

Select /*+ Hard parse me please */ Count(*)
From PreferredMeals
Where Meal = :BP
/

ITPub博客

invalidate the plans in shared pool

最新文章