-
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
-
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.
-
well if you have batch jobs going may be 800MB + 20MB is not enough?
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|