yes, server vision vs database one, can really be different in particular with oracle
Romain Manni-Bucau @rmannibucau http://www.tomitribe.com http://rmannibucau.wordpress.com https://github.com/rmannibucau 2015-01-27 19:03 GMT+01:00 Leonardo K. Shikida <[email protected]>: > 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 >>
