Discuss the features on 18c that are important to the DBA and/or Developer.  Discuss the new Autonomous Database and what that means for the DBA and/or Developer.  Look at the future ahead for Tech and Oracle.

Oracle Database 18c will be the world's first autonomous database. It will be self-driving, self-tuning, self-scaling, self-securing and self-repairing. This session will have a closer look at those features that build the foundation for the self-driving and self-repairing nature of Oracle Database 18c, as those features are meant to enable the database to meet user-defined…

Oracle Real Application Clusters (RAC) provides a rich feature set on all supported platforms. There are, however, some Oracle RAC features that are only available on Oracle's Engineered Systems, in particular, the Oracle Exadata Database Machine. If you are interested to see what you get extra in those environments and how various functionalities are designed to…

With an ever-growing number of available virtualization and container solutions as well as cloud computing orchestration tools, the question arises which of these solutions and tools are best suited to operate an Oracle Database, in particular an Oracle RAC database? This session will therefore provide an overview of supported solutions and tools to operate an Oracle RAC database.

While Oracle Real Application Clusters (RAC) was not available in the Oracle Cloud for the longest time, it now has found its way into the Oracle Cloud in form of multiple, integrated RAC offerings, which differ in their infrastructure and yet all aim to deliver the same level of service that Oracle RAC is known…

This presentation is about SQL statement parsing, what it is, how it affects database performance, and how to detect and correct parsing problems.  We begin by defining what parsing is, and then walking through it in detail.  This includes the initial checks (syntax, semantics, permissions), SQL_ID generation, and pointer creation from client process to private…

Oracle Database 12c is the first release to offer the capability to access a file in HDFS or HIVE format as an EXTERNAL table. Through live and recorded demonstrations, this session will explain how an Oracle DBA can leverage these new features to gather data in tabular format from these file formats while leveraging the…

This presentation discusses the developer tools (and effort) used to create Graph theoritic model of an Oracle equipment datawarehouse. A graph has nodes and edges and their ranking (based on # of adjecent nodes) was critical in the final decision making. The uniqueness of this approach is to take generic Relational tables and look at…

Oracle has lots of metrics, many can be confusing.  Lets walk through a few examples of some specific Oracle metrics and discuss what the mean.  Don’t have a statistics background, no problem.  I’ll try to put these examples into plain common English.  DBA’s need to use Oracle statistics properly to help make important decisions about…

The fact that triggers are written in PL/SQL creates a lot of bad publicity for this language because, for many IT professionals, database triggers and performance issues are synonymous. Sadly, there is a lot of truth in this statement. Very few features in the Oracle realm are misused as often as are triggers. The situation is so bad that some of the most outspoken Oracle gurus currently have database triggers included in their lists of things that should never have existed!

This presentation does not take such a radical stance. If you can make DBAs, developers, and architects actually communicate while designing software, the chances of using any feature properly are significantly better. There is nothing “evil” about triggers. They just have to be used where they can actually solve problems.

In this presentation, both table triggers and INSTEAD-OF triggers will be examined from a global system optimization point of view that includes, not only the aspect of functional correctness, but also the tradeoffs between multiple goals. For example, depending upon the available hardware, developers can select either CPU-intense or I/O-intense solutions.

Another key point will be the need to keep your knowledge up-to-date. For example, compound triggers should be used much more frequently for both functional reasons (resolving self-mutation) and performance reasons (bulk operations on tables and simulation of STATEMENT-level behavior on views) This presentation will focus on the most common performance problems related to different kinds of DML triggers and the proper ways of resolving them.