PLEASE NOTE: After you have registered on the RMOUG site, please go to this link: https://attendee.gotowebinar.com/register/3359642855091270668?source=rmoug and complete the information form with our event sponsor to receive the email with your link to log into our hosted virtual room for the Educational Workshops and Meeting.
Have you had that one SQL statement that you just couldn’t figure out what the Oracle optimizer was thinking? In this session we will take a deep dive into doing a trace and talk about some of the sledgehammer methods to influence the optimizer. You may not find the solution to that one nagging SQL but we will cover how the optimizer frustrated you so. Using these tools along with Oracle’s SQL Plan Management or Profiles you may be able to achieve your goals. Many developers do not understand how to dig into SQL beyond the basic explain plan. Here we will cover the somewhat gory details of going deep inside how the optimizer is making decisions.
1. What tools are available for deep diving into a SQL statement?
2. When would you use each of these tools, and how do you understand the output?
3. What are some of the ways to force the optimizer to behave the way I want it to?
Gary Gordhamer has spent the majority of his professional career focusing on enterprise application landscape and business process digitization. His technical experiences range from Oracle e-Business suite, middleware, database, and other related technologies. Furthermore, his IT knowledge has ultimately helped him garner success in the following industries such as healthcare, manufacturing, utilities, and government. He is an active member of the QUEST IOUG Database & Technology Community, which he currently serves on the advisory board.
Gary is an Oracle ACE Associate, and a frequent presenter at Oracle OpenWorld and COLLABORATE. He has received the IOUG SELECT Journal Editors Choice Award, the IOUG Chris Woolridge Award, GE Oracle Leadership Award, and Oracle Innovation Award runner-up for Exalogic.
As most of us are spread out in a work from home initiative, communicating with our colleagues, customers, and management has become more difficult than a face-to-face conversation previously was. How do we ensure we can effectively present our message? What strategies should we use for a presentation, regardless of the audience size? In this session, we discuss proven presentation strategies to help bridge the gap while we all work from home.
Director, Business Operations
Kelsie Brunson has a bachelor’s degree in Communication and a master’s degree in Curriculum and Instruction with a focus in Communication, both from Texas A&M University. She taught and built curriculum for workplace professional communication techniques for 3 years before coming to Viscosity. Kelsie presented this session to a standing room only crowd at Collaborate 2019, one of the largest Oracle User Group Conferences in the United States.
ANOTHER REMINDER: After you have registered on the RMOUG site, please go to this link: https://attendee.gotowebinar.com/register/3359642855091270668?source=rmoug and complete the information form with our event sponsor to receive the email with your link to log into our hosted virtual room for the Educational Workshops and Meeting.
Rocky Mountain Oracle Users Group (RMOUG) a 501(c)(3) non-profit corporation in Colorado