Releasing code changes to PL/SQL in heavily executed packages on databases with high uptime requirements brings many challenges. It’s not possible to gain the DDL lock to compile a package while it’s being executed, so how do you do so without downtime? In 11gR2, Oracle introduced edition-based redefinition (EBR). This allows you to deploy…

Many organizations maintain Microsoft Active Directory as an authoritative identity source for users and groups. When an employee or partner walks through the door for the first time - and the last time - chances are good that Active Directory is instantly updated to reflect the staffing change. This makes Active Directory the ideal identity…

This session will guide the attendee through the data dictionary where precious constraint information is stored. The location of this information is not readily obvious unless the techie has taken the time to figure this out before needing to intervene for RI issues on the fly thrown by applications. The white paper will present some…

While Oracle Multitenant capabilities for large-scale Database as a Service environments are well known, it provides important benefits for non-production environments as well. Developer productivity can ben enhanced by providing individual developers with their own, separate pluggable development databases, but done cost-effectively by sharing the resources of a larger database instance. Data refreshes and data…

Surprisingly many companies continue to provide Oracle Service Name Resolution solely through the TNSNAMES.ORA file.  Whether that file resides locally or in some networked location it still remains an unstructured file with critical data needed for application connectivity.  The thought of just using simple host files and not using a DNS server in a corporate…

Analyzing data reservoirs in the brave new world of big data can be very challenging and time-consuming. What if you could quickly and easily apply sophisticated analytical functions to any data—whether it’s in Hadoop/NoSQL sources or an Oracle Database instance—using a simple declarative language you already know and love? Welcome back to SQL! This presentation…

Successfully deploying and optimizing an Oracle Database environment can be a daunting task. In this session, you’ll learn about: The key ingredients for a successful Oracle Database 12c installation. A methodology to diagnose and remove performance bottlenecks by taking a closer look at the Red Hat Enterprise Linux 6 kernel parameters that can affect the…

Oracle logical replication based on redo log mining is used by many tools such as Golden Gate, Streams and others. There are 3 fundamental principles that govern how all these replication solutions work. The 3 principles are around conversion, identification and conflicts of the replicated data.This paper explains what the 3 principles are, how they…

Working with people in different timezones can be a challenge. Often we are requested to do some work for an internal organization of a external client at a time during which we are not working. The requested time may fall into someone's timezone who would be working during the time when the work has to…

Hasty and incomplete preparation are two of many pitfalls all too common when performing maintenance activities. The approach one uses to prepare and document work performned has a direct and dramatic influence on the likelihood the work will be done: at the right time in the right place in the correct order in a fashion…