| Need help to understand in depth about ORA-01555 [message #524223] |
Thu, 22 September 2011 05:11  |
sathik
Messages: 196
Registered: August 2009
Location: INDIA
|
Senior Member |
|
|
Hi,
I am getting the below error in alert log file,when my application calling a procedure.
ORA-01555 caused by SQL statement below (Query Duration=1576 sec, SCN: 0x09a2.5dda3165):
Fri Sep 16 16:33:40 2011
UPDATE SSPT_NETWORK_DETAILS SET INCLUDE_OFFERS = 'Yes' WHERE SESS_ID = SESS_ID
There is no ROLLBACK statement in my procedure.
As per my understanding, the ORA-1555 error will occur,
1. The required old image is not in the undo,when we rollback the trasaction.
2. the select query may face this error because of delayed block cleanout concept.
But I don't know why this update statement causing this 1555 error? Can anybody help to clarify this?
|
|
|
|
|
|
| Re: Need help to understand in depth about ORA-01555 [message #524239 is a reply to message #524235] |
Thu, 22 September 2011 06:11  |
sathik
Messages: 196
Registered: August 2009
Location: INDIA
|
Senior Member |
|
|
Hi Michel,
Thanks for your response.
Quote:Because Oracle cannot (re)build the block as it was at the time the update started.
I am not clear in your answer.Can you please give me some more detail?
why oracle has to (re)build the block? Also this update statement is running 200 to 250 times per hour. every time, it is updating 10 to 50 records only.
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
