Rice shares some of the issues with RMAN that he stumbled upon during implementation and daily usage.

Implementing Column Independent Oracle Partitioning over Loosely Correlated Columns using Oracle Database 10g Materialized Views  Oracle as of Oracle 10gR2 does not provide an efficient method for tables to be simultaneously partitioned by two or more statistically independent columns. Dougherty discusses a proven approach for reducing search space for multi-terabyte tables in such cases.

Nanda lists best practices that stem from both his readings as well as from working for along time as a production support and architect DBA. He summarizes some of those practicesthat cater to “real life.”

Original Broadcast: 6.05.13 Watch this webcast to learn how CernerWorks, the remote hosting division of Cerner, a global health IT company, upgraded their Oracle Enterprise Manager system from 11g to 12c. We will discuss available upgrade paths and why we chose what we did. With thousands of databases managed, a focus on high availability, ease of…

Memory serialization control is core to Oracle database operations. When serialization is used, how it works, how we can influence its operation, and how we diagnose problems is one of the most fascinating topics in Oracle internals and performance optimization. But it's a complex situation. To get the upper hand on serialization control this presentation…

Join Jim Czuprynski as he gives his take on the 13 most important new features that the next generation of the Oracle database presents for Oracle Database Administrators and Exadata Database Machine Administrators. In these two 1-hour sessions, he'll focus on the latest features that make complex database and DBM administration tasks simpler, increase database…

Oracle Enterprise Manager 12c is the comprehensive enterprise management suite for applications to infrastructure. It has been significantly improved compared to previous versions. However, if you already have a previous version deployed and you need to take advantage of all the features in 12c you need to have a solid path for doing so. Fortunately, Enterprise Manager provides the framework for seamlessly upgrading your environment.
We will examine how this workflow enables a relatively small environment can be used to upgrade from 10g to 12c using the 2-System Method.
We will take a look at how Mercy used this method to migrate between platforms, upgrade repository database version while upgrading to Enterprise Manager Cloud Control 12c.

Original Broadcast: 5.8.13 Featured Speaker: John Diamond, Principal Solutions Architect at Entuity   Oracle Enterprise Manager has made tremendous advances in managing the critical technologies that interact to ensure application availability and performance. But an important piece is missing—the network. Without information about how the network is supporting your crucial applications and databases, you’re left with…

SQL Tuning is a daunting task. Too many things affect the Cost-based Optimizer (CBO) when deciding on an Execution Plan. CBO statistics, parameters, bind variables, their peeked values, histograms and a few more are common contributors. The list of areas to analyze keeps growing. Over the past few years Oracle has been using SQLTXPLAIN (SQLT)…