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…

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…

  Developers often need their DBA’s to provide quicker identification and analysis on sub-optimal SQLs during load test cycles and peak production usage of the application. This becomes crucial, especially when the load test cycles are denser and there are relatively huge number of SQL statements in the entire application. Effective performance management and diagnosis…

  Developers often need their DBA’s to provide quicker identification and analysis on sub-optimal SQLs during load test cycles and peak production usage of the application. This becomes crucial, especially when the load test cycles are denser and there are relatively huge number of SQL statements in the entire application. Effective performance management and diagnosis…

AWR collects and persists thousands of performance metrics every hour; the problem is: the root causes of performance anomalies are difficult to detect and it is difficult to know which metrics/attributes are important for DBA’s to focus on to inform their root cause analysis and solutions. A full understanding of these thousands of metrics is…

AWR collects and persists thousands of performance metrics every hour; the problem is: the root causes of performance anomalies are difficult to detect and it is difficult to know which metrics/attributes are important for DBA’s to focus on to inform their root cause analysis and solutions. A full understanding of these thousands of metrics is…

ADDM* regularly runs behind the scenes and persists various performance tuning solutions that often go unnoticed by the DBA. Since DB performance problems can escalate quickly, the use of these persisted solutions can transform the DBA’s ability to skillfully devise a tuning action plan. To leverage these preexisting solutions, the presenter “reverse engineered” the advisor…

ADDM* regularly runs behind the scenes and persists various performance tuning solutions that often go unnoticed by the DBA. Since DB performance problems can escalate quickly, the use of these persisted solutions can transform the DBA’s ability to skillfully devise a tuning action plan. To leverage these preexisting solutions, the presenter “reverse engineered” the advisor…

The time-based analysis of SQL performance issues is taught and lived actively throughout the database world. It proved its value many times, and is often a good way to solve problems. But with only little or no knowledge of the application behind, performance analysts have difficulties monitoring the timing behavior of software components in a…