Oracle: what information can I derive from the SCN?
Posted
by Mark Harrison
on Stack Overflow
See other posts from Stack Overflow
or by Mark Harrison
Published on 2010-05-19T22:32:16Z
Indexed on
2010/05/19
22:50 UTC
Read the original article
Hit count: 177
Oracle
Given an SCN (system change number), and assuming an SCN for which the data is still in the undo logs, what information about the SCN can I derive?
of course, SCN_TO_TIMESTAMP() gives an approximate time the data was committed.
Is there any other information I can derive? What transaction, what tables, what data were affected? etc?
© Stack Overflow or respective owner
