NO_INVALIDATE in DBMS_STATS

What does No_Invalidate parameter signfy in DBMS_STATS in Oracle 10G onwards.

Prior to Oracle 10G DBMS_STAT  will gather statistics the Schema/tables and invalidate dependent cursors immediately from share pool,so the next time new plan will be executed based upon statistics.
This will cause Hard parsing which will take high CPU resources.

Now In Oracle 10G we have control whether dependent cursors need to be invalidate or not with
NO_VALIDATE parameter in dbms_stats package.

f       Following are details of  no_invalidate parameter and default value of this parameter is     
        DBMS_STATS.AUTO_INVALIDATE

      NO_INVALIDATE Determines whether to invalidate dependent cursors or not
  Default: DBMS_STATS.AUTO_INVALIDATE
Possible Values:

• DBMS_STATS.AUTO_INVALIDATE - Oracle decide when to invalidate dependent cursors. 
• TRUE - Does not invalidate the dependent cursors
• FALSE - Invalidates dependent cursors

Hope this helps!!!
Tarun C