ITPub博客

首页 > Linux操作系统 > Linux操作系统 > invalidate the plans in shared pool

invalidate the plans in shared pool

原创 Linux操作系统 作者:v_fantasy 时间:2009-05-25 11:23:55 0 删除 编辑
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博客 ” ,链接:http://blog.itpub.net/16158219/viewspace-604052/,如需转载,请注明出处,否则将追究法律责任。

下一篇: bind peeking
请登录后发表评论 登录
全部评论

注册时间:2008-10-07

  • 博文量
    98
  • 访问量
    182005