Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Multithreading in Oracle

Re: Multithreading in Oracle

From: <sybrandb_at_yahoo.com>
Date: 12 Jul 2006 05:58:38 -0700
Message-ID: <1152709118.391988.244870@b28g2000cwb.googlegroups.com>

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
Received on Wed Jul 12 2006 - 07:58:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US