Re: smon.trc file

From: Danisment Gazi Unal (ubTools) <dunal_at_ubTools.com>
Date: Thu, 17 Jun 2004 12:43:26 +0300
Message-ID: <005801c4544f$8dd0d6c0$fe19100a@danismentgu>

Hi,

>From the trace excerpt, SMON had posted 5 parallel recovery slaves to
recover dead transaction of 0x0004.045.00001fae. Since a single transaction had recovered by multiple revovery slaves, this is an intra-transaction recovery.

It looks like normal operations. This message may have been suppressed in the newer versions.

You can ignore it if the reason of dead transaction is not important.

Also,

There is another interesting message similar to this message behavior:

ORA-0: "normal, successful completion"

best regards...

http://www.ubTools.com
Web Based Oracle Products and Services

Original Message ----- From: "Schauss, Peter" <peter.schauss_at_ngc.com> To: "Oracle-L (E-mail)" <oracle-l_at_freelists.org> Sent: Wednesday, June 16, 2004 10:13 PM Subject: smon.trc file

> For one of my production instances, the admin/<sid>/bdump directory
> contains a file called smon_22764_<sid>.trc with entries which look like
this:
>
> *** 2004-03-18 13:16:56.063
> Using 5 slaves for 1 dead transactions
> Recovered xid: 0x0004.045.00001fae in 0 milliseconds; nchk=0, size=3651
>
> What are these entries and what do the statistics mean?
>
> Thanks,
> Peter Schauss
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Jun 17 2004 - 04:40:58 CDT