Case study how we have built our own private cloud based on Oracle Virtual Machine and OEM 12c cloud control. Learning Objectives: 1. Learn how to built cloud based on OVM 2. How to setup and bind OEM and OVM and how to keep it running 3. How to manage users and activity in your cloud. Whitepaper Powerpoint…

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.

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…

Ever wonder how to create and run a load test to discover system performance before go live?  The problem is usually time, cost and lack of resources.  This presentation will show how to potentially avoid negative performance situations in advance though designing and running a load test using JMeter.  It has a long and stable history and can run complex tests given time and effort.