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 free tutorial will identify some of the common issues, demonstrating techniques to determine whether the issue has occurred and if so what to do about it.

Audience: Oracle DBAs or Developers 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



Date Recorded: Nov 8, 2017

Free Online Registration Required

The tutorial session you want to view requires your registering with us.

It’s fast and easy, and totally FREE.

And best of all, once you are registered, you’ll also have access to all the other 100’s of FREE Video Tutorials we offer!