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

Home | Training | Products | Team | Contact Us

© 2002 iguava IT solutions
mailto:info@iguava.de