Job is hunging after database migration
The Night job occasionally hunging after database migration .
I check the difference between the old db and new db , the major difference is
Parameter Name (Old Value) (New Value)
aq_tm_processes 1 0
circuits 390 0
db_block_buffers 0 120000
db_cache_advice ON OFF
db_cache_size 268435456 0
dml_locks 1716 2440
enqueue_resources 1936 2660
java_pool_size 16777216 67108864
large_pool_size 67108864 109051904
log_archive_format %t_%s.arc %t_%s.dbf
log_buffer 1024000 1048576
max_rollback_segments 85 122
mts_circuits 390 0
mts_dispatchers (PROTOCOL=TCP) (SERVICE=ZZZZ)
mts_sessions 385 0
sga_max_size 530039220 1613835216
shared_server_sessions 385 0
shared_servers 1 0
transactions 429 610
It seems the major difference is MTS setting is removed after database migration , Is that a cause ?