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 query access times. It…

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…

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…

Strategies to migrate Enterprise Applications such as the E-Business Suite, Hyperion and Oracle Business Intelligence to the hybrid cloud (public + private) are discussed; business requirements, constraints, Application-level Service Level Agreements (SLAs) within the confines of the multi-tenant distributed architecture analyzed. Different computing platforms, storage technologies, networking options, automated Disaster Recovery scenarios, a Return on…

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 a new hint) to show the basic functionality of the new features.  The speaker has been working with the Beta 12c program.

Oracle in the 2014 edition of its Open World rolled out new database public cloud service with its DBaaS offerings, but this is just a piece in each company's technological architecture. Businesses still have the need to create a Private cloud and discover the driver to create it; Wether it is a measured service,consolidation or rapid provisioning,…

Riyaj 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. Riyaj will also discuss a few internal troubleshooting events to understand how IM is populated, scaned etc. Just for a good measure, you will also take…

Oracle has introduced database deployment technologies in Oracle 12c to support managed consolidated private database clouds and DBaaS deployments. This session is targeted at architects and administrators tasked to design and deploy such systems. It will review the availability and management issues such as ensuring critical services start first and go down last, workloads stay…