14-15 Mayıs tarihlerinde "Inside Oracle with Lutz Hartman" semineri Istanbul'da

Inside Oracle with Lutz Hartman

Abstracts: This 2 day seminar gives an overview of key new features of the Oracle Database 10g (releases 1 & 2) their usage and possible pitfalls. Lutz Hartmann points out how to aviod possible problems forehand when upgrading from an older release. The seminar covers memory management, upgrade issues, new performance tuning methodes, flashback functionalities and new backup & recovery features and recommended strategies.

Day 1:
1. Memory management in Oracle 10g
* Overview of Memory Structures
* Dynamic SHARED MEMORY (SGA)
* SGA allocation
* SGA Memory Advisors
* Manually Adjusting Memory Components
* Automatic Shared Memory Management (ASSM) overview
* Monitoring ASSM
* Process Memory Management (PGA)
* UGA and Shared Servers
* Manual PGA Management
* Automatic PGA Management
* SQL Memory Manager
* Monitoring SQL Memory Usage
* Tuning SQL Memory Usage
* Process Memory Management: Best Practices
* Temporary Tablespace Management Overview
* Temporary Tablespaces: Best Practices

2. Upgrade issues with Oracle 10g
* Changes in Shared Memory Implementation and Upgrade Problems
(How to calculate the minimum size of the Shared Pool)
* New Optimizer Statistics Features in 10g and their impact on execution plans
* The possible impact of the implicitly used System Statistics in 10g
* The possible impact of Dictionary Statistics
* The effect of wrongly size PGA_AGGREGATE_TARGET
* Bind variable peaking and its drawbacks

Day 2:
3. The new Performance Tuning approach in Oracle 10g
* The performance monitoring framework in Oracle 10g
* Using alerts and metric thresholds
* The mandatory SYSAUX tablespace
* The diagnostic engine ADDM
* The tuning advisory framework
* Using baselines

4. Flashback any Error with Oracle 10g?
* The history of flashback functionalitites
* Flashback functionalitites using UNDO data
1. session level
2. row level
3. transaction level
4. segement level
5. database level
* Flashback functionalitites using other technologies
* The use of restore points
* Guaranteed undo retention

Lutz Hartmann as sysdba