I-PAD logo
  • Home
  • About
  • Courses
  • Training
    • Corporate Training
    • Online Training
  • Development
  • Projects
  • Careers
  • Contact

Oracle DBA


Oracle DBACourse Structure

Architecture & Configuration

  • Overview of Oracle DBA tasks
  • Instance Architecture
  • Oracle Instance Internals
  • Using SQL*Plus for DBA management
  • Control file, UNDO and REDO management
  • User and privilege management
  • Oracle database management

  • Overview of instance management
  • Initialization file management
  • Oracle*Net configuration
  • Data buffer configuration & sizing
  • Shared pool and PGA configuration & Sizing
  • Troubleshooting network connectivity
  • Oracle object management

  • Oracle tables, views and materialized views
  • Oracle indexes
  • Oracle constraints
  • Schema, File & tablespace management
  • Database Maintenance
  • Oracle DBA Utilities
  • Monitoring Oracle

    This section explores the methods used for monitoring all active components of the Oracle database.

  • Dictionary and v$ views
  • Table & index monitoring
  • workload & trend monitoring
  • Instance monitoring
  • Oracle environment monitoring
  • STATSPACK and AWR performance management
  • Performance Management

    This section explores the methods used for performance management in Oracle and shows tips and scripts for monitoring all components of any Oracle database. You will also learn the proper action to take when any area of Oracle becomes a bottleneck.

  • Bottleneck performance analysis
  • Instance Tuning
  • SQL and CBO behavior
  • Tracing SQL Execution
  • SQL Execution Internals
  • SQL Tuning
  • Oracle High Availability tools
  • Backup & Recovery
  • Home | About | Courses | Training | Development | Projects | Careers | Contact

    Copyright © 2015. Reserved by I-PAD Technologies