Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a streams replication set up between two oracle instances as sources and an 11g instance as a destination, processing a small subset of data from each database (let it be one table with no unsupported types and all supplementary logging enabled for this case).

Each source instance has a capture and propagation process. One of the instances works as expected, another one has issues with capture. Here's what I see in v$streams_capture:

17:09:25 STRMADMIN > select total_messages_enqueued, elapsed_capture_time, elapsed_rule_time, elapsed_enqueue_time, elapsed_lcr_time
17:10:04   2  from v$streams_capture;

----------------------- -------------------- ----------------- -------------------- ----------------
                      0               682521                 0                    0              337

Elapsed: 00:00:00.16

I infer that the logminer process actually processes a number of redo log entries (elapsed_capture_time=682521), creates LCR objects (elapsed_lcr_time=337), but for some reason never evaluates the rule set (elapsed_rule_time=0), and therefore has no objects to enqueue (elapsed_enqueue_time=0).

So, at this moment I actually ran out of ideas why could that happen. Tried several approaches up to full streams reinstallation without any luck. Probably miss something very close.

Any ideas on this?


share|improve this question
Can you provide the output from this: select capture_name, STATUS, ERROR_MESSAGE from dba_capture; And any trace or log containing the error message? –  Threaten Dec 28 '12 at 17:46
@Threaten there are no (visible) errors or warnings. capture process' status is active. it just does nothing (or something I mentioned above) –  be here now Dec 29 '12 at 8:42

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.