RE: ADDM Oddities

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
> 
> 
> 
> --
> http://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: