Hi all, I have a job which picks a record from a cursor and then it calls a stored procedure which processes the record picked up from the cursor. The stored procedure has multiple queries to process the record. In all, procedure takes about 0.3 seconds to process a single record picked up by the cursor but since cursor contains more than 1 Lac records it takes hours to complete the job. The queries in the stored procedure are all optimized I was thinking of making the procedure run in multi threaded way as in java and other programming language. Can it be done in oracle? or is there any other way I can reduce the run time of my job.