Re: Hibernate and Oracle
- From: "Alberto Dell'Era" <alberto.dellera@xxxxxxxxx>
- To: "John Darrah" <darrah.john@xxxxxxxxx>
- Date: Fri, 9 Feb 2007 21:34:15 +0100
Thanks John - our version is 10g, CBO is definitely going to be used;
in this environment, do you foresee any difference in overriding the
ANSI join setting ?
On 2/9/07, John Darrah <darrah.john@xxxxxxxxx> wrote:
10046 trace is your friend when trying to tune hibernate apps. If your
database is > oracle 8i and still using RBO, you'll want to override the
setting that tells hibernate to use ANSI sql joins (you want to do this
regardless in my opinion) as not doing so forces a cost based plan.
--
Alberto Dell'Era
"Per aspera ad astra"
--
//www.freelists.org/webpage/oracle-l
Other related posts:
