p_cir_32: z35 Oracle errors
- Article Type: General
- Product: Aleph
- Product Version: 16.02
Description:
I'm seeing this in the p_cir_32 job log:
Oracle error: fetch z35
ORA-01555: snapshot too old: rollback segment number 9 with name "_SYS
And the following in the Oracle alert_log:
ORA-01555 caused by SQL statement below (Query Duration=3700 sec, SCN: 0x0000.06aa2515):
select * from mbb50.z35 where z35_time_stamp >= :v1
What should be done?
Resolution:
You should kill this job and try running it at night (when fewer updates are occurring to the z35).
See also, KB 8192-2519.
Additional Information
ORA-01555
- Article last edited: 10/8/2013