Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Multithreading in Oracle
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 DBAReceived on Wed Jul 12 2006 - 08:01:08 CDT