Re: stored procedure

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Mon, 1 Nov 1999 10:18:10 +0200
Message-ID: <7vjicc$3l0$1@ctb-nnrp1.saix.net>

Andreas Schwaiger wrote in message <3819d815.0_at_news.kabsi.at>...
>is there a possibility to run a stored procedure in
>the background? (dual processor machine)

Look at the DBMS_JOB package on how to submit stored procs as batch processes. You will also need to change your INIT ORA file to support job queues - look at the JOB_QUEUE_PROCESSES and JOB_QUEUE_INTERVAL parameters.

regards,
Billy Received on Mon Nov 01 1999 - 02:18:10 CST