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…

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…

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…

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…

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…

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…