| |
| Title: |
Oracle Developer Tuning Tips |
| Presenter: |
Gary Gordhamer |
| Organization: |
Viscosity North America |
| |
| Summary: |
New to tuning SQL, or maybe this is your 10th year? In this session we will give a quick intro on SQL and Oracle Optimizer and then provide some specific examples and tips for multiple SQL tuning options and methods. The goal is for this session to be approachable by all levels of skill and provide some quick take aways without going too deep into any one area. Example code will be provided, with some demonstrations.
Learning goals include: What is SQL tuning; What tools should I use; Explain Plan Lies; Statistics + Histograms = +1; Tuning Advisor + AWR top N SQL = +1; Why do SQL Profiles fail; Create a SQL Baseline from cursor cache; How to make a SQL Patch; Playing with Optimizer; Why is my index not being used? (Index clustering) |
| |
| Topic: |
Developer
Database/DBaaS Administration
|
| Session Type: |
One Hour Session |
| Target Audience: |
|
| Experience Level: |
|
| Session: |
4: 02/12/2025 1:30 pm to 2:30 pm |
| Location: |
Room 100B |
| |
| Biographical Sketch: |
Gary Gordhamer has spent much of his career focusing on enterprise application landscape and business process digitization. His technical experiences range from Oracle e-Business Suite, middleware, database and related technologies for the past 30 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 associate, and frequent presenter at Oracle OpenWorld and COLLABORATE.
|
| |
| |
