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
