Wait Dependency in Oracle Streams(with parallelism>1 for Apply Server)
412134Apr 8 2004 — edited Oct 9 2006We have configured Streams over 9.2.0.4 successfully exept that, I had a few queries regarding the parallelism parameter of the apply server. I have set the PARALLELISM parameter for the Apply Server to 2. and the COMMIT SERIALIZATION => 'NONE'
The problem is that the the Apply server is executing transactions sequentially even if there is no dependency between the transactions. For exampe, by executing the following transactions in the production database :
Session 1 => 5000 Inserts in schema1.tab1
commit
Session 2 => 1000 Inserts in Schema1.tab2
commit
<Both the transactions are independent of each other>
The 2 independent transactions should ideally be given to 2 different Apply Servers which is not happening in this case.
The other apply server shows the status of "WAIT DEPENDENCY" even though the COMMIT SERIALIZATION parameter is set to 'NONE'. The behaviour is similar when the parameter is set to 'FULL'.
On executing the following transactions in the production database across 2 different schemas :
Session 1 => 5000 Inserts in schema1.tab1
commit
Session 2 => 1000 Inserts in Schema2.tab2
commit
<Both the transactions are independent of each other>
The behaviour in this case is normal since both the apply server are in the Executing state. Does that mean Oracle Streams identifies all transactions within the same schema as dependent and across schemas as independent?
It would be really great if i can find an answer to this question.
Thanks in advance.......
Regards,
Raj