Automating Identification of Inefficient DB Access in Oracle Applications

29 Jan 2019
11:15 - 12:00

Automating Identification of Inefficient DB Access in Oracle Applications

Very often our application suffers from bad SQL performance caused by inefficient data access. However, is’s possible to automatically identify such cases and to correct it either by defining more efficient indexes or rewriting SQL statement itself.

During the session we are going to look for a number of possible causes of bad performing SQL statements, discuss the methods for automatic identification of these causes and possible solutions, based on existing Oracle dynamic performance views.