Job is hunging after database migration
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Job is hunging after database migration

  1. #1
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433

    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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    stop guessing - trace the process and see what it is doing

  3. #3
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    Quote Originally Posted by davey23uk
    stop guessing - trace the process and see what it is doing
    Haha, Yes , I will TKPROF it .
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width