Virtual Summer 2021

Date: Thursday August 19, 2021

Time: 9:00am-1:00pm

Location: Virtual Event

Map Link and Directions: Virtual Event

Parking: Virtual event

TCOUG Check In: None (Please register)

Wifi : N/A

Oracle SQL Performance Tuning

/ Oracle Management Cloud

Oracle SQL Performance Tuning

Chris Saxon, Developer Advocate for Oracle Database

Oracle Management Cloud

David Paschall-Zimbel, Sr. Systems Engineer at Collier-IT

and Michael Fowler, Sr. Systems Engineer at Collier-IT

Workshop Sponsors


09:00AM CDT Opening note by TCOUG President, Suresh Sikharam

09:05AM CDT Message from our Sponsor - Collier IT

09:10AM CDT Why Isn't My Query Using an Index? An Introduction to SQL Performance by Chris Saxon

  • “Why isn’t my query using an index?” is a common question people have when tuning SQL. This talk explores the factors that influence the optimizer’s decision behind this question. This session is intended for developers and DBAs who want to learn the basics of how to make their SQL run quickly!

09:55AM CDT Break/Q&A

10:05AM CDT CONTINUED: Why Isn't My Query Using an Index? How can I find many rows

fast? Followed with demos by Chris Saxon

10:50AM CDT Break/Q&A

11:05AM CDT Oracle Management Cloud by David Paschall-Zimbel and Michael Fowler

Enterprise and Cloud Manageability – how are things looking out there now; Managing Oracle Database and Exadata – how can OMC help in the management of Exadata and Oracle Database; Managing Oracle Applications – a little bit about how the application tier can utilize OMC; Managing Multi-Cloud and Heterogeneous environments – Summary of the environments OMC can work with, followed with demos on…

  • Accessing OMC through Dashboards:

Oracle Database Dashboard

Exadata Health

Oracle Database Security

Database Operations

  • IT Analytics

Database Performance Analytics

SQL Analytics

Exadata Analytics

Database Resource Analytics

Availability Analytics

  • Log Analytics

Demonstrating the automated log explorer capabilities for databases

  • Security Analytics

Primarily through the dashboards


12:00 PM CDT CONTINUED: Oracle Management Cloud by David Paschall-Zimbel and

Michael Fowler

12:50 PM CDT Closing note by the TCOUG President, Suresh Sikharam

About the Speakers

Chris Saxon - Oracle Developer Advocate for SQL

Chris Saxon is a Developer Advocate for Oracle Database. His job is to help you get the best out of the Oracle Database and have fun with SQL!

To help you with this he blogs at All Things SQL. He also creates videos combining SQL and magic on YouTube at The Magic of SQL.

If you have questions about working with Oracle Database technology, please reach out to him. You can do this via Twitter or on Ask TOM.

David Paschall-Zimbel - Collier IT.

David Paschall-Zimbel is a Senior Systems Engineer at Collier IT.

David has over 30 years of experience in the IT Industry, starting as a Research Fellow at the University of Minnesota. David’s current areas of focus include Operating Environments, Engineered Systems, Clustering Technologies (including Hadoop) and Cloud Administration.

In his free time, he enjoys reading, watching anime, and playing the Final Fantasy 14 MMO.

Michael Fowler - Collier IT

Michael Fowler is a Senior Systems Engineer at Collier IT.

Michael has over 20 years of experience in technical fields with a focus on implementing highly complex hardware / software solutions. Currently, Michael’s areas of focus include Cloud Architecture and Implementation, DevOps Development, Cloud Environment Monitoring Solutions, Python Development for Cloud API’s and Legacy Hardware Support.

  • Outside of Collier IT - Michael enjoys hanging out with family and friends, metalworking, hobbyist electronics, raising chickens and working on cars.

Suresh Sikharam - President TCOUG, Enterprise Data and Systems Architect

President, TCOUG

  • Suresh has over 24 years of experience in Developing, Architecting, performance tuning Oracle and SQL applications.

  • People manager, and lead many technical teams to success in software development and CI/CD space using Git, BAMS, Puppet, Flyway

  • Leading efforts in the Enterprise Data and Systems Architecture.