[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - CURSOR_SHARING option help needed

[mimmo67]

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