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 06:01:08 -0700
Message-ID: <1152709268.562299.170480@p79g2000cwp.googlegroups.com>

Arun wrote:
> Hi Experts,
>
> There is no support for multithreading in PL/SQL.
> Is there any proper reason for not having such a support?
>
> Regards,
> Arun

Is there any proper reason for having it? When it comes to it LGWR is the central bottleneck, and running n processes in parallel doesn't make it n times faster, but n times slower.
You already have parallel execution, don't you? Do you use it?

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Wed Jul 12 2006 - 08:01:08 CDT

Original text of this message

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