This content has been marked as final. Show 2 replies
Streams is capable enough to handle large amounts of transactions.
In your case, we need to understand more in actual problem, hence require more inputs from you as below:
what is the Oracle version you are using?
Capture & apply parameters? what you have set..
streams pool size ?
no. of CPU's on server?
Refer the Meta Link document
Streams Performance Recommendations [ID 335516.1]