Liron Amitzi

Liron Amitzi 300x300

Liron Amitzi

Senior DBA consultant

GotoDBA

Biography

Liron is an Oracle ACE Director and a senior Oracle DBA consultant, with more than 20 years of experience. During these years Liron worked as a senior consultant with a large number of companies in various fields and managed an Oracle Professional Services Team. He mainly specializes in high availability solutions, performance, backup and recovery, and other infrastructure and application database areas. Liron is the president of BCOUG (British Columbia Oracle User Group), and he is also a well-known instructor and lectures in Oracle courses, events and forums

Papers

Creating Order in the Database Patching Chaos

Event: Virtual Connect 2020, Virtual Connect 2020-Cloud
Stream: Architecture, Cloud Database & Technology

Have you ever found yourself staring at a list of patches and wondering what to do? What patch should I install? What are the risks? Is there anything I should do after the patch? This becomes even more stressful in a complex environment: How to install patches on RAC? What about standby databases? This session will try to put things in order and help create a roadmap for patching databases. We will discuss the different types of patches (RU, RUR, DBBP, PSU, OJVM, One-off), installation types (RAC rolling patches, standby first patches), known issues and where to find them, and how to plan the patch installation in order to have as few surprises as possible.

Better Designed Than Sorry – Let’s Design Our DB Schema

Event: Virtual Connect 2020, Virtual Connect 2020-Cloud
Stream: Architecture, Cloud Database & Technology

Schema design is an important part of any application design. It can affect performance, the development process and even your SQL queries. Thinking about design in advance is very important as design is not something we can easily change down the road. Yet, sometimes we get fixated on a specific design without thoroughly considering other, potentially better, options. In this session I hope to challenge your design mindset by discussing a few design challenges and a few ways to solve them. What are the implications of each solution? Which way is the best? Is there even a "best" way to solve these cases?