Home » Server Options » Streams & AQ » streams state is paused for flow control (Oracle10.2.0.3.0 Linux 4.4)
streams state is paused for flow control [message #324304] Sun, 01 June 2008 22:04 Go to next message
rainiering
Messages: 2
Registered: June 2008
Junior Member

The capture process state of the source database is paused for flow control,the repication failed.

I don't know why?

Can you help me and tell me How can I do for it?
Re: streams state is paused for flow control [message #328836 is a reply to message #324304] Mon, 23 June 2008 00:53 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Check the status of each apply, propagation.
Re: streams state is paused for flow control [message #345784 is a reply to message #324304] Thu, 04 September 2008 15:16 Go to previous messageGo to next message
sriramkalyan
Messages: 7
Registered: November 2007
Location: Silver spring MD, USA
Junior Member


Too many transactions , capture is not able to find memory to process them.

Solution, add rules to capture, before you start capture.

Rule should be like capture only DMLs for specific owner ..
that way .. you can reduce number transactions.

Creating Ruleset * Rule

BEGIN
-- Create the rule set
DBMS_RULE_ADM.CREATE_RULE_SET(
rule_set_name => 'strmadmin.owner_rules',
evaluation_context => 'SYS.STREAMS$_EVALUATION_CONTEXT');
-- Create the complex rules
DBMS_RULE_ADM.CREATE_RULE(
rule_name => 'strmadmin.dml_owner',
condition => ' :dml.get_object_owner() = ''AEDBA1'' AND ' ||
' :dml.is_null_tag() = ''Y'' ');
DBMS_RULE_ADM.ADD_RULE(
rule_name => 'strmadmin.dml_owner',
rule_set_name => 'strmadmin.owner_rules');
END;
/

then before you start capture,

Alter capture add ruleset strmadmin.owner_rules

then start capture
Re: streams state is paused for flow control [message #345822 is a reply to message #345784] Thu, 04 September 2008 23:09 Go to previous messageGo to next message
varunvir
Messages: 329
Registered: November 2007
Senior Member
what do you mean by;-
condition => ' :dml.get_object_owner() = ''AEDBA1'' AND ' ||
' :dml.is_null_tag() = ''Y'' ');

Stream capture would not start automatically once the flow control is fine?
Re: streams state is paused for flow control [message #346816 is a reply to message #324304] Tue, 09 September 2008 14:46 Go to previous message
sriramkalyan
Messages: 7
Registered: November 2007
Location: Silver spring MD, USA
Junior Member



it should be

condition => ' :dml.get_object_owner() = ''USER'' AND ' ||
' :dml.is_null_tag() = ''Y'' ');

USER : source schema name which you are replicating
Previous Topic: Getting C001: long running txn detected in alertlog
Next Topic: Oracle Streaming
Goto Forum:
  


Current Time: Sat Aug 23 13:09:18 CDT 2014

Total time taken to generate the page: 0.07683 seconds