Re: SMON reports Dead Transactions - Not seen this before

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" <ORACLE-L_at_fatcity.com> 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: kaygopal_at_yahoo.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).