Part of a DBA's job is diagnosis of database issues and the detection of potential issues that adversely affect the performance Oracle database systems. Both databases and Operation Systems have become more complex.  Add in clustered systems such as RAC and it becomes quite difficult to manually find all the relevant bits of information required to…

Nobody likes surprises when it comes to database upgrades and migrations. Because the upgrade or migration usually is not complicated by itself, the most important task is ensuring good performance afterward. This presentation discusses a straightforward, step-by-step approach to ensure not only plan stability but also proper testing; secret tweaks; and helpful tips and tricks…

What you wanted to know about the Alert Log all the time. A contribution about formats, contents, versions and differences. We will learn about different tools and also, what we can't see from this famous log file. The lecture also includes a quick overview about the components of an Oracle Database System. This allows the listener to…

Learn the how and why of running Oracle on Windows, and some tricks to help you along the way.  This session will benefit the Beginner to Mid-Level Oracle DBA faced with running Oracle on a Windows Server, and may also teach some old hands a trick or two.  Instead of delving into topics that would…

Learn how you can setup Data Guard in easy 1-2-3 steps.  Attendees will learn what is new in Oracle Data Guard 12.2.  In addition to demonstrating how simple it is to setup Data Guard, this session will disseminate fundamental Data Guard best practices and reference architectures that DBAs need to know to protect their Oracle…

Oracle Database 12c Release 2 offers so many new features that only a panel of Oracle ACEs can do them justice. In this session Oracle ACEs Jim Czuprynski, Anuj Mohan , Kai Yu and Seth Miller  from IOUG will discuss about key new features introduced in Oracle 12c R2 . We will share our experience…

A vibrant session with “Real Tips” for real world daily database problems a DBA could find. Here you will learn how to improve your productivity, how to solve some real DBA problems and also learn several tips to help you to become a successful DBA. This session is based on some of the most frequent question…

No audio until ~1-minute mark. Speaker was muted. Sorry for the inconvenience! Unexpected changes in execution plans can have disastrous effects on your database performance. Changes such as optimizer versions and statistics, schema/metadata definitions, and system settings  can cause a plan to change, which often times is not for the better.  In this presentation, Janis…

Every DBA should know how to back up and recover a database - their job may depend on it one day.  In order to make backup and recovery easier, Oracle gives DBAs RMAN.  In Oracle 12c, RMAN includes many new features to make backup and recovery simpler and more robust.  This session will cover 5…

Oracle Database In-Memory is the industry leading in-memory database technology, seamlessly accelerating analytics by orders of magnitude, as well as greatly improving mixed workload enterprise OLTP applications. Database In-Memory is highly cost effective since it can be used on databases of any size by using in-memory only for critical data, while using flash and disk…