Murali: The transaction can be considered DEAD for number of reasons. You can see the status of the transaction at anypoint of time using by querying the X$KTUXE.
KTUXESTA will give you the transaction status for any given transaction and KTUXEFL will give the transaction flag (DEAD if it is DEAD transaction) and the KTUXESTA will show the STATUS of the transaction (INACTIVE/ACTIVE/COMMITED) To find the transactions which are DEAD in your database you can use this sql. SELECT *from X$KTUXE where KTUXECFL='DEAD'; Transaction STATUS is exposed via V$TRANSACTION and you can query the V$transaction for a known transaction id. There are also few events , like 10013/10015 to trace the instance recovery/rollback segment recovery. I would suggest you set this events to identify the DEAD transactions. Best Regards, K Gopalakrishnan Bangalore, INDIA ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, May 16, 2002 8:03 PM > Murali > > I have seen them occasionally in our 8.1.7 database, generated during a > database recovery. The recoveries in question complete normally so I > haven't researched the details. > > Mike Hand > Polaroid Corp > > -----Original Message----- > Sent: Wednesday, May 15, 2002 9:48 PM > To: Multiple recipients of list ORACLE-L > > > Hello list > > I am for the first time seeing a message like this in the SMON trace file. > --- > Using 1 slaves for 1 dead transactions > Recovered xid: 0x000e.00a.00004971 in 20 milliseconds; nchk=0, size=2327 > --- > I have not seen this message before, any ideas ... > > Murali Vallath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan 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).
