RE: Oracle Streams is stuck.
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <Yuval.Arnon@xxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 27 Aug 2007 16:08:19 -0400
Have you tried looking at V$TRANSACTION for the XID identified in the
alert log?
The XID consists of three hexadecimal numbers, separated by periods, in
your case, 0x000b, x0x024, and 0x0085874b. These correspond to the
XIDUSN, XIDSLOT, and XIDSQN columns in V$TRANSACTION. But, in
V$TRANSACTION, they're in decimal. So, either manually convert each to
decimal, or, Tom Kyte has a nice set of base conversion routines
available here:
http://asktom.oracle.com/tkyte/hexdec/index.html
Hope that helps,
-Mark
--
Mark J. Bobak
Senior Database Administrator, System & Product Technologies
ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346
Ann Arbor MI 48106-1346
+1.734.997.4059 or +1.800.521.0600 x 4059
mark.bobak@xxxxxxxxxxxxxxx <mailto:mark.bobak@xxxxxxxxxxxxxxx>
www.proquest.com <http://www.proquest.com>
www.csa.com <http://www.csa.com>
ProQuest...Start here.
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Arnon, Yuval
Sent: Monday, August 27, 2007 2:57 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Oracle Streams is stuck.
Hi,
I've configured uni directional Streams on Win NT 32 bit, Oracle
10.2.0.3. Currently it was only streaming one schema with one table in
it.
The capture process was working fine for a few days.
Today I am getting:
C001: long running txn detected, xid: 0x000b.024.0085874b in the alert
log, but can not find any long running transactions in our DB.
In addition the capture process seems to be stuck at log mining one arch
log. (I stopped and started the capture process to verify).
I tried to use log miner to view contents of V$logmnr_contents, but the
'SELECT * FROM V$logmnr_contents' will not complete even I if let it run
for 30 minutes.
Any help will be appreciated.
TIA
Yuval
This transmission may contain information that is privileged,
confidential and exempt from disclosure under applicable law. If you,
oracle-l@xxxxxxxxxxxxx, are not the intended recipient, you are hereby
notified that any disclosure, copying, distribution, or use of the
information contained herein (including any reliance thereon) is
STRICTLY PROHIBITED. If you received this transmission in error, please
immediately contact the sender and destroy the material in its entirety,
whether in electronic or hard copy format. [neumann.webloyalty.com]
Other related posts:
