Autonomous Transaction Processing (ATP): In Heavy Traffic, Why Drive Stick?

Session Number: 8015
Track: Database
Sub-Categorization: DBA
Session Type: Solutions
Primary Presenter: Jim Czuprynski [Senior Enterprise Data Architect - Viscosity NA]
Time: Jun 25, 2019 (02:15 PM - 03:15 PM)
Room: 616, Level 6

Speaker Bio: Jim Czuprynski has nearly four decades of professional experience in information technology, serving diverse roles at several Fortune 1000 companies before becoming an Oracle DBA in 2001. He was awarded the status of Oracle ACE Director in March 2014 and is a sought-after public speaker on Oracle Database technology features, presenting often at Oracle OpenWorld, IOUG COLLABORATE, ODTUG Kscope, Hotsos Symposium, Oracle Development Community tours, and Oracle User Group conferences around the world.

Jim has authored over 100 articles focused on the facets of Oracle Database administration to his credit since 2003 at and He has also co-authored four books on Oracle database technology. Jim’s blog, Generally…It Depends, at, contains his regular observations on all things Oracle and the state of the IT industry.

Technologies or Products Used: Oracle Database, Autonomous Database, ATP, SQL*Developer, SwingBench

Session Summary for Attendees:  Autonomous Transaction Processing (ATP)—the second in the family of Oracle’s Autonomous Databases—offers Oracle DBAs the ability to apply a force multiplier for their OLTP database application workloads. However, it’s important to understand both the benefits and limitations of ATP before migrating any workloads to that environment. This session offers a quick but deep dive into how to best take advantage of ATP, including how to load data quickly into the underlying database, and some ideas on how ATP will impact the role of Oracle DBA in the immediate future (Hint: think automatic transmission instead of stick-shift).