Common Oracle SQL Tuning Errors
We see some SQL performance (coding) problems in the Oracle Database over and over again: certain SQL constructs that are known to be inefficient in some circumstances. If you understand your data and queries, you may be able remove these inappropriate usages and improve response times hugely. This webinar will identify some of the common issues, demonstrating techniques to determine whether the issue has occured and if so what to do about it.
This free webinar will benefit any Oracle DBA or Developer faced with underperforming SQL.
In addition to Oracle SQL, some experience with reading execution plans is essential. For review and/or practice reading execution plans, see How to Read an Execution Plan.
Instructor: SkillBuilders’ Director of Oracle Database Services John Watson
Lessons (more lessons coming soon!)
- Common Oracle SQL Tuning Errors | Lesson 1 – Validating and tweaking the Design for SQL Performance April 10, 2018+
- Common Oracle SQL Tuning Errors | Lesson 2 Readable Code Helps April 10, 2018+
- Common Oracle SQL Tuning Errors | Lesson 3 Join Conditions April 10, 2018+
Date Recorded: Nov 8, 2017