Скачать или смотреть Bulk Processing in PL/SQL

"Row by row = slow by slow" - one of Tom Kyte's more famous and catchy memes. Row by row processing of data is so not the way to go. How to avoid it? Fully leverage SQL to do set processing and if that doesn't totally do it for you, then "fall back" on FORALL and BULK COLLECT. These are just about the most important performance features of PL/SQL, and Steven Feuerstein takes a close look in our October Office Hours session.

Highlights:

00:30 Introduction, review of Office Hours program
03:32 Why is bulk processing needed?
10:19 BULK COLLECT to retrieve more than one row with each fetch
15:25 FORALL for repeated execution of non-query DML
30:13 Converting row-by-row to bulk processing

Then on to Q & A.

39:27 How can I convince developers of the performance benefit of BULK COLLECT?
42:00 Use global temporary tables + SQL instead of FORALL?

AskTOM Office Hours offers free, monthly training and tips on how to make the most of Oracle Database, from Oracle product managers, developers and evangelists.
Music by bensound.com

https://asktom.oracle.com/

Oracle Developers portal: https://developer.oracle.com/
Sign up for an Oracle Cloud trial: https://cloud.oracle.com/en_US/tryit

Music by bensound.com