RE: CBO costing pl/sql functions

  • From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
  • To: <jeremy.schneider@xxxxxxxxxxxxxx>
  • Date: Wed, 13 Jun 2007 09:51:25 +0200

Hi Jeremy

> i'm working on a system right now where the root of some
> performance problems seems to be that the CBO is rather
> dramatically under-estimating the cost of a few pl/sql
> functions. 

I suggest you to give a look to the ASSOCIATE STATISTICS SQL statement.

You may try to find a copy of Joze Senegacnik's paper "CBO's Costing Of
PL/SQL Functions".


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


Other related posts: