Workshop Sponsors

Agenda

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

11:50AM CDT BREAK/Q&A

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