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…

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.…

Oracle Enterprise Manager 12c is the now positioned to be the monitoring tool for many Oracle and Non-Oracle products in an enterprise.  One such application is critical to any high-availability or disaster recovery solution; Oracle GoldenGate.  The ability to monitor Oracle GoldenGate ranges from manual monitoring to using Oracle Enterprise Manager 12c.  With the enhancements…

Imagine a world where a Database Administrator could simply order a new database and in less than 1 hour an e-mail arrived confirming it had been completed.  What about adding additional storage or adjusting the amount of memory or CPU, for an existing database, simply from a web page.  EMC IT built a private cloud…

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…

Many organization struggle to take control of their environment monitoring challenges - especially for databases. Shell scripts and cron jobs are great, but what happens when functionality changes or when a new database version is introduced? How about that one DBA who spent 5 years developing all the scripts and then leaves the company without…

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…

Discover how Openstack can be used to manage your Infrastruture. Deploy a complete OpenStack environment on you notebook using Virtualbox, Solaris x86, Oracle Linux and a virtual ZFS Storage array. OpenStack is a popular open source cloud computing software enjoying widespread industry involvement, provides comprehensive self-service environments for sharing and managing compute, network, and storage resources…