Oracle Database In-Memory introduces a new in-memory columnar format that is compatible with all existing applications. This session will explore how Database In-Memory enables "Real-Time Analytics" by allowing analytic style queries to be run directly on source data. It will also explore the key performance enhancing features of Database In-Memory including in-memory scans, predicate push down, hash joins with bloom filters, vector group by aggregation, and new high-performance features like In-Memory Expressions and Join Groups.

When databases get ever larger and larger, backing them up using traditional RMAN backupsets will quickly get unfeasible. Completing a backup requires too much time and resources, but more importantly the same also applies to restores. RMAN has always provided a solution as incrementally updated image copies, but they are much less manageable than backupsets.…

Providing the highest levels of availability is the main goal of Oracle’s Maximum Availability Architecture (MAA), which has been available for more than a decade. What started as a set of blueprints and best practices for high availability (HA) for the Oracle Database has evolved into the de-facto standard when it comes to operating the…

AWS engineers from the Relation Database Service (RDS)  will explain what you can do to make your Oracle database licenses go farther in AWS. Virtual Machine choices can make a large difference on how far your existing licenses will take you in the cloud. There are also EC2 and RDS configuration settings that will allow…

With the recent release of Oracle Database 18c Express Edition (XE), a gap has been filled with Oracle's free set of Rapid Application Development (RAD) tools available for the developer to be able to create applications.  Now with Oracle Database 18c XE, Oracle SQL Developer, Oracle Application Express (APEX), and Oracle Rest Data Services (ORDS),…

Learn how to use simple algorithm analysis for Oracle performance tuning.  Finding the mathematical functions that describe the computational complexity of different operations can help us understand and predict performance.  This presentation will discuss common functions such as 1/N, LOG(N), N, N*LOG(N), N^2, and N!, and how they can help us understand operations such as…

Wikipedia defines infrastructure as code as "the process of managing and provisioning computer data centers through machine-readable definition files, rather than physical hardware configuration or interactive configuration tools." This principle greatly simplifies setting up and managing large server parks, it also helps with repeatability and auditability in all environments. In a traditional Oracle database world…

Oracle's Fusion Middleware SOA suite is one of the most useful yet underutilized set of tools available to developers. To offer better services, businesses are forced to grow in complexity. As a result, integration with heterogeneous data sources and cloud services becomes necessary.  The downside of this trend is that businesses loose ability to effectively…

Stumped by how to implement least privileges model for your database and reduce your cyberattack surface?  You know it's something you're supposed to do, but how do you know which privileges and roles are needed by all your users and applications?  Too many roles and privileges make it easy for hackers to use a single…

There’s an onslaught of Big Data coming to our IT shops - zettabytes of it! – but instead of your application developers struggling to learn new languages and techniques to analyze it, why not leverage Oracle Database 18c? This session will demonstrate how to tackle handling the coming Big Data tidal wave with the best…