RE: Performance challenge.
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: <WLJohnson@xxxxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 17 Apr 2007 10:32:26 -0700
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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.
Other related posts:
