Oracle-L: zombie extent

From: Ray Stell <stellr_at_cns.vt.edu>
Date: Tue, 30 Apr 2002 12:39:36 -0800
Message-ID: <F001.004541F2.20020430123936@fatcity.com>

An associate is running a 8.1.5 db and he came to me with a horror story. I don't have specific info on the event, but it makes me wonder about the concept.

All users off the db, coming down for a cold backup. He said some extent owned by sys in TEMP ts was not released and so the db would not come cleanly or restart without an hour of recovery. I was wondering if I could get advice about how to investigate what process is associated with an extent. I am not sure how he associated the held TEMP extent with the hanging db.

A more generalized question is, if the db will not come down, how to poke and see what is hurt? I have a feeling this is closely guarded, secret sauce.

Ray Stell stellr_at_vt.edu (540) 231-4109 KE4TJC 28^D
--

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

Author: Ray Stell
INET: stellr_at_cns.vt.edu

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 Apr 30 2002 - 15:39:36 CDT