Amazon Relational Database Service (RDS) automates many of the mundane administrative tasks required to run a database. However, migrating an existing database to the Cloud can be a tricky problem, often requiring an extended outage. In this session learn how you can leverage the AWS Database Migration Service to migrate your Oracle database to RDS with minimal downtime.…

The AWR provides a plethora of information. Many times DBAs and perforance analysts will become overwhelmed with the shear amount of data presented. Thie presentation will provide a glimpse of ten or more performance robbing statistics and indicators that every analyst should check for when reviewing AWR reports.

The ecosystem of the Oracle Real Applications Cluster (RAC) gives lots of space for creative solutions, optimized concepts and --- intelligent questions! The Grid Infrastructure framework is highly flexible, ASM opens many performant and safe options of mass storage administration and RAC is the measure for scalable database power in the market. But every single…

In this presentation, we will review ASM , high level overview of ASM files, disks, ASM extents, and allocation units etc. Then we will review a few of ASM header structures and how ASM identifies the disks etc. We will dump headers using few tools and show the output of those dumps. We will explore…

Every DBA is very familiar with the Oracle database LISTENER process tnslnr that is required to be running to allow remote connections to the database.  Over the years there has been a number of enhancements, and changes to the process of how a connection is created, but it all starts with the LISTENER process and…

While traditional data warehouses excel at sourcing data from enterprise applications, they usually fail at handling the volume, velocity and variety of data for modern analytics applications relying on Big and Fast Data. Instead of modeling these data sources into a system that doesn't fit, let's apply a new software design pattern to analytics: microservices. Microservices are…

The session will go over understanding the value of Big Data Tools (Kafka/R/Cassandra/Spark/Cloudera) and how to integrate and best use those tools within the Oracle environment of Oracle DB, Hyperion Planning and OBIEE.  We will review the reasons for integration, how to integrate, and integration best practices.    We will also view a demo integration of…

Attend this technical session to learn how Oracle Database Cloud Service and Oracle Exadata Cloud Service address the high availability (HA) and disaster recovery (DR) requirements of business-critical databases. Learn simple ways to protect on-premises databases using Oracle Recovery Manager backups to the cloud or Oracle Active Data Guard replication to the cloud for real-time…

Are your skilled DBAs spending time installing software and applying patches instead of growing your business? Come to this session to learn how PayPal moved from manual execution of homegrown scripts for Oracle Real Application Clusters installs and patching to leveraging the power of Oracle Database Lifecycle Management Pack. Oracle Real Application Clusters provisioning moved…