Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links

Comments

DBMS_PARALLEL_EXECUTE - Use the DBMS_PARALLEL_EXECUTE package to break down large workloads into manageable chunks that can be run in parallel.



Tomasz said...

It's very nice :)

David Mann said...

Didn't even know this existed, thanks for sharing!

SysDba said...

Oracle® Database PL/SQL Packages and Types Reference 11g Release 2 (11.2) Part Number E16760-05
DBMS_PARALLEL_EXECUTE >> download.oracle.com/docs/cd/E11882_01/appdev.112/e16760/d_parallel_ex.htm

Tim... said...

Hi.

Don't you just hate it when Oracle break their own links. :)

I've corrected it now. Thanks for the heads-up.

Cheers

Tim...

SysDba said...

;]

guest said...

example copied from MOS

Tim... said...

No it wasn't! I did it myself. There was no MOS note available when I wrote this. Perhaps they copied me!

Tim...

Jim said...

In the second of the "Complete Examples", I got a compilation error when trying to create the process_update procedure. I fixed it by changing the line

t.session_id = SYS_CONTEXT(''USERENV'',''SESSIONID'')

to

t.session_id = SYS_CONTEXT('USERENV','SESSIONID')

(I've been using your articles to help me study for my OCP upgrade exams ever since 9i - many thanks for your fine work!)

Tim... said...

Hi.

Yep. A bad bit of copy&paste. :) I've corrected it now. Thanks for the heads-up.

Cheers

Tim...

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

Add your comments here.
Name
Comment
(max 400 chars - plain text)