ORA-01555: snapshot too old: rollback segment ON STANDBY DATABASE
On primary this query run and end ok (1 sec)
On standby (active dataguard)
SELECT COUNT(*)
FROM PI_1 ebpi, ed_1 b
WHERE b.id = ebpi.ID
AND b.timestamp >= to_date('13/07/2016 03:05','dd/mm/yyyy hh24:mi')
AND b.timestamp < to_date('13/07/2016 03:06','dd/mm/yyyy hh24:mi');
*
ERROR at line 2:
ORA-01555: snapshot too old: rollback segment number 19 with name
"_SYSSMU19_2186058676$" too small
There are not blobs on this tables
5:53:20 SQL> select (62057/60)/60 query,(25000/60)/60 retention from dual;15:57:03 2
QUERY RETENTION
---------- ----------
17.2380556 6.94444444
16:02:41 SQL> show parameter undo
NAME
------------------------------------
TYPE VALUE
-------------------------------------------- ------------------------------
undo_management string AUTO
undo_retention integer 10800
undo_tablespace string UNDOTBS1