You can check as well through JMX geronimo transaction manager transaction count (in openejb jmx mbeans, under the name TransactionManager IIRC).
looks weird yes but can depend oracle driver config AFAIK Romain Manni-Bucau @rmannibucau http://www.tomitribe.com http://rmannibucau.wordpress.com https://github.com/rmannibucau 2015-01-27 18:41 GMT+01:00 Leonardo K. Shikida <[email protected]>: > Hi > > I am running a simple Java EE application in tomee+. This application uses > JPA and it's backed by an oracle XE server. > > I've noticed that it uses many oracle sessions and processes (which kind of > represent the connections), but just a single transaction, tops. > > Of course, I try to keep transactions short, but I was expecting more under > stress tests. > > Is that expected or should I investigate my code for potential bottlenecks? > > SQL> select * from v$resource_limit; > > RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION > INITIAL_ALLOCATION LIMIT_VALUE > ------------------------------ ------------------- --------------- > ---------------------------------------- > ---------------------------------------- > processes 56 119 340 > 340 > sessions 59 142 532 > 532 > enqueue_locks 52 114 6220 > 6220 > enqueue_resources 17 17 1299 > UNLIMITED > ges_procs 0 0 0 0 > ges_ress 0 0 0 > UNLIMITED > ges_locks 0 0 0 > UNLIMITED > ges_cache_ress 0 0 0 > UNLIMITED > ges_reg_msgs 0 0 0 > UNLIMITED > ges_big_msgs 0 0 0 > UNLIMITED > ges_rsv_msgs 0 0 0 > 0 > > RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION > INITIAL_ALLOCATION LIMIT_VALUE > ------------------------------ ------------------- --------------- > ---------------------------------------- > ---------------------------------------- > gcs_resources 0 0 0 > 0 > gcs_shadows 0 0 0 > 0 > dml_locks 1 1 660 > UNLIMITED > temporary_table_locks 0 1 UNLIMITED > UNLIMITED > *transactions 1 1 585 > UNLIMITED* > branches 0 0 585 > UNLIMITED > cmtcallbk 0 30 585 > UNLIMITED > max_rollback_segments 48 48 585 > 65535 > sort_segment_locks 0 1 UNLIMITED > UNLIMITED > k2q_locks 0 0 1064 > UNLIMITED > max_shared_servers 0 0 UNLIMITED > UNLIMITED > > RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION > INITIAL_ALLOCATION LIMIT_VALUE > ------------------------------ ------------------- --------------- > ---------------------------------------- > ---------------------------------------- > parallel_max_servers 0 0 0 > 3600 > > [] > > Leo
