RE: CBO costing pl/sql functions

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