Northern California Oracle Users Group

NoCOUG 2020 Winter Conference: SQL Tuning Boot Camp

  • 13 Feb 2020
  • 10:00 AM - 4:00 PM
  • Rosewood Commons Conference Center (formerly CarrAmerica Conference Center) 4400 Rosewood Drive Pleasanton, CA 94588

Registration

  • A Chevron e-mail address is required
  • oracle.com e-mail address required
  • A PayPal e-mail address is required

Registration is closed

Click here to download the agenda flyer


SQL Tuning Boot Camp

Since the Cost-Based Optimizer’s introduction in Oracle 7, we have been fascinated and intimidated by it and the statistics it relies on. It has long been felt that the internals of the Optimizer are shrouded in mystery and a degree in wizardry is required to make it do the right thing. This one-day workshop will explain the fundamentals of the cost-based optimizer and the statistics that feed it. Using real-world examples, we will demonstrate that it’s not nearly as complicated as some folks would lead you to believe. We will also provide a methodology for diagnosing and resolving the most common SQL execution performance problems, allowing you to become an Optimizer whisperer.

Agenda

  • Brief History of the Optimizer and how it operates
  • Understanding Optimizer statistics
  • Explain the Explain Plan
  • Prevent sub-optimal execution plans

Presenter Bio

Maria Colgan is a master product manager at Oracle Corporation and has been with the company since version 7.3 was released in 1996. Maria’s core responsibility is creating material and lectures on the Oracle Database and the best practices for incorporating it into your environments. She is also responsible for getting feedback from Oracle customers and partners incorporated into future releases of the product. Prior to this role; she was the product manager for Oracle Database In-Memory and the Oracle Database query optimizer. Maria is the primary author of the SQLMaria blog https://sqlmaria.com and a contributing author to the Oracle Optimizer blog http://blogs.oracle.com/optimizer.

Post-conference networking reception and happy hour hosted by Quest at Sunshine Saloon, 1807 Santa Rita Rd.


Online registration is required. Membership renewal, conference registration, and payments are not processed at the conference venue.

Should you need to cancel your registration at any time, do the following:

  1. Click here to log into your account (Reset your password if needed)
  2. Click on “View profile”
  3. Click on “My event registrations”
  4. Click on “NoCOUG 2020 Winter Conference: SQL Tuning Boot Camp”
  5. Click on “Already registered”
  6. Click on “Cancel registration”




© NoCOUG
Powered by Wild Apricot Membership Software