Forum Stats

  • 3,734,278 Users
  • 2,246,936 Discussions


ORA-01555: snapshot too old: rollback segment number 6 with name "_SYSSMU6_$" too small

0614 Member Posts: 115 Red Ribbon

Hi Folks,

Using Oracle database - 19C DB

Taking table snapshot at the first second of every hour, getting the ORA-01555: snapshot too old issue,

Below is the undo_retention  size

undo_retention  integer 600 

below is the code used in the procedure

insert into t_emp_log

select *

FROM emp AS OF TIMESTAMP v_timstamp emp;

Could you please check and do the needful?



  • EdStevens
    EdStevens Member Posts: 28,143 Gold Crown

    Perhaps you should "do the needful' and show us the code. Somehow I doubt you are actually doing this against the 'emp' table, which I assume is from the well known sample schema. And it obviously is taken from a pl/sql procedure that is somehow populating a variable named v_timstamp with some unknown (to us) value.

    Your undo retention is only trying to guarantee 10 minutes.

Sign In or Register to comment.