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...

Ashraf Nashed said...

In your example here : "User-defined framework",
when you use "EXECUTE IMMEDIATE l_sql_stmt USING l_start_rowid, l_end_rowid;"
Does this still support parallelism or it turns to sequential ?

Tim... said...

Ashraf: You would run that same code in several sessions. Each would just get the next chunk and processes it.The more sessions you run it in, the more parallel the operation would be.

It would make sense to submit these as jobs. :)

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)