 |
|
PL/SQL parallel processing
Oracle Tips by Burleson Consulting |
Oracle has a wealth of
parallel features including parallel query, parallel DML, but it is also
possible to perform parallel processing on Oracle using PL/SQL.
If using a shell script
environment (ksh, bash), you can invoke parallel PL/SQL programs with the nohup
command:
nohup sqlplus
system/manager exec xxx &
nohup sqlplus system/manager exec yyy &
nohup sqlplus system/manager exec zzz &
The ampersand invokes the
sqlplus in the background, such that the nohup commands ate invoked serially,
but execute in parallel. For return processing, you can write a simple
daemon process to verify positive return codes ("process executed
successfully"),
Within PL/SQL you can invoke
parallel threads using parallel pipelined functions.
