RE: Shutdown abort

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Thu, 08 Aug 2002 06:48:25 -0800
Message-ID: <F001.004AEED5.20020808064825@fatcity.com>

Stefan

   Well, I finally found a good reason for studying for OCP! I would not have known this answer without being forced to study.

   It depends on your Oracle version. The Oracle 8i answer is:    On startup, Oracle performs recovery, including rolling forward all transactions. Oracle then opens the database for production use. In the background, SMON continues to roll back transactions that were not committed when the database shut down. If a process needs a block that was involved in an uncommitted transaction, then SMON goes ahead and rolls back that transaction so the process doesn't have to wait.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Thursday, August 08, 2002 7:58 AM
To: Multiple recipients of list ORACLE-L

Hi list

stupid one: In case of a shutdown abort and startup, are the rollback activities discontinued after startup and the rollback segs are available again ? or not ?

regards,
Stefan  

--

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

Author: Stefan Jahnke
  INET: Stefan.Jahnke_at_bov.de

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: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.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 Thu Aug 08 2002 - 09:48:25 CDT