Re: Starting an autonomous session from a client

From: Richard Kuhler <noone_at_nowhere.com>
Date: Wed, 29 May 2002 18:31:16 GMT
Message-ID: <U79J8.28336$wj7.9497638@twister.socal.rr.com>

Using a job is probably the easiest way. See the documentation for DBMS_JOB.SUBMIT. You should read up on the limits for the number of simultaneous jobs (36 in 8i, 1000 in 9i, see JOB_QUEUE_PROCESSES parameter). Also be aware that some Oracle features (replication & AQ?) use jobs themselves.

Richard

"Patrick J." wrote:
>
> Hi,
>
> I would like to be able to start from a client an Oracle session for running
> a procedure that is quite long to execute. I would like it to be an
> autonomous session, so that it can continue running even if the session on
> the client is terminated.
>
> I am currently running on Oracle 8.1.7 database on Linux.
>
> How can I achieve this?
>
> Thanks,
>
> Patrick J.
Received on Wed May 29 2002 - 13:31:16 CDT