Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Location
    Shanghai , China
    Posts
    63

    Unanswered: stuck in rollback error 1562

    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 ?
    Oracle is an ocean . I am just a little fish

  2. #2
    Join Date
    Oct 2002
    Location
    Boston, MA
    Posts
    5

    Cool Re: stuck in rollback error 1562

    Originally posted by ligang
    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 ?

    Hi,
    The rollback segments may not be the true problem. What is the query running that causes the error? You may have a cartesian join or something that would cause a rollback segment to run amok. Also, I wouldn't advise unlimited extends -- that could bring everything to a halt!

    Regards,
    Bella

Posting Permissions

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