RE: Oracle SCN Question

From: Nick Wagner <NWagner_at_goldengate.com>
Date: Thu, 31 Jul 2003 13:24:23 -0800
Message-ID: <F001.005C80A1.20030731132423@fatcity.com>

Thanks... I think... except I'm not sure how to calculate that?

Nick

-----Original Message-----
Sent: Thursday, July 31, 2003 2:00 PM
To: Multiple recipients of list ORACLE-L

Hi,

It is just combination of Base and Wrap. So your number will be 8589934593

KG

• Nick Wagner <NWagner_at_goldengate.com> wrote:
  > 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).
  >
  

  ---

Have a nice day !!

---

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: K Gopalakrishnan
  INET: kaygopal_at_yahoo.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).

-- 
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 - 16:24:23 CDT