Troubleshooting and Tuning Oracle with Jonathan Lewis
|
Learn from Jonathan Lewis, a reknowned expert on the underpinnings of the Oracle database engine. Jonathan is the author of two books, Practical Oracle 8i - Building Efficient Databases, and Cost-Based Oracle Fundamentals, and a co-author of Oracle Insights: Tales of the Oak Table |
|
|
Session 1 1.5 hours |
Trouble-shooting or Tuning What's the difference? What are the strategies? Why tuning is hard but trouble-shooting is easy? Key targets, indicators and mechanism for producing a well-tuned system on day one. Strategies for dealing with badly performing systems after go-live. |
|
Break: coffee and informal discussion: 30 minutes |
|
|
Session 2 1.5 hours |
Frequently Occurring Problems Some of the most commonly occurring issues that affect performance after a system has gone into production. Methods for spotting them, measuring the impact, and dealing with the cost / risk / benefit triangle involved in fixing them. Getting into the habit of pre-emptive analysis and pro-active fixing. |
|
Break: Lunch and informal discussion: 1 hour |
|
|
Session 3 1.5 hours |
Quick Fixes Methods, workarounds, dirty tricks and parameters for dealing with classic performance problems when the system is in production. There really aren't many quick fixes that can be applied across the board each one needs careful examination of costs, risk, and benefits. In this session we consider some of the options that are most likely to be worthwhile. |
|
Break: coffee and informal discussion: 30 minutes |
|
|
Session 4 1.5 hours |
V$ and X$ It's a good idea to be familiar with just a few of the dynamic performance views - and there are a couple of items in the still hidden away in the X$ objects that can add a little value. This session will describe the views that are most commonly of use, and explain the meaning of some of the more useful items. |
|
|
|
|
- Item #: jl-01
