Re: Parallel Processing

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 29 Nov 2001 18:38:33 -0000
Message-ID: <9u5vga$1ia$1@news7.svr.pol.co.uk>

Check out dbms_job. This can be used for processing asynchronous requests. For a full queue processing system you can also use advanced queueing (dbms_aq et al).

hth
connor

"Thomas Geng" <Thomas.Geng_at_ch.pwcglobal.com> wrote in message news:9u5ci8$4nd$1_at_rex.ip-plus.net...
> Hi everybody,
>
> i have the following task:
>
> While starting a client application some data are loaded into a session
> specific temporary table, which takes a lot of time.
> How is it possible to trigger the loading of the temporary table as a
> parallel task, while the application finishes the start procedure and then
> waits for the end of the loading task. The mechanism should be like a
> separate thread, which loads the data parallel to the starting thread.
>
> P.S.: The session ID in the load task must be the same as in the client
> application. The loading function is written in PL/SQL.
>
> Thanks a lot, Thomas
>
>
Received on Thu Nov 29 2001 - 12:38:33 CST