Supercharge your Code to Get Optimal Database Performance
summary
Code-level fixes beat bigger infra changes: turning off JDBC autocommit and grouping 10,000 inserts into one transaction cuts many log file sync waits and drops 10k-row load time from tens of seconds to single-digit seconds; using JDBC executeBatch (one example shows 10k inserts in ~73 ms) and bind variables eliminates hard parses and slashes CPU; inspect Oracle with v$session_wait, v$system_event and V$SESSTAT and watch LGWR redo activity to see where time goes; small DB monitor proofs are shown.
AI-written summary · about
chapters (14)
- 0:00Introduction
- 3:24Why this session
- 11:17Oracle Database
- 13:33Database Waiting
- 15:03Oracle Database 2010
- 19:53Commit
- 23:50Example
- 28:02When should we commit
- 31:56Setbased processing
- 32:55Database tier
- 37:16Log errors
- 38:22Bind variables
- 42:57Test
- 45:26QA
related talks
52mExploring PL/SQL New Features and Best Practices for Better Performance
30mWrite scalable SQL with Oracle Autonomous Database
36mHow to make your daily routine, code and database more efficient
41mUsing Databases to Pull Your Application Weight
46mMastering JPA Performance
52mJava Persistence and Hibernate Tips that can boost up your application performance
29mMySQL Performance for DevOps
58mTroubleshooting CPU Performance Issue for SQL Developers