Re: Starting an autonomous session from a client

nohup sqlplus -s user/pwd @script (where script ends w/ an 'exit') on unix if jobs don't work for ya.

On Wed, 29 May 2002 18:31:16 GMT, Richard Kuhler <noone_at_nowhere.com> wrote:

>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.
>

.......
We use Oracle 8.1.7.3 on Solaris 2.7 boxes remove NSPAM to email Received on Thu May 30 2002 - 17:16:40 CDT