This content has been marked as final.
Show 1 reply
-
1. Re: connection pool and statement cache
clizarralde Sep 21, 2005 11:55 AM (in response to zielony)"zielony" wrote:
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."zielony" wrote:
3) when i have in oracle-ds.xml such lines:
<prepared-statement-cache-size>50</prepared-statement-cache-size>
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.