Performance tuning can be complex. It's often hard to know which knob to turn or button to press that will give you the biggest performance boost. The presentation will detail 12 steps to quickly identify performance issues and fix them. Learning Objectives: 1. The participant will learn how to quickly fine tune a sql statement using…

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.

Oracle Enterprise Manager 12c is one of the most versatile manageability tool in the market helping enterprises to monitor and enabling Application-to-Disk management  through a single pane of glass for all data center components.As an Enterprise Manager administrator you are responsible of a wide variety of tasks including discovering and maintaining targets, deploying plugins, tuning…

Developers need data and environments cloned from production, for coding, for testing, for quality control and performance.  Ideally, each developer should have their own full private environment, representing a full stack of database, app-servers, and web-servers, private to themselves, to allow each to work without interfering with another.  In other words, their own complete build…

Are you constantly wondering what is in your production environment? Do you have any doubts about what code is running? Chances are that your version control software isn't the problem. No matter what system you're using there is the ideal and there is the practice. This session is one that will help you get on…

A typical tuning session on a resource-constrained system starts with a search for "low-hanging fruit."  In a CPU-bound database system, it would be the SQL that uses CPU the most, in an I/O-bound system, the SQL doing the most physical reads, and so on. Tuning the TOP statements often allows us to free large portions…

Patch management is a critical and time consuming task for many database administrators. We will present our experience building the Cloud Control 12c (CC12c) infrastructure for the Health Care Quality Improvement Systems (HCQIS) of the Centers for Medicare and Medicaid Services (CMS). We will focus on the lessons learned and best practices for patching Oracle…

Services are a critical part of the IT group, DBAs, Developers, System Administrators all have customers some internal and some external to our organization.  There are always challenges to helping our customers understand what we do, to understand our customer’s expectations and manage to meet our customer’s expectations as well as manage those expectations.  In…

The Expert Panelists/Speakers will present a comprehensive overview of the Oracle Database Cloud Service offerings by covering Best Practices, Experiences, Insight, Tips and, a whole lot more about employing/deploying the Oracle Database Server family on Oracle's Public Cloud. Learning Objectives: 1. How to Setup/Configure & Leverage the Oracle DB Server Family on Oracle's Public Cloud Infrastructure…

The Best Practices for Moving your Oracle Database to the Cloud session will outline and detail best practices for DBAs, IT and developers. The session will go over how best to move your on-premises Oracle Database and other development instances to a Public Cloud. This entails data and development platform migration.  And also includes what…