Oracle SCN Question

From: Nick Wagner <NWagner_at_goldengate.com>
Date: Thu, 31 Jul 2003 10:24:24 -0800
Message-ID: <F001.005C8031.20030731102424@fatcity.com>

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: NWagner_at_goldengate.com

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: ListGuru_at_fatcity.com (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). Received on Thu Jul 31 2003 - 13:24:24 CDT