RE: Performance challenge.

Not *all* parsed statements, only the statements that are dependent on the table(s) that you analyze, and it depends on whether or not you set no_invalidate=>false (default) or true.  

I would suggest to focus on the specific query or queries the users reporting to be running slowly and run a 10046 trace on it. Then run your usual stats update and run another trace on it when the users say it is performing well and compare the two trace files to see what has changed.  

Regards,
Brandon

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Johnson, William L (TEIS)    Does analyzing a table invalidate all parsed statements in the v$sqlarea - in effect getting rid of a poor explain plan that may be causing other queries to run slowly?    

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

--
http://www.freelists.org/webpage/oracle-l