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…

The biggest headine at the 2009 Oracle OpenWorld was when Larry Ellison announced that Oracle was entering the hardware business with a pre-built database machine, engineered by Oracle. Since then businesses around the world have started to use these engineered systems. This beginner/intermediate-level session will take you through my first 100 days of starting to…

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

Tips and Tricks for migrating 10TB data from AIX (2 Nodes and v10.2.0.4)to Exadata X3 (8 Nodes and v11.2.0.3) with only 6 hours of downtime. Database included Oracle Label Security, 40 Partitioned Tables, 4 Tables with Oracle Text Indexes, LOB Columns for 5 Tables and for one table a CLOB column had not to be…