to cgh_chen :
是的,dml locks - one for each table modified in a transaction。
看起来,我是理解的有偏差了,呵呵
to eygle:
RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_ALLOCATION LIMIT_VALUE
------------------------------ ------------------- --------------- --------------------- ---------------------
processes 11 12 150 150
sessions 10 12 170 170
enqueue_locks 7 13 2230 2230
enqueue_resources 9 39 968 968
_lm_procs 0 0 0 0
lm_ress 0 0 0 UNLIMITED
lm_locks 0 0 0 UNLIMITED
lm_cache_ress 0 0 0 UNLIMITED
dml_locks 1 31 748 748
temporary_table_locks 0 1 UNLIMITED UNLIMITED
transactions 1 4 187 187
sort_segment_locks 0 0 UNLIMITED UNLIMITED
max_rollback_segments 26 26 38 38
distributed_transactions 0 0 46 46
mts_max_servers 0 0 20 20
parallel_max_servers 0 0 6 6