Encrypting data is a useful tool to protect sensitive data be it at rest, in motion, or in use. For an Oracle Database, encryption may be done at the storage, application, network, and backup layers. Therefore, implementing database encryption can be time consuming and difficult as there are performance considerations and challenges such as effective…

Managing a large multitenant database with many pluggable database can be a difficult task. Many PDBs fight for the server resources like I/O, CPU and memory. It can be difficult to keep the SLAs agreed with your customers. Oracle Database 12c Release 2 offers improvments in resource management for PDBs and a new feature called…

Make the database smarter? Isn't it already smart enough? Well...no it isn't.  The Oracle Database provides a rich environment for the expression and incorporation of business logic within the data-layer. As powerful as PL/SQL is, it still hits a limit that forces logic to be implemented in the middle or client tier.  This presentation will…

The (Un)loved Child of Generation Cloud: Oracle Performance on VMware Virtualization as a backbone technology - an all-time-high topic, and much older than the current buzzword wit the capital C. Not uncomplicated regarding licensing and handling, such a hypervisor hides a bunch of nasty surprises for the unprepared. The talk will have a focus on…

VMware vSphere 6.5 has made a lot of changes to enhance the performance of Monster virtual machines (VMs). Databases by their very nature are the classic Monster VMs. If Monster VMs are not virtualized properly, they will never perform well and can negatively impact the performance of other VMs on the hosts. In this presentation, we will teach you how to properly virtualize Monster VMs/databases with vSphere 6.5 (Lesson’s Apply to any Virtualized Platform) We will discuss why you should virtualize and take a look at some installation issues as well as how to architect for performance in terms of vSphere 6.5 specifics, including the storage layer, the processor, memory considerations, and the network layer. Topics will also include NUMA, memory reservations, and how to avoid common mistakes. These lessons will help you optimize any workload you are virtualizing. This session will cover both Oracle & Microsoft SQL Server. This session made Top 10 At Both VMworld USA & VMworld EMEA.

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…