Roy Swonger

Roy Swonger 300x300

Roy Swonger

Vice President, Database Upgrade, Patching, Migration & Utilities

Oracle

Biography

Roy has over three decades of experience in commercial software development. His 20+-year career at Oracle has included work on software process and quality improvement as well as a progression of management roles in technical documentation, software development tools, and core database technologies. Roy has managed the Database Upgrade & Utilities in the Server Technologies division for more than 15 years. In this capacity he is responsible for the development of database features such as the Data Pump, SQL*Loader, External Tables, and Transportable Tablespaces. In addition, Roy runs the global Upgrade Program for the database, coordinating worldwide efforts to make database upgrades faster, easier, and less risky for customers. Roy holds a Bachelor of Science in Computer Science from Rensselaer Polytechnic Institute, and a Master of Software Engineering from Carnegie Mellon University. Highlights of some of Roy's presentations: Upgrade to 19c, Live and Uncensored!:This includes 3 live upgrades in the session, plus a dive into the new 19c AutoUpgrade feature How to Migrate to Oracle Autonomous Database Cloud: a nuts and bolts discussion about the methods and tools available for migration to ADW/ATP At OOW we will be enhancing this with the automation to be announced for customers, such as the Zero-Downtime Migration (ZDM) utility Best Practice for Patching Oracle Database: decidedly unsexy topic, but of great interest to customers. My group took over responsibility for database patching earlier this year, so this is a lot of damage control of the current state of DB patching as well as showing the progress made and laying out plans

Papers

Oracle Data Pump Internals

Event: Connect 2021
Stream: Architecture, Cloud Database & Technology

Oracle Data Pump is one of the most widely used DBA-oriented features of Oracle Database, combining powerful flexibility with high speed movement of data and metadata into and between Oracle databases. Even if you already use Data Pump, have you ever wondered how it works internally, or why it behaves the way it does? If so, then this deep dive into Data Pump internals is for you! We will delve into the inner workings of this widely used utility to look at topics such as: – the different types of parallelism: what are they, when are they used, what are the pros and cons of each? – object filtering with EXCLUDE/INCLUDE: what is possible, what is not? – dumpfile file versus network mode: what's the difference, and why? – what is in the Data Pump Control table, and how is it used? Join Oracle Data Pump product management for a deep dive into these topics and perhaps more. You'll have a better understanding of this important tool for managing your databases.

Secret Features of Oracle Data Pump

Event: Connect 2021
Stream: Architecture, Cloud Database & Technology

Oracle Data Pump is widely used by DBAs to move tables, schemas, and even entire databases from one Oracle Database to Another. But, even if you are familiar with Data Pump, we will bet that there are some features that you might not be be using to their fullest potential. This session will cover some of the lesser known, "unsung" features of data pump that will help you unlock the power of this versatile utility. Some of the features we will discuss and demonstrate are – the TRACE parameter and its use in debugging issues – the interactive command line interface – the DBMS_DATAPUMP API – important and helpful patches for Data Pump on Oracle Database 19c Whether you are a casual user or a power user of Data Pump, you're sure to learn something that will come in handy in your export or import scenarios.