This content has been marked as final. Show 1 reply
1) what is difrence between oracle-ds.xml and oracle-xa-ds.xml, i know that second one is used when we need "distributed transactions", but what is it this "distributed transactions" in simple words
a Distributes transaction involves two different resources that require transaction acid properties ( jms server, two diffeent databases, etc. ). For example, you should use an XA datasources in case you are using more than one database within a single business transaction. We are using oracle and ms sqlserver and we are using xa datasources.
3) when i have in oracle-ds.xml such lines:
is it enough to enable and run prepared statement cache in jboss?? or should i configure something more???
You should check the database statistics related to query parsing (check oracle statpack). If you have too many query parsing then you should increase this value.