Exploring PL/SQL New Features and Best Practices for Better Performance
summary
Live demos use SQL Plus and SQL Developer and include runnable scripts; a loop inserting 1,000,000 rows drops from ~42s to ~2.5s with for all bulk DML, constructing arrays first; building 100,000 distinct INSERTs inflates shared pool to ~300MB but switching to bind variables reduces that to kilobytes; a PL/SQL function with result cache pays one 1s cold run then returns subsequent calls in 0s; PL/SQL_OPTIMIZE_LEVEL/pragma inline halves tight-loop time.
AI-written summary · about
chapters (15)
- 0:00Introduction
- 0:50About Ami
- 4:53Sequel Developer
- 6:07Orchid Database 4
- 7:14Single Developer
- 11:24Passing Time
- 16:14Bulk
- 19:08Save Exceptions
- 20:32Bulk Insert
- 22:48Caching
- 26:17Example
- 28:09P0 Sequel Example
- 34:55Stop Programming Lining
- 39:24Optimize Level
- 47:34Summary
related talks
30mWrite scalable SQL with Oracle Autonomous Database
50mSupercharge your Code to Get Optimal Database Performance
42mEfficient Data Handling Techniques in Python for Oracle Database
45mPerformance tricks you have never seen before 2.0
50mEffective PL/SQL Code Insight With PL/Scope–or another reason to put code in the dtb
07mLoading Millions of Rows of Test Data in Seconds
44mDebugging your PL/pgSQL code
01h 00m7 Tips to Performance Tuning, Optimization, and Everything