Virtual Summer 2021
Date: Thursday August 19, 2021
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
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
Oracle Database Security
Database Performance Analytics
Database Resource Analytics
Demonstrating the automated log explorer capabilities for databases
Primarily through the dashboards
11:50AM CDT BREAK/Q&A
12:00 PM CDT CONTINUED: Oracle Management Cloud by David Paschall-Zimbel and
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
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.