| ora-01555 [message #121457] |
Sun, 29 May 2005 23:57  |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi
my question is.....that
Is there is any way to solve this error ora-01555 without increasing size of rollback segment ...(i.e undo segment)? If yes than how we can do it ?
Note:- This question was asked to me in an interview and the interviewer told me yea there is a way ...... now can any one tell me how to solve this error ora-01555 without increasing size of rollback segment
From :- sunilkumar vishwanath mishra
|
|
|
|
|
|
| Re: ora-01555 [message #121688 is a reply to message #121457] |
Tue, 31 May 2005 09:05  |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
|
undo_retention is the key paramter...you could always change the queries you run, as in run shorter queries that would not be as dependent on undo space for as long. And/or you could modify the dml you do to slow down the generation of new undo.
|
|
|
|
| Re: ora-01555 [message #121942 is a reply to message #121688] |
Wed, 01 June 2005 17:30 |
William Robertson
Messages: 1643
Registered: August 2003
Location: London, UK
|
Senior Member |
|
|
Also creating more rollback segments gets you increased rollback resource without increasing the size of the one specified in the error message, though I suspect that is not what the interviewer was looking for, and in any case you should be using Automatic Undo Management.
I hope they were actually trying to see how well you understood Oracle's read consistency system. If so, that's a top interview question.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
