This talk will build out the full solution architecture block diagram showing the end-to-end stack of Oracle cloud security features for Exadata and how to use them to protect data in public, private, and hybrid clouds.  Topics will include ssh access, network firewalls and software defined networks (SDN) in Oracle Cloud Infrastructure, platform firewalls (iptables),…

Learn how to keep your system up and running continuously using Oracle built-in features and do it with relative ease. Oracle options will be shown, but we will go beyond the theory and show you how these are used on a critical production system. Hear the pros and cons of practical options that can be considered in 2018 including 12.2 and new 18c options. Architectures and implementations that will be shown are applicable to most installations, so everyone should benefit from the approaches presented..

Features such as FCF, FAN, ONS, Transaction Guard, Application Continuity, Global Data Services and Application VIP’s and their use will be covered. Many of these as used with 12c RAC and Data Guard provide a solution for Disaster Recovery database switchover and application failover that can be performed with virtually no downtime to the online user community.

Alternate options such as Active Data Guard, GoldenGate, disk mirroring and a RAC Stretch Cluster will be reviewed with the pros and cons of each. High availability solution. Approaches for performing online application upgrades using Edition Based Redefinition or GoldenGate will be presented with their advantages and disadvantages for home-built and purchased third party applications. Database physical design considerations that facilitate online application upgrades will be reviewed. Patching and upgrading all components of the system from servers to the operating system, middleware and database with the system online will be examined.

You will come away from this with a practical understanding of many of high availability features as they can be used in the industry today and the realization that you can implement complete HA solution on your own systems!

With the new Application Containers feature in Oracle Database 12c Release 2, Oracle has opened the mechanisms of the container database architecture for applications. Now in a container database application, containers can be defined and application databases can share the data model and common data. This simplifies the installation and the upgrade these applications. In this session the new feature and possible use cases are presented.

The methods used to track performance issues in SQL and PL/SQL vary based on the level of access within a system.  A developer in cooperation with a DBA, or already granted DBA privileges can has a wide variety of tools and deep visibility.  However, a user with nothing more than CREATE SESSION and SELECT privileges…

A number of polls taken during various PL/SQL-related presentations paints a very strange picture: one of the most critical FREE server-side performance tuning tools is almost totally unknown! If you ask basic questions such as “how much time is spent on routine A?” or “how often is function B called?” most developers would start to hand-code their own solution instead of utilizing the Oracle PL/SQL Hierarchical Profiler (HProf). This is not due to a dislike of the provided functionality, but because most developers are simply not aware of its existence! My presentation is an attempt to alter this trend and reintroduce HProf to a wider audience.

The PL/SQL Hierarchical Profiler became available in Oracle 11g Release 1 and replaced the old DBMS_PROFILER package. The goal was the same: to profile runtime behavior of PL/SQL code, i.e. to register and timestamp every operation (including SQL statements) that occurs during the monitoring window. However, the changes were startling:

Profiler output is now a file that can be generated in one environment and analyzed elsewhere. This makes production debugging significantly easier because performance-tuning specialists don’t need to touch PROD as long as they have access to the same code base.
In addition to loading profiler output to the database and running queries against it, the command line utility PLSHPROF creates HTML-based reports (human-readable!). These reports contain various data aggregations to speed up the review process.

This presentation covers a number of real use-cases when HProf significantly shortened response time to production performance problems. You will see how easy it is to figure out the actual source of the slowdown, namely:

Hundreds of thousands of calls to a pretty light user-defined function --> Check execution plans of corresponding queries
Sluggish SQL statement --> Don’t blame PL/SQL and start SQL tracing
Strange third-party calls in wrapped packages --> Collect hard evidence and start complaining

Overall, if you write PL/SQL, you must utilize the PL/SQL Hierarchical Profiler. Otherwise, you will be guessing at your code behavior instead of knowing it, which could lead to unpredictable performance. Unpredictable performance often means production calls at 3 am on Sunday. This presentation will help you sleep longer!

Since it was introduced back in 2003 with Oracle 10g, ASM became an essential part of almost every Oracle DBA's life. In this session you will learn ASM from A to Z - starting with the basic concepts of the ASM all the way to the new features of ASM and important best practices that…

Migrating to a newer Oracle Database Version doesn’t have to be confined to a single outage period.   Several interim steps can be done ahead to certain compatible components saving valuable time.  In a general sense Oracle is backwards compatible for making that transition from an earlier version to a later one. This session will cover…

In this session learn how to identify which of the Oracle Management Cloud services you might need, as well as how to get started. All services use the same underlying platform and agent. Learn about planning and architecture, agent deployment and maintenance, as well as advanced topics such as available REST APIs, creating entities, custom…

DevOps -- the effort to coordinate development and systems operations teams -- is a concept introduced in 1991 that has recently picked up steam. It was created to support the agile approach to software development, and includes concepts such as continuous integration and continuous testing. Up until relatively recently, implementing a process for DevOps in…

Oracle 12c (12.1) has been out for quite a while now, but it wasn’t until March of last year (2017) that Oracle 12.2 became available for the public to download.  In this presentation, Janis Griffin, database performance evangelist, SolarWinds, will deep dive into several of the new features that are considered some of her favorites.  The participant will learn about enhancements to the In-Memory option, Multitentant (PDB) improvements, new Partitioning capabilities, the new Sharding feature and more.  Along the way, Janis will demonstrate the many uses and best practices of utilizing these features.  This presentation is a must see especially if you are planning on upgrading to 12.2 soon.