no_invalidate
Does not invalidate the dependent cursors if set to TRUE. The procedure invalidates the dependent cursors immediately if set to FALSE. Use DBMS_STATS.AUTO_INVALIDATE. to have Oracle decide when to invalidate dependent cursors. This is the default. The default can be changed using the SET_PARAM Procedure
SQL> show parameters optimizer_invalidation
NAME VALUE
————————————–
_optimizer_invalidation_period 60
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22034023/viewspace-694513/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
索引里的NULL值与排序小记
请登录后发表评论
登录
全部评论
