Your ASH repository is a veritable gold mine of performance information and while the GUI interface in OEM is very pretty and easy to use, it has its limitations.  In this session, I'll be showing several examples of how sifting thru the ASH data directly via SQL can shed new light on some common problems.…

Have you ever faced a plan performance regression in your Oracle database after a version upgrade? One of your core's production SQLs suddenly changed its execution plan slowing down your application? SQL Plan Management (SPM) 12c is the ultimate plan stability solution to prevent plan performance regressions by giving you the flexibility to tell the CBO…

Oracle Database 12c introduced two new histograms – Top Frequency and Hybrid – that can dramatically improve the accuracy of cardinality estimates, construction of better execution plans, and speedier access to skewed data sources.  This presentation will offer real-world examples of how best to deploy these features, including actual metrics that illustrate the improvement in…

The Enterprise Manager 12c Release 4 is accompanied with the new AWR Warehouse feature, which allows you to automatically extract detailed performance data from your database targets and consolidate the data into a central repository within the AWR Warehouse. The main source of data stored in the AWR Warehouse is derived from the Automatic Workload Repository (AWR), via AWR snapshots, letting you unlimited historical AWR data from chosen EM12c database targets, enabling long-term analysis of AWR data across databases without impacting the source.

SQL*Net. Parser. Planner. Executor. Have you ever wondered how the Oracle Database consumes your SQL, parses/plans/executes your query, and gives you a result set?  In this session, we'll take a walk through the core components of the Oracle Database as we explore the life of a query from beginning to end.  Through this process you…

“Why isn’t my query using an index?” is one of the most common questions beginners have when tuning SQL. This talk explores the factors that influence the optimizer’s decision behind this question. It does so by comparing fetching rows from a database table to finding all the red M&Ms across a number of bags of…

This presentation will look at which 12c tuning features should be investigated for use.  Many of the tuning features that will be covered will be related to the DBA, but there will also be a few outside that realm that focus on the developer.  There will be simple examples (such as a quick example using…

I will discuss internal details about inmemory option, processes and memory structures, v$ views, some of the practical issues that we encountered testing a multi-terabyte database with this product. I will also discuss a few internal troubleshooting events to understand how IM is populated, scaned etc. Just for a good measure, we will also take…

Original Broadcast: Tuesday, May 26, 2015 Security is a concern of every IT manager and it is clear that perimeter defense, trying to keep hackers out of your network, is not enough. At some point someone with bad intentions will penetrate your network and to prevent significant damage it is necessary to make sure there…

With the rapid adoption of cloud and the emergence of thecollaborative development operations (DevOps) approach withinenterprises, there’s been a great deal of speculation and discussionon the future of the database administrator role. Some punditscited the ever-accelerating needs of enterprises to push productsand services to market as quickly as possible, and to leveragecloud solutions and automation…