Tuesday, March 18, 2008

SMON_SCN_TIME - SCN

It is a table owned by SYS User and is filled by SMON every 5 minutes with a timestamp and the current SCN. However, it only counts 1440 records (=5 days). This makes it possible to roughly find an SCN for a point in time in the last 5 days.

No comments: