Re: smon.trc file
- From: "Danisment Gazi Unal (ubTools)" <dunal@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 17 Jun 2004 12:43:26 +0300
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@xxxxxxx>
To: "Oracle-L (E-mail)" <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
