Re: Multithreading in Oracle

Volker Hetzer wrote:
> Arun schrieb:
> > Hi Experts,
> >
> > There is no support for multithreading in PL/SQL.
> > Is there any proper reason for not having such a support?
> Count me in too.
> Regardless of whether multithreading is the way to go, but
> when doing mass dml (like cleaning out a bunch of tables)
> I'd like to run several statements in parallel.
>
> Lots of Greetings!
> Volker
> --
> For email replies, please substitute the obvious.

And what would that accomplish? Only that your database is running much slower (while your trying to suffocate LGWR), than when you ran these statements consecutively!
Some people always think more is better and never learn. This is the kind of 'smart' that is actually 'stupid' when you think about it.

-- 
Sybrand Bakker
Senior Oracle DBA