What Is an AWR Report Trying to Tell You?

NYOUG Webinar on June 13, 2023 presented by Gary Gordhamer

Automatic Workload Repository or AWR is a key performance tuning tool for Oracle databases. Frequently an AWR report is seen as a one stop shop for all database performance tuning, when really it is just one tool in the arsenal. In this session we will cover the basic information on what an AWR report is, and then dig into the details an AWR is trying to convey. If you are new to Oracle database performance tuning or a seasoned veteran, we will have relevant information for you.

Objectives:

  • When is an AWR report useful, and when is it not.
  • What to look for in an AWR report
  • What is the difference between database tuning and SQL tuning   

Gary Gordhamer is a Managing Principal Consultant at Viscosity North America. He has spent much of his career focusing on the enterprise application landscape and business process digitization. Gary’s technical experiences range from Oracle E-Business Suite, middleware, database and related technologies for the past 29 years. His professional background covers many industries including healthcare, manufacturing, utilities, and government. He is an active member of the Quest IOUG Database & Technology Community, serving on the advisory board. Gary is an Oracle ACE Pro, and frequent presenter at Oracle OpenWorld and user group conferences.

This event is co-hosted by the New York Oracle Users Group (www.nyoug.org) and Oracle Professional Services firm, Viscosity North America (www.viscosityna.com)

YouTube player