My Top 18c Tuning Features

Session Number: 8457
Track: Database
Sub-Categorization: DBA
Session Type: Tips, Techniques and Tuning
Primary Presenter: Rich Niemiec [Chief Innovation Officer - Viscosity North America]
Time: Jun 26, 2019 (03:30 PM - 04:30 PM)
Room: 617, Level 6

Speaker Bio: Rich Niemiec is the chief innovation officer at Viscosity North America ( He is a world-renowned Oracle tuning expert, an Oracle Ace Director, and was the CEO and a co-founder of TUSC, a Chicago-based systems integrator of Oracle-based business solutions started in 1988. Rich has served as an executive advisor to Rolta International Board of Directors, as president of Rolta TUSC, and president of Rolta EICT. TUSC was the Oracle Partner of the Year in 2002, 2004, 2007, 2008, 2010 (Rolta TUSC), & 2011 (Rolta).

Rich is a past president of the International Oracle Users Group (IOUG) and the current president of the Midwest Oracle Users Group (MOUG). He is one of six originally honored worldwide Oracle certified masters. In 2017, he authored Oracle12c Release 2 Performance Tuning Tips & Techniques, an update of his previous four Oracle best sellers on Oracle8i, Oracle9i, Oracle10g, and Oracle11g performance tuning. Oracle 12c R2 Performance Tuning Tips & Techniques came out in March 2017. In 2015, he authored Quick Start Guide to Oracle Query Tuning for DBAs & Developers. Rich was inducted into the Entrepreneurship Hall of Fame in 1998. He is a graduate of Purdue University, with a degree in electrical engineering.

Technologies or Products Used: Database

Session Summary for Attendees:  This presentation will look at which 18c new features should be investigated for use (such as snapshot carousel, PDB switchover, in-memory external tables, merge partition online, advances in the approximate query, polymorphic tables, standby nologging, password-less schema creation, and others). Most of the features covered will be related to the DBA, but there will also be a few outside that realm, focusing on the developer. There will be simple examples, where possible, to show the basic functionality of the new features. Some features are too new to show examples, but we will provide explanations. We will also look at the autonomous database and Oracle's focus on the future of security. This presentation will have a few new 12cR2 features such as multiple indexes on the same column, in-memory virtual columns (R2), adaptive execution plans, approximate query, quick in-memory tips, and new R2 features like in-memory joins.