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: 157

Filed under:

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

Related posts about Oracle