Class4: Performance tuning

Various query tunings.
Table/index analyze/estimate/validation
Optimizers; Hints
Memory tunings (parameter adjustments, pool sizing, object pins, object caching)
Tools and methods:
Explian plan; Auto trace; Tkprof
Utl utilities

Class 5: Backup/recovery

Control file backup
Export with table/user/full modes and option selections
Import with table/user/full modes and option selections
Offline backup and recovery
Online backup and complete/incomplete recovery

Class 6: Summary, Question Answers and Job Interview Preparation

Class reviews and enhancements
Home work help
Question answers
Interview preparation

Options (if time remain): Oracle 8i/9i new feature introduction

Oracle 9I new feature: Auto UNDO, default temp tablespace, local managed tablespace and spfile
Oracle 8I new feature: materialized view
Oracle 8I new feature: Oracle InterMedia context
Oracle 8I new feature: Statpack
Oracle 8I new feature: LogMinor

previous page << page: 1 page 2 page 3