RE: Lite: Redo sequence poll

From: Freeman, Robert <Robert_Freeman_at_csx.com>
Date: Tue, 12 Mar 2002 11:41:31 -0800
Message-ID: <F001.00426000.20020312114131@fatcity.com>

I wonder if any Oracle database has ever yet experienced an absolute SCN wrap??

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him.

-----Original Message-----
Sent: Tuesday, March 12, 2002 1:20 PM
To: Multiple recipients of list ORACLE-L

A high transaction database, such as those at amazon.com

Jared

"Hand, Michael T" <HANDM_at_polaroid.com>
Sent by: root_at_fatcity.com
03/12/02 08:28 AM
Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        RE: Lite: Redo sequence# poll

Ok Jeremiah,
I'll warrent that Redo sequence# is a uneven measuring stick.

Longest since last restart - 6/22/01
Oldest                     - 7/24/96
Highest SCN                - a pokey 366 802 309

What kind of environment gets you to a 13-digit SCN?

Mike

-----Original Message-----

My stats:

Longest time since last restart (uptime) - 08/30/2001 (v$instance - startup_time)

Oldest database - 11/05/1999 (v$database - created)

High SCN - 5551718526045

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Hand, Michael T
  INET: HANDM_at_polaroid.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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

Author:
  INET: Jared.Still_at_radisys.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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

Author: Freeman, Robert
  INET: Robert_Freeman_at_csx.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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 Tue Mar 12 2002 - 13:41:31 CST