The relationship between Oracle SCN and timestamp

Sql> Conn/as SYSDBA

Sql> Select SCN, To_char (TIME_DP, ' Yyyy-mm-dd hh24:mi:ss ') from Smon_scn_time;

The correspondence between the timestamp and the SCN is recorded in the Sys.smon_scn_time table, and the corresponding relationship of the timestamp to the SCN is recorded every five minutes .

The table records the corresponding relationship of the last 1440 timestamps to the SCN.

This article from "The Memories of Tao elder brother" blog, reproduced please contact the author!