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

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#... Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&a...