Apache Kafka is a massively scalable message queue used for building real-time data pipelines and streaming applications that are high-performing and fault tolerant. This presentation will introduce Kafka from the perspective of a mere mortal Oracle DBA and share the experience of (and challenges with) getting events from relational databases to Kafka. We’ll demonstrate…

The open source streaming data platform, Kafka, is taking the world by storm. In their own predictions for 2017 Oracle even asserted that “Kafka looks to be the runaway Big Data technology of 2017”. A powerful platform in its own right, Kafka is designed, from the ground up, as a fast, scalable, durable, distributed system.…

As the complexities of Oracle solutions continue to grow, providing IT environments a simplified way to automate key processes of software delivery and changes within IT infrastructure is of utmost importance. With the use of containers, system administrators, database administrators, and software developers can take advantage of delivering Oracle databases and their closely tied applications…

Let’s revisit the ways to programmatically load data into an on-premise or Cloud Oracle database.  Many applications need to load data from external sources as some part of the workflow. What is the best data load option for your environment and your requirements?  Is your spreadsheet data CSV or true XLSX? Are you loading CLOBs or LOBs? What are the APEX data load options? Which data load methods work in a Cloud database? What methods make most sense for your users, for your environment, for your budget? This presentation reviews a collection of data load options, including the APEX Data Load wizard, external tables, ORDS bulk data load, open source interfaces, plugins and APEX APIs helpful for custom coding.

Demonstrations and examples are geared toward APEX applications, yet most of the techniques described can be used in any PL/SQL application. Attendees gain sufficient knowledge to make an intelligent choice for their application data loading needs.

Oracle Databases are a target of cyber-attacks by hackers looking to obtain sensitive data such as credit card numbers and personally identifiable information used in identify theft. Even though databases are not externally accessible, they are still a target as most cyber-attacks penetrate the network perimeter and look for high value targets within your internal network. Based on lessons learned from recent high-profile cyber-attacks, a framework and techniques for detection and prevention of these cyber-attacks against database will be presented.

To properly secure an Oracle database requires significant effort and often expensive security add-on products.  The Thrifty DBA likes having secure databases, but doesn’t like to spend money on expensive security products when equivalent zero or low-cost solutions are available.  The Thrifty DBA will show you thrifty yet effective auditing and logging solutions for the…

In this session I will share some of experience on migrate or upgrading different versions of Oracle databases to the Oracle 12cR2. This session will discuss the difference between upgrade and upgrade when you should use which method. We will also focus the latest 12cR2 upgrade tools and various upgrade 12cR2 paths/methods that help you…

Oracle 12.1 Multitenant  offers cost effective, high database consolidation density coupled with excellent isolation.  The Oracle 12.2 Multitenant new feature called Application Containers significantly improves agile application deployment and  management at scale.  When used in accordance with best practices, Application Containers plays a vital part in agile development for Continuous integration-Continuous Delivery (CICD) application development models.  This session will introduce the basic…

Do you want to surf a tidal wave of performance? Oracle Database In-Memory, with its industry-first dual row/column in-memory format has you covered! In this session we will introduce Database In-Memory and review some of its class leading technologies that enable billions of rows per second analytic data access while simultaneously enabling superfast OLTP performance.…

The open source streaming data platform, Kafka, is taking the world by storm. In their own predictions for 2017 Oracle even asserted that “Kafka looks to be the runaway Big Data technology of 2017”. This being the case there's no better time to start learning it. So what is it? Well, technically speaking it is…