RE: ADDM Oddities
- From: Martin Brown <martinfbrown@xxxxxxxxxxx>
- To: <regdba@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 14 May 2009 12:41:43 -0400
Pete, If you don't mind, is the gather_stats_job disabled in the scheduler?
I ask because I'm spinning on a very similar problem. It's not a vendor
package, but home-rolled code.
Martin....
> Date: Thu, 14 May 2009 07:28:12 -0700
> From: regdba@xxxxxxxxx
> Subject: ADDM Oddities
> To: oracle-l@xxxxxxxxxxxxx
>
>
> We have a vendor package which has a lot of performance problems. Naturally,
> from their perspective it is the database. I have drifted into and out of
> this implementation so I do not necessarily have all of the facts but here
> are the questions.
>
> The vendor relies heavily on ADDM. I looked at an ADDM report that
> specifically said parsing is not a problem but the app does not reuse any
> code. Every execution requires a parse. What's up with ADDM?
>
> I was poking around in the database and found that one entire schema had
> never been analyzed. Digging in further, I found that all of the statistics
> for the other schemas were stale. Again, this was not flagged in ADDM. This
> seems pretty basic to me. Maybe too basic and no one would imagine a 10g
> database without current statistics.
>
> Anyway, the output just struck me as somewhat odd and misleading.
>
>
>
> Pete Barnett
> Database Technologies Lead
> Regence
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
_________________________________________________________________
Insert movie times and more without leaving Hotmail®.
http://windowslive.com/Tutorial/Hotmail/QuickAdd?ocid=TXT_TAGLM_WL_HM_Tutorial_QuickAdd1_052009
Other related posts:
