Re: Hibernate and Oracle

  • From: "John Darrah" <darrah.john@xxxxxxxxx>
  • To: "Alberto Dell'Era" <alberto.dellera@xxxxxxxxx>
  • Date: Sun, 11 Feb 2007 15:04:46 -0700


There shouldn't be a problem with using the ANSI joins if using CBO.  I just
prefer looking at the oracle non ANSI joins.  Just what I'm used to and
comfortable with.  Hibernate In Action is a pretty good book on the
subject.  Unfortunately, I think it still only covers up to version 2 of
hibernate.  The online docs have a lot of good info as well.  Good luck.


On 2/9/07, Alberto Dell'Era <alberto.dellera@xxxxxxxxx> wrote:

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"

Other related posts: