[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - CURSOR_SHARING option help needed
mimmo67
do-not-reply at jboss.com
Thu Feb 19 09:13:00 EST 2009
Hi all.
I'm working on an Hibernate project with Oracle database and I'm experimenting a huge performance problem on same queries.
Our dba engineer suggested us to set the CURSOR_SHARING option to FORCE to solve these problems.
My difficulty is that I need to set this option only for the single Hibernate transaction and not for all the system\sessions of the schema because I want to avoid to impact the other systems based on the same schema.
Can you help me to find an option/solution (add something in the datasource configuration?) I can use?
Thank you in advance.
Best regards from Italy,
Domenico
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4211478#4211478
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4211478
More information about the jboss-user
mailing list