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 [EMAIL PROTECTED] (540) 231-4109 KE4TJC 28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
