Forum Stats

  • 3,770,233 Users
  • 2,253,082 Discussions
  • 7,875,370 Comments

Discussions

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

0614
0614 Member Posts: 121 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?

Tagged:

Best Answer

  • EdStevens
    EdStevens Member Posts: 28,533 Gold Crown
    Accepted Answer

    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.

Answers

  • EdStevens
    EdStevens Member Posts: 28,533 Gold Crown
    Accepted Answer

    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.