Effective PL/SQL Code Insight With PL/Scope–or another reason to put code in the dtb
summary
A GDPR revision on a ~1,000,000‑line PL/SQL codebase finishes in nine months by enabling PL/Scope to index compiled PL/SQL, installing an APEX application to classify 700+ tables, and building a low-level API to centralize inserts/updates. PL/Scope cuts noisy regex hits (20,000 selects) down to ~50–60 statement occurrences and a short list of ~15 hotspots, lets nightly checks catch new columns, enables rewrites and daily deployments, and surfaces unused procedures and duplicate SQL.
AI-written summary · about
chapters (11)
- 0:00Introduction and speaker background
- 3:16Project background and challenges
- 14:09Discovering PL/Scope and its benefits
- 21:49Enabling and using PL/Scope
- 22:10Demo: PL/Scope in HR schema
- 34:47Finding procedure calls and dead code
- 37:58ETL package analysis and column references
- 41:39Troubleshooting with PL/Scope reports
- 43:30Success factors and lessons learned
- 48:06Modern project design with PL/Scope
- 49:10Q&A session
related talks
44mDebugging your PL/pgSQL code
52mExploring PL/SQL New Features and Best Practices for Better Performance
39mAccelerating PL/pgSQL Code Conversion
30mWrite scalable SQL with Oracle Autonomous Database
50mSupercharge your Code to Get Optimal Database Performance
44mImproving Performance with Intelligent Query Processing
45mBeing mindful of query optimizer
54mLessons learned from refactoring multi terabyte databases for the last 10 years