We have a BPEL process running in SOA 10G, This picks up data from DB, as the payload is huge we pick 50 records in 1 shot.
Now we are moving to SOA 11G, we presume that we should be able to pick up a bigger payload in SOA 11G.
Can someone please advice me in 11G how much big or times payload can we pick.
I've successfully tested once fetching the data from the table and wrote a file of the order of 49 MB. As this will be also dependent on the environment configuration, I'd suggest to try once and test by yourself.