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 ?
1. www.dbasupport.com
2. www.dbforums.com
3. www.itpub.net
4. www.csdn.net
5. www.umlchina.com
6. www.tek-tips.com
7. www.cnforyou.com
8. fm365.federal.com.cn
9. www.programmersheaven.com
10.http://msdn.microsoft.com/library/default.asp
ligang1000@hotmail.com