BLK1: Introduction to Bulk Processing (PL/SQL Channel)

The first lesson in the bulk processing series, this video discusses why bulk processing is needed to improve SQL performance from PL/SQL blocks.

========================================
Practically Perfect PL/SQL with Steven Feuerstein

Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.

[paulwhite]

excellent, your explanations are very informative!

[WorldEye]

Thank you for the great details. Could you please advise on the use of compound trigger on a BULK COLLECT statement.

[rajit]

Hi Steven, can you please provide the zip containing demo codes?

[praveenkumar-fxwx]

Hi Sir,

Is there a way we could implement parallel processing in PL/SQL ?
Like we use bulk collect and the execution is serial row by row say 100k rows. Is there a way to divide these 100k rows in batches of 10k rows and run all 10 instances of the procedure at once (parallel run) if yes can you please put a video with some example ?

[Info-Galaxy]

Hi Steven, thank you for uploading the video. I have a doubt when we process the huge no.of records using the "FORALL", the undo log grows, in such cases will it leads to performance issues when a commit is issued as it has to move lots of data from undo log to permanent storage.
Another doubt is: is it suggestable to use bulk collect when I have less no.of records, let's say 1000 or 5000 or can I go directly with the FOR loop!! Please suggest