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.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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).

I tried several approaches up to full streams reinstallation without any luck.

Any ideas?

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.