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.
On 2/9/07, Alberto Dell'Era <alberto.dellera_at_gmail.com> wrote:
>
> Dear all,
>
> I've been asked to help "tuning" an Hibernate+Oracle application.
>
> After a first glance at the application, I feel that the best tuning
> advice would be
>
> mv Hibernate /dev/null
>
> but - does anyone know about a good paper about how to optimize
> Hibernate interacting with Oracle - or have any advice/experience to share
> ?
>
> We can modify the application at will, so "tuning" is not restricted to
> playing with indexes/instance parameters - it could mean also
> an "application rewrite".
>
> Thanks-In-Advance
> Alberto
>
> --
> Alberto Dell'Era
> "Per aspera ad astra"
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Feb 09 2007 - 14:22:08 CST
