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 a few hand-picked, favorite metrics, or wading through multiple specialized tables of information such as those found in an automatic workload repository (AWR) report, you can draw on all available data, applying big data methods and analytical techniques to help you draw impactful, focused performance improvement conclusions.   The DOPA process targets the most relevant metrics for the problem interval which results in event focused and actionable intelligence on the performance issue, and insight into possible solutions.  This method improves on the typical/traditional approaches which monitor a standard set of hard coded metrics; but the traditional approaches may cause you to miss important system behavior or configuration that is relevant to the root cause of the performance problem.  The speaker will share his DOPA process and code.

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.

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 information can be painstaking.  This presentation shows you many undocumented ways to proficiently use the underlying data to quickly get to tuning solutions.

  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 impossible, thus many DBA’s (and even the off-the shelf tools) monitor only a standard set of well-known metrics. This “small model” approach may cause you to miss important system behavior or configuration that is relevant to the root cause of the performance problem. The presenters approach to this “small model” meta problem is to massively expand and dynamically extract only the relevant performance metrics. This paradigm shift is achieved by normalizing the data and looking across a wide array of AWR performance metrics gathered during the problem interval. Querying across the normalized data and using statistical analysis, this approach flags unusual trends. By targeting the right metrics at the right time, you “bundle” relevant results which results in event focused and actionable intelligence on the performance issue, and a richer insight into possible solutions.

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 framework and developed some SQL queries that will help the DBA evaluate the solutions and extract the details and/or SQL needed to implement the solutions. This presentation takes a deep dive into the various ADDM tools, and details these custom queries against ADDM base data. Every DBA will leave this presentation with more confidence, new tools and approaches for solving Oracle database application performance problems. *ADDM (Automated Performance Diagnostics and Monitoring) is a key component in Oracle’s implementation of a self-managing database [part of the Diagnostics and Tuning pack license]. Within the persisted ADDM data, one will find solutions from automatic runs of the SQL Tuning Advisor , Segment Tuning Advisor, hourly ADDM runs, and more.

Even if you are a newbie to Oracle DBA profession, you know one thing is guaranteed - there will be an issue with performance at some point. How do you plan your activity? In this session, you will learn a methodical approach to troubleshooting performance issues in Oracle - making you more effective by executing…

Oracle Enterprise Manager Cloud Control 12c has introduced many new features that cover many different areas. Some of the new features are especially useful for the database administrator, such as visualization of performance data using ASH. This and other features have improved the management capabilities of the DBA.
Several exercises provide the student with the skills necessary to identify and isolate performance problems.

Oracle WebCenter Content 10g functionality was effectively contained in one container - the Content Server. This fact alone made it easy to deploy, administer, and customize. However, for all of these easy capabilities, the product was somewhat lacking on the scalability and performance side. With Oracle WebCenter Content 11g, and the inclusion of Oracle Weblogic Server, SOA and BPM, the product has expanded functionality and best-in-class performance and scalability. The new trade off is that these additional infrastructure components have created a layer of complexity causing delayed deployments and non-optimized systems. Come to this session as we discuss some strategies and tactics for tuning WebCenter Content 11g, including details around how and when to use reverse proxy and load balancing, so that you can truly optimize WebCenter and maximize your investment.