Why do my execution plans not change after gathering statistics? – A look at Rolling Cursor Invalidations

In releases prior to Oracle 10g, the gathering of statistics using DBMS_STATS resulted in immediate invalidations of dependent cached cursors. This was true unless NO_INVALIDATE parameter of the DBMS_STATS command was set to TRUE. It was felt that gathering of statistics could actually have a negative impact on performance because of the fact that invalidation […]

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?