One of the most common SQL Tuning problems is when the Oracle cost-based optimizer misestimates the expected number of rows that will be returned from an execution plan row source operation. This presentation delves into uncharted waters to help attendees understand strategies for dealing with cardinality misestimates.

The methods used to track performance issues in SQL and PL/SQL vary based on the level of access within a system.  A developer in cooperation with a DBA, or already granted DBA privileges can has a wide variety of tools and deep visibility.  However, a user with nothing more than CREATE SESSION and SELECT privileges…

The methods used to track performance issues in SQL and PL/SQL vary based on the level of access within a system.  A developer in cooperation with a DBA, or already granted DBA privileges can has a wide variety of tools and deep visibility.  However, a user with nothing more than CREATE SESSION and SELECT privileges…

  Transform your ability to quickly respond to the challenge of ensuring high performing DB’s. The key to this transformation is to expertly use the advisor framework which underlies tools such as ADDM, SQL Tuning Advisor, Segment Tuning.  These tools provide actionable advice to the DBA seeking to solve performance problems, but getting at this…

  Transform your ability to quickly respond to the challenge of ensuring high performing DB’s. The key to this transformation is to expertly use the advisor framework which underlies tools such as ADDM, SQL Tuning Advisor, Segment Tuning.  These tools provide actionable advice to the DBA seeking to solve performance problems, but getting at this…

  Use the innovative Dynamic Oracle Performance Analytics (DOPA) approach that relies on big data and advanced analytical techniques to analyze and improve Oracle Database performance. The approach discussed in this presentation is accessible and easy to use, but more importantly it represents a step-change paradigm shift away from traditional methods. Instead of relying on…

  Use the innovative Dynamic Oracle Performance Analytics (DOPA) approach that relies on big data and advanced analytical techniques to analyze and improve Oracle Database performance. The approach discussed in this presentation is accessible and easy to use, but more importantly it represents a step-change paradigm shift away from traditional methods. Instead of relying on…

  Use the innovative Dynamic Oracle Performance Analytics (DOPA) approach that relies on big data and advanced analytical techniques to analyze and improve Oracle Database performance. The approach discussed in this presentation is accessible and easy to use, but more importantly it represents a step-change paradigm shift away from traditional methods. Instead of relying on…

  Transform your ability to quickly respond to the challenge of ensuring high performing DB’s. The key to this transformation is to expertly use the advisor framework which underlies tools such as ADDM, SQL Tuning Advisor, Segment Tuning.  These tools provide actionable advice to the DBA seeking to solve performance problems, but getting at this…

This presentation is about SQL statement parsing, what it is, how it affects database performance, and how to detect and correct parsing problems.  We begin by defining what parsing is, and then walking through it in detail.  This includes the initial checks (syntax, semantics, permissions), SQL_ID generation, and pointer creation from client process to private…