Check the existence of any trace files dated 20 hours ago or more recent
ones.
Also if the killed transaction involved a big indexed table , then dropping
all the indexes on that table can speed the recovery (if they are not
locked) a lot.
This is if the transaction was inserting, or updating/deleting some of the
indexed columns.
Regards,
Waleed
-----Original Message-----
Sent: Sunday, June 10, 2001 2:00 PM
To: Multiple recipients of list ORACLE-L
Hi All,
I have an interesting problem, on one of my databases, a data warehouse, a
killed session was taking too long
to rollback. It was time for the backup, and I had to do a shutdown abort.
No its time to open the database, instance parallel recovery is taking place
as normal, but the problem is,
its being running for more than 20 hours and the database is still not open.
Does any body have any clues, thoughts, ideas ?? Is there anyway I can see
what exactly the dbms is up to ?
The instance processes running are completely idle
Thanx
K Naik
______________________________________________
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relating to the
official business of Standard Bank Investment Corporation (Stanbic) is
proprietary to the company. It is confidential, legally privileged and
protected by law. Stanbic does not own and endorse any other content. Views
and opinions are those of the sender unless clearly stated as being that of
Stanbic.
The person addressed in the e-mail is the sole authorised recipient.
Please notify the sender immediately if it has unintentionally reached you
and do not read, disclose or use the content in any way.
Stanbic can not assure that the integrity of this communication has
been maintained nor that it is free of errors, virus, interception or
interference.
_______________________________________________
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Khedr, Waleed
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).
