Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How to achieve Parallel execution on Tables and SP's
Hi,
I want to know how Oracle will handle Parallel execution and
synchronization on Table and SP's when multiple sessions are accessing
the same object.
For example I have one SP called Test_SP and this SP gets executed by
2 different sessions at same time. The Test_SP contains few DML
operations like Deleting rows from a table and some Inserts. In this
scenario how we can achieve parallelism and synchronization such that
multiple sessions can access them in Parallel for producing good
performance gains. Also when we use GLOBAL TEMPORARY Tables with ON
DELETE CASCADE option will it provide Synchronization and parallelism
automatically or de we need to set any parameters explicitly. Please
provide your comments, this is very much needed for my project
requirements.
Thanks
Rao
Received on Fri Feb 02 2007 - 00:25:18 CST