Old entries in V$STREAMS_TRANSACTIONS .
edited Feb 5, 2012 10:46PM in GoldenGate, Streams and Distributed Database (MOSC) 7 commentsAnswered
Hello community ,
According to Oracle Docuementation , this view hold information of the LCR'S being processed by capture or apply process .
Information about a transaction remains in the view until the transaction commits or until the entire transaction is rolled back.
I am working on a single HUB and several SPOKES . SO is Solaris SPARC 64 5.10 and Oracle 10.2.0.5 .
I am facing a very strange behaviour .
There are old entries in V$STEAMS_TRANSACTION .
Example :
SELECT
STREAMS_NAME , STREAMS_TYPE , CUMULATIVE_MESSAGE_COUNT , FIRST_MESSAGE_TIME, XIDUSN , XIDSLT , XIDSQN,
LAST_MESSAGE_TIME , TOTAL_MESSAGE_COUNT
FROM
V$STREAMS_TRANSACTION ;
Output :
According to Oracle Docuementation , this view hold information of the LCR'S being processed by capture or apply process .
Information about a transaction remains in the view until the transaction commits or until the entire transaction is rolled back.
I am working on a single HUB and several SPOKES . SO is Solaris SPARC 64 5.10 and Oracle 10.2.0.5 .
I am facing a very strange behaviour .
There are old entries in V$STEAMS_TRANSACTION .
Example :
SELECT
STREAMS_NAME , STREAMS_TYPE , CUMULATIVE_MESSAGE_COUNT , FIRST_MESSAGE_TIME, XIDUSN , XIDSLT , XIDSQN,
LAST_MESSAGE_TIME , TOTAL_MESSAGE_COUNT
FROM
V$STREAMS_TRANSACTION ;
Output :
| STREAMS_NAME | STREAMS_TYPE |
0