INOUG January 2018 Meeting - Jim Czuprynski, Michael Messina & Sarah Zumbru...

Event Information

Share this event

Date and Time



Eli Lilly Building 98e

245 East Merrill Street

Indianapolis, IN 46225

View Map

Event description


In lieu of a traditional membership fee INOUG will charge $10 at the door for this event.

Registration Begins at 8:30 AM, Meeting is from 9:00 AM - 5:00 PM
Lunch will be provided.

Tentative Agenda:

8:30 - 9:00 AM - Meet and Greet

9:00 - 10:15 AM - Oracle 12cR2 Database In-Memory: Adventures with SwingBench TPC-DS - Jim Czuprynski

10:15 - 10:30 AM - Break

10:30 - 11:30 PM - DBA 2.0 Is Dead. Long Live DBA 3.0! - Jim Czuprynski

11:30 - 1:00 PM - Lunch Break

1:00 - 2:30 PM - The New BI - Sarah Zumbrum, Oracle Corp

2:30 - 2:45 PM - Break

2:45 - 4:30 PM - Postgres, MySQL & MongoDB - Michael Messina & AdvizeX Consulting

4:30 - 5:00 PM - Wrap Up

INOUG would like to thank our sponsors Jim Czuprynski & ViON Corporation for helping this event. As always, we would like to thank Oracle for their continual support and sponsorship, and Eli Lilly for the generous use of their facilities.

ViON Logo


Jim Czuprynski
Oracle ACE Director
ViON Corporation

Speaker BIO:

Jim Czuprynski has 35+ years of professional experience in his career in information technology. He has served diverse roles at several Fortune 1000 companies - mainframe programmer, applications developer, business analyst, and project manager - before becoming an Oracle DBA in 2001. Jim was awarded the status of Oracle ACE Director in March 2014 and is a sought-after public speaker on Oracle Database technology features. He has presented topics at Oracle OpenWorld, IOUG COLLABORATE, Hotsos Symposium, Oracle Technology Network ACE Tours, and Oracle User Group conferences around the world.

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

Oracle 12cR2 Database In-Memory: Adventures with SwingBench TPC-DS


Originally introduced in Release, Database In-Memory (DBIM) offers the ability for analytic queries to sift through billions of rows at incredible speed because data is now retained in columnar format in the In-Memory Column Store (IMCS). Oracle Database 12cR2 dramatically expands the capabilities of DBIM, making it even simpler to implement, monitor, and manage while extending its reach to more complex execution plans, expanding its utility to Active Data Guard (ADG) instances, and enabling capture of frequently-evaluated expressions in the Expression Statistics Store (ESS).


Through presentations and examples using Swingbench’s latest TPC-DS query generation features, this session will illustrate how Oracle 12.2 Database In-Memory:

- Dramatically speeds execution of analytic queries through In-Memory Column Store (IMCS)

- improves the management and monitoring of the IMCS

- Improves complex query execution through improvements like Expressions Statistics Store, In-Memory Filtering, and Parallel Execution


  1. Database In-Memory: A Quick Review
  2. Dynamic IMCS Resizing
  3. In-Memory Fast Start
  4. Extending IMCS to Exadata Smart Flash Cache
  5. IMCS, Heat Maps, and Intelligent Evictions
  6. IMCS in Active Data Guard (ADG)
  7. In-Memory Aggregation (IMA) Enhancements
  8. Improved In-Memory Filtering
  9. In-Memory Compression Units (IMCUs) and Parallel Execution
  10. In-Memory Expressions and the Expressions Statistics Store (ESS)
  11. Conclusions

Objective #1:

The attendee will understand how to leverage IMCS’s latest features to dramatically speed the execution of complex analytic queries against millions of rows.

Objective #2:

The attendee will discover how to deploy IMCS against a physical standby database that’s running Active Data Guard (ADG).

Objective #3:

The attendee will learn how to leverage the latest version of SwingBench to generate a representative TPC-DS workload for equitable comparisons of application performance against an Oracle 12cR2 databases.

Session Prerequisites:

To gain the most from this presentation, attendees should be familiar with Oracle Database 12cR1 and the basics of IMCS and columnar projection. Knowledge of Exadata concepts would also be beneficial.

Category: Database
Experience Level: Intermediate
Session Type: Technical Session (1 hour)
Target Audience: Database Administrators, Developers

DBA 2.0 Is Dead. Long Live DBA 3.0!


If you are an Oracle DBA who is wondering what the future of that role will look like, this session is the perfect antidote to ending your speculation. We will look at five key trends in the IT industry – Cloud, Big Data, IoT, Security, and Reshoring – and how they are impacting the role of the Oracle DBA within IT organizations. Most of all, this session will explain why it’s absolutely crucial to transform yourself into from DBA 2.0 to DBA 3.0 in 2017.

Session Outline:

We’ll discuss five key trends and their impact on the role of the Oracle DBA:

  • Cloud: Caveat Nuba Emptor
  • Big Data: Facts Replace Beliefs. (Sometimes Painfully.)
  • IoT: Alexa, Buy Me a Dollhouse!
  • Security: Building Better Levees Against the Storm
  • Reshoring: Offshoring Meets Its Match

Category: Database
Experience Level: Beginner
Session Type: Technical Session (1 hour)
Target Audience: Database Administrators, Developers, CxOs, Managers


Sarah Zumbrum
Oracle Corporation

The New Business Intelligence


BI has traditionally burdened IT. The business required complicated data models that made BI slower to implement and more rigid. While not necessarily wrong, the trade-off has been agility and integration with local data sources such as Excel files. While waiting for data models to be created, the need for actionable data insights has not stopped. This session will discuss traditional versus modern BI and analytics as well as a live demonstration of Oracle’s Data Visualization as a complement to modern Oracle BI and analytics.

Postgres, MySQL & MongoDB


Joe Layous
AdvizeX Consulting

Speaker BIO:

A Solutions Architect with Rolta AdvizeX with more than 15 years working with databases as a database administrator. Working as a database administrator with MySQL, MS SQL Server, MongoDB and Postgres databases. Managed database on site and in the cloud for databases supporting high transactional volumes with high availability requirements.

Introduction to MongoDB Replication Best Practices

Overview of the process of synchronizing data across multiple servers, providing redundancy and increases data availability with multiple copies of data on different database servers. Best practices to protects your database from the loss of a single server, and recover from hardware failure and service interruptions.

Advanced HA with Postgres

This presentation will outline the best practices for both Replication and HA configurations so that your database servers can work together to allow one server to take over quickly if the primary server fails, or to allow several servers to serve the same data. With the proper setup using these scenarios, Postgres servers could work together seamlessly, and using serving dynamic web pages can be combined quite easily by merely load-balancing web requests to multiple machines.


Michael Messina
AdvizeX Consulting

Speaker BIO:

A Senior Management Consultant at Rolta AdvizeX, Oracle ACE, Vice President of the Indiana Oracle Users Group and IOUG Select Board Member with over 25 years in database management, system design and development experience with more than 10 years working in a leadership and management capacity. Regular presenter at local and regional users group, IOUG Collaborate and past presenter at Oracle Open World.


With MySQL advancements and capabilities continue to come. This presentation will take a look at MySQL 8 and discuss the new capabilities and features.

Share with friends

Date and Time


Eli Lilly Building 98e

245 East Merrill Street

Indianapolis, IN 46225

View Map

Save This Event

Event Saved