I have some queries concerning what bpel variables and values will be stored to Dehydration store in case oracle bpel. Consider I have an process "P1" with two scopes: an outer scope "s1" with variables "s1a,s1b,s1c" and within this s1 scope there is a nested inner scope "s2" with variables "s2a,s2b,s2c". When the process instance ends or if there is a wait activity at the end of outer scope s1, then the process state will be moved to dehydration store.
My question here is would oracle soa server store all the variables of both scopes s1 and s2 to dehydration store or since s2 scope is like a local loop within s1, would oracle only persist variables and values of processes of the outer scope s1 alone?
The reason why i ask is that the inner scope S2 in my process case handles a very huge xml of size more than 20 MB and i do not want this to be dehydrated to datastore at the end of process execution as this will fill up the soa table space quickly.