TransactionManager says 70 are active, 600 commits, etc. Really weird :-)
thx [] Leo On Tue, Jan 27, 2015 at 3:47 PM, Romain Manni-Bucau <[email protected]> wrote: > 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 >
