Does Analyze Statistics (Compute/Estimate) or dbms_stats causes SQL statements in Shared Pool to be Invalidated ? Invalidated means, Oracle has to do again Hard Parse.
If my application has one schema and I use dbms_stat's package or (dbms_utility or analyze table ..) to analyze schema, would it cause all sql statements in shared pool for this schema to be invalidated.
The other question is: If Analyzing does causes SQL statements in Shared SQL area to invalidate, then should I flush shared pool before or after analyzing it.
Does, it make sense to flush shared pool or not ? Doesn't find any supportive theory.Any thoughts would be appreciated?