|
|
 |
Administration
- Optimal Database design
- Database creation
- Custom scripts (Perl, Shellscripts,...)
- Database administration and optimizing
- Database reorganisation with Oracle tools
- Optimized rollback segment / undo tablespace configuration
- Backup & Recovery strategies
- Backup & Recovery tools
Installation
- Installation und setup of Oracle software under Windows
NT 2000/Solaris/Linux
- Choice of Oracle tools and options (Oracle9i, Oracle9i Enterprise
Edition,
Oracle9i Personal Edition, Oracle Lite, Application Server,
Oracle Developer,
Oracle Discoverer, Web DB, JDeveloper)
- Custom scripts (Perl, Shellscripts,...)
- Optimal Database design
- Database creation
Migration
- Database upgrade from Version 6, 7 to Version 8i, 9i
- Data migration with Export/Import tools
- Data import with SQL*Loader
Tuning
- Redesign of your Data Model
- Optimal Database configuration
- Tuning Rollback Segments
- Monitoring and detecting Lock Contention
- Analyse tables and indexes
- Reorganisation of tables and indexes
- Remove Block Chaining
- Diagnosis of specific performance problems
- Setup performance parameters
- Application Tuning
- SQL profiling
- Optimize SQL and PL*SQL
|
 |