How to make your daily routine, code and database more efficient
summary
Shows concrete failures and fixes: a hidden backspace character in datafile name that makes three files appear identical, a deployment where missed patch on 1 of 25 databases breaks tests, and ADF apps that do ADF filtering client-side causing 10k-row choke and drive WebLogic to 100% CPU. Recommends automating installs and env creation (shell/Perl/Python/Ansible), moving set-based work into SQL instead of row loops, and tracking PL/SQL changes with Git mounted via DFS.
AI-written summary · about
chapters (8)
- 0:00Introduction and speaker background
- 4:39Database file naming issues
- 11:08Automating database tasks
- 16:51Understanding application platforms
- 21:50Testing with realistic data sets
- 26:14Debugging and problem-solving techniques
- 33:27Time management and queueing systems
- 35:29Q&A and closing remarks
related talks
50mSupercharge your Code to Get Optimal Database Performance
36mUnlocking the Benefits of Database DevOps and Automation
20mDave & James’ Excellent Database Adventure: From Code Errors to Reliable Releases
33mTips and tricks for the Oracle Database developer- 20mExcellent Database Adventure: From Code Errors to Reliable Releases
31m10 Costly Database Performance Mistakes (and How to Fix Them)
31mDevOps Practices for the Database Team
57mPatterns of SaaS: Refactoring Databases