I have a current process: a large procedure in one schema.
There is a plan to have
A, B1, B2, B3 schemas (B-schemas are identical, could be B-n schemas) in Oracle 12c database.
B1, B2, B3 have synonyms to A.
A stores all the connections information to other schemas.
Is it possible to run a stored procedure in
A and call the stored procedure in other
B-schemas (dynamically determine schemas to run and do it in parallel).
There is also .Net part and it is better to put this logic there and make calls to the
B-schemas stored procedure in different threads?