Internally, Oracle represents SCNs as a base and a wrap. The wrap is a 16-bit number and the base is a 32-bit number. A dump of a redo log file would display the SCN as 0x0000.00000000. However, the SCN is represented as a number in a number of the dynamic performance views (v$log.first_change# for example). What does this numeric value represent? Is this just the SCN base, or is it a combination of base and wrap. If the wrap is 1, 2, or 3, etc., what is the value displayed in the dynamic performance views for the SCN?
For example, if the SCN was 0x0002.00000001, what would that evaluate to as a single number? Thanks, Nick Wagner -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nick Wagner INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
