Oracle multiple processes updating same table
There are several things that must be done to configure your system for shared server. You activate shared server by setting database initialization parameters.
Shared server requires that an Oracle Net Services listener process be active.
The shared server architecture requires Oracle Net Services.
User processes targeting the shared server must connect through Oracle Net Services, even if they are on the same machine as the Oracle instance.
UPDATE products_description AS pd SET pd.products_seo = ( SELECT pd2.products_seo FROM products_description AS pd2 WHERE pd2.language_id = 1 AND pd2.products_id = pd.products_id ) WHERE pd.language_id This is rather risky business, and I can understand why.
In general, it is better to be connected through a dispatcher and use a shared server process.
Each client connection is bound to a virtual circuit.