With the release of Oracle Database 12c, new features and functionality are introduced through the Oracle Enterprise Manager 12c plug-in that are associated with the release. Learn how to manage Oracle Database 12c with Oracle Enterprise Manager 12c. In this session, you will learn what to expect with the new plug-in, how to provision pluggable…

The most widely anticipated feature of Oracle Database 12c is now available, and you may be wondering just how you can move your current databases to pluggable databases in a multitenant architecture. Whether you are just starting to explore the world of pluggable databases or are planning a production upgrade in the near future to…

Oracle Data Guard is Oracle’s recommended product of choice for Disaster Recovery (DR). This presentation covers the new features and enhancements to Data Guard in the Oracle Database Server 12c. This presentation specifically covers how to configure Oracle Data Guard with Container Databases. Also included is how to optimally use OEM Cloud Control 12c with…

Most of the time, the foreground or shadow process is traced to understand what the composition of the responsetime is. However, when doing (batch) DML, both the logwriter and databasewriter are key processes for the overall responsetime. To gain understanding of these processes, tracing gives an insight into what they are doing. The goal of…

APEX forms are reports are a quick way to develop a tool do data quality checks and data clean up. It provides a way to report and modify the data with appropriate security for multiple teams. This quick tip session will walk through develop of the reports and forms, and the business reasons for using…

Oracle RAC Policy-Managed Database (PMD) is a powerful but so far rarely used feature introduced in Oracle Database 11g Release 2 to automate the instance administration in a dynamic, multi-node cluster. The aim of this presentation is to review how PMD works, how to implement and administer it successfully, and how to benefit from this…

With Oracle Database 12c some features are being deprecated like streams and advanced replication. With this deprecation we have to replace this functionality. In this presentation we will introduce Golden Gate as the replacement for these features. We will cover the basic architecture of Golden Gate and it functionality that can more then just a…

A picture is worth a thousand words. This is especially true during performance problem investigations where a well done graph of the issue can often cut resolution time from days to mere minutes. ORACLE database provides a wealth of performance information, but unfortunately only a small part of it is currently visualized by standard tools,…

Managing tnsnames.ora files across an enterprise with dozens or hundreds of database servers and hundreds or thousands of client machines is a complete nightmare. Oracle's solution, OIM/OID is horrendously complex, to say the least. So, what's a DBA to do? Fortunately, there is a solution. This presentation will cover the installation of the widely available,…

Oracle 12c offers new features in statistic gathering, histograms and baselines. These features will make a difference in reviewing execution plans, which is a common task for most DBAs, SQL developers, and performance experts. A solid understanding of the new features and how they affect the execution plan will be presented. Also, baselines will be…