In this session learn about making your applications highly availability, with no application knowledge and no application changes This session will teach you about configuring your applications for high availability using Services, FAN, drain points, and Application Continuity.  The session covers tuning for zero brownout with RAC and Active Data Guard and how to know…

Proper design of an application includes security plans, which ensure that specific data is available only to specific user groups. Application design should also include security plans for guarding against data or application tampering. These two aspects can easily be set aside while developers are caught up in the process of developing PL/SQL code to…

Implementing RAC with Data Guard?  Maybe on an Exadata or ODA?  Ever wonder: how do I quickly and easily check the status of all of my databases?  How do I easily report on space usage by database in ASM?  Should I configure Data Guard to use the SCAN listener?  Where and how should I run…

Analytic functions usually improve performance and reduce complexity of SQL-queries with multi-row dependencies. But for many developers/DBA's/end-users they are still a complex and mysterious operation. This presentation will explain analytics for developers, users and DBA's. In a live demonstration, I show the audience how to build queries with analytic functions with increasing complexity. First we…

With great consolidation comes great responsibility. Oracle 12.2 Multitenant allow administrators the power for high consolidation density, improved isolation, ease of management, and faster deployment. This session will explore several different use case scenarios and configurations where Viscosity has implemented Oracle 12.2 Multitenant along with virtualization technologies to achieve high consolidation density while still maintaining strong…

Big Data is growing exponentially, requiring massive-scale infrastructure however, business analytics has shifted from reactive to proactive analysis; this is the era of streaming data (a.k.a. Fast Data). Apache Hadoop is very good for analyzing data at rest but cannot handle streaming data. Big Data analytics needs new Big data frameworks. Apache Spark brings in-memory processing and…

There are a lot of considerations on how to move Oracle from on premise to AWS. Should we spin up an EC2 instance and install run and Oracle database there?  Should we use Amazon's Relational Database Service?  What do we still do in AWS RDS?  Should we convert from Oracle to MySQL, PostgreSQL or Aurora?  How…

Modern IT trends pose new challenges in database management. Databases exist on-premises and in the cloud, and these databases should support DevOps and business agility with the same management tools. Oracle Management Cloud introduces new and exciting capabilities to tackle database management challenges with modern IT. Oracle Management Cloud’s database management service provides a rich…

This talk covers a real-world solution, that recreates database links using ORDS, REST and JSON. It breaks the limits of database links by loosely coupling two databases. The complexity is completely hidden from users and developers. Modern technologies such as REST and JSON offer elegant ways to couple databases without fixed dependencies. The protocol http(s)…

Many DBAs are faced with the task of migrating and updating older Oracle databases to newer platforms and to Oracle12c, sometimes on-premises and sometimes to the cloud.  Frequently an endian change adds additional complexity.  Outage time constraints add to the challenge. While Data Pump may seem like an obvious choice, it does introduce many issues…