RE: SMON reports Dead Transactions - Not seen this before

2002-05-16 Thread Hand, Michael T
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

Re: SMON reports Dead Transactions - Not seen this before

2002-05-16 Thread K Gopalakrishnan
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

SMON reports Dead Transactions - Not seen this before

2002-05-15 Thread Murali Vallath
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.4971 in 20 milliseconds; nchk=0, size=2327 --- I have not seen this message before, any ideas ... Murali Vallath