DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: stuck in rollback error 1562

  1. #1
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    i am so shamed that in last 1 month , roolback seg confused
    me many many times.
    the rs tablespace is 1gb and autoexetend, all the 10 rbs r
    sized properly with initial ,next 1m , optimal 20m ,minextends 20,maxextends unlimited. but the application always report ora01562 error. I chek v$rollstat ,hwk is obly 23mb .

    Due the application limitation , I can not see the other error code follow 1562 , so what's the actual cause , I still can not get .

    Gurus , can save me ?
    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
    Feb 2000
    Posts
    175
    Hi,

    Are there any trace files generated? Is there anything in the Alert log?

    This error is usually accompainied by another error message that caused the failure....

    Regards
    Moff.

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well if you have batch jobs going may be 800MB + 20MB is not enough?

  4. #4
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    the roll seg is growing to 23 mb and stop
    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