Re: Stats and behavior weirdness
- From: "Juan Carlos Reyes Pacheco" <juancarlosreyesp@xxxxxxxxx>
- To: kevin.lidh@xxxxxxxxx
- Date: Mon, 6 Mar 2006 15:13:52 -0400
Hi Kevin, why don't you try to set this parameters in one session
OPTIMIZER_INDEX_COST_ADJ = 10
OPTIMIZER_INDEX_CACHING = 90
When suddenly, the performance moves from seconds to almost an hours,
without good reasons, I solve this settings this parameters, when the
code can be improved.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
