Oracle database tuning can be an incredibly difficult task, particularly when working with data which is constantly changing and evolving every second. In fact, a very busy database will often encounter performance issues or disruptions which often result in business chaos. Many administrators try to address performance disruptions by tuning system-level parameters (i.e. CPU, Memory, etc…). However, these issues are better addressed by analyzing and tuning the queries which applications submit to the database for processing.
In the first part of this 2-part series, Janis Griffin, Database Performance Evangelist, SolarWinds, discussed how to quickly identify disruptors in the database. This second video dives deeper, focusing on tuning techniques, identifying coding mistakes and knowing what to do if you can’t change the code to improve performance.