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…

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…

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…

This talk will build out the full solution architecture block diagram showing the end-to-end stack of Oracle cloud security features for Exadata and how to use them to protect data in public, private, and hybrid clouds.  Topics will include ssh access, network firewalls and software defined networks (SDN) in Oracle Cloud Infrastructure, platform firewalls (iptables),…

This talk will build out the full solution architecture block diagram showing the end-to-end stack of Oracle cloud security features for Exadata and how to use them to protect data in public, private, and hybrid clouds.  Topics will include ssh access, network firewalls and software defined networks (SDN) in Oracle Cloud Infrastructure, platform firewalls (iptables),…