| |
|
|
|
|
|
|
|
|
Friday, August 19th 2011 |
|
|
|
|
|
8:00 AM - 8:30 AM |
|
Check-in and Breakfast |
|
|
|
|
|
|
|
|
|
8:30 AM - 10:00 AM |
|
Overheads |
|
|
|
|
A basic introduction to the costs of the infrastructure that makes Oracle what it is. Topics include connection costs, network traffic, parsing and optimising costs, undo generation and use, and redo. |
|
|
|
|
|
|
|
|
|
10:00 AM - 10:30 AM |
|
Break |
|
|
|
|
coffee and informal discussion |
|
|
|
|
|
|
|
|
|
10:30 AM - 12:00 PM |
|
Coding Strategies |
|
|
|
|
There are good ways to code and bad ways to code. This session demonstrates the problems with the bad coding strategies and shows how much difference it makes when you do it right. |
|
|
|
|
|
|
|
|
|
12:00 PM - 12:30 PM |
|
Lunch |
|
|
|
|
Lunch and informal discussion |
|
|
|
|
|
|
|
|
|
12:30 PM - 2:00 PM |
|
Indexing |
|
|
|
|
A description of indexes, largely devoted to B-tree indexes, talking about structure, how they work, and the paths Oracle is able to take through them. Indications of how to get the most out of indexes, and minimise the cost of indexing, with warnings about side effects of the different strategies for making an index more useful. |
|
|
|
|
|
|
|
|
|
2:00 PM - 2:30 PM |
|
Break |
|
|
|
|
coffee and informal discussion |
|
|
|
|
|
|
|
|
|
2:30 PM - 4:00 PM |
|
Execution paths |
|
|
|
|
In this session, we take an introductory view on how the cost based optimizer works, including a brief overview of the different join mechanisms. Then we examine execution paths and the developer-oriented ways of acquiring them. Finally we learn how to read and interpret execution paths. |
|
|
|
|
|
|
|
|
There are no seminars on the
calendar at this time.
View all Seminars |
