| Rollback segment error [message #53567] |
Sun, 29 September 2002 06:06  |
Shankar Subramanian
Messages: 1
Registered: September 2002
|
Junior Member |
|
|
Hello,
We are getting this error while I run a plsql process (just to update 20 records).
ORA-01555: snapshot too old: rollback segment number 1 with name "R11" too small
ORA-06512: at line 33
DBA says we have about 10 G in rollback segment space.
Snapshot too error bothers me.. No one else doing anything in the database.
When we took all the rollback segments offline, and created one big rollback the process completed.
(again next day, we had the smae problem even with one big rollback segment).
Any idea/suggestion of what might be happening..
According the dba, there is nothing wierd going in the db. We do have siebel server running on this db. I don't know whether siebel (which I hate) is causing problem.
thanks in advance for your help
shankar
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
