Multi-Threaded PL/SQL

From: Dogan Cibiceli <dcib_at_gwl.com>
Date: Wed, 09 Jun 1999 17:26:31 -0600
Message-ID: <375EF827.EE59970A@gwl.com>

Hi,
I have a curious question. To utilize the database to max ( in off time), I would like a procedure to run several diff. instances. Each instance of the procedure will work on one part of the huge table and the parts will be non-overlapping. Is there a feature in Oracle that lets me call a procedure (PL/SQL) and go on without waiting for its results. The procedure will have its own thread of execution. I would like to spawn (fork) 10 instances of the same procedure. Does that make sense also ??

PS. Or back to basics and write a shell script or something like that ? Received on Wed Jun 09 1999 - 18:26:31 CDT