|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
Don't you just hate it when Oracle break their own links. :)
I've corrected it now. Thanks for the heads-up.
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!
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'')
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!)
Yep. A bad bit of copy&paste. :) I've corrected it now. Thanks for the heads-up.
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 ?
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!