Oracle is a relational database management system also termed as RDBMS with the primary objective of storing, managing and retrieving data efficiently to deliver high performance. Oracle DBA course at 3ri Technologies has been specially designed for individuals who want to become Database Administrators(DBA’s). DBA is most sought after jobs in the industry as a DBA plays a vital role in managing the organization’s data. Oracle DBA training course includes hands on experience on live projects and real time scenarios. This training course is designed to clear the globally recognized Oracle DBA certification as well. Our oracle dba training classes in Pune are well equipped and our experienced trainers being working professionals deliver the best in class Oracle DBA training.

  • Overview
  • Features
  • Syllabus
  • FAQ


  • 100 % Placement Assistance
  • Resume Preparation
  • Interview Preparation
  • Missed Sessions Covered
  • Multiple Batches
  • Flexible Timings
  • Practice Course Material


  • Knowledge of SQL.


  • 30 Hours


  • Individuals who want to become DBA

1. Oracle 11 g Installation

    • Pre-Installation Tasks
    • Logging In to the System as root
    • Checking Hardware Requirement
    • Checking Software Requirement
    • Checking Network Setup
    • Creating Operating System Groups and Users
    • Configuring kernel parameters
    • Identifying Required Software Directories
    • Identifying or Creating ORACLE_BASE directory
    • Installation screens

2. Oracle Database Architect

    • System Global Area (SGA)
    • Shared Pool
    • Database Buffer Cache
    • The Redo Log Buffer
    • Java Pool
    • Large pool
    • Stream Pool
    • Fixed SGA
    • Automatic Shared Memory Management
    • The Oracle Background Process

3. Oracle Data Block Management

    • Introduction
    • Data block Overview
    • Header (Common and Variable)
    • Table Directory
    • Row Directory
    • Overhead
    • Row Data
    • Free Space
    • Free Space Management
    • Availability and Optimization of Free Space in a Data Block
    • Row Chaining and Migrating
    • PCTFREE, PCTUSED, and Row Chaining
    • The PCTFREE Parameter
    • The PCTUSED Parameter
    • How PCTFREE and PCTUSED Work Together
    • Extent Overview
    • When Extents Are Allocated
    • Determine the Number and Size of Extents
    • How Extents Are Allocated
    • When Extents Are Deallocated
    • Extents in Nonclustered Tables
    • Extents in Clustered Tables
    • Extents in Materialized Views and Their Logs
    • Extents in Indexes
    • Extents in Temporary Segments
    • Extents in Rollback Segments
    • Segment Overview
    • Introduction to Data Segments
    • Introduction to Index Segments
    • Introduction to Temporary Segments
    • Operations that Require Temporary Segments
    • Segments in Temporary Tables and Their Indexes
    • How Temporary Segments Are Allocated
    • Allocation of Temporary Segments for Queries
    • Allocation of Temporary Segments for Temporary Tables and Indexes
    • Undo Management
    • Undo Quota
    • Automatic Undo Retention
    • External Views

4. Managing Tablespaces

    • Using Multiple Tablespaces
    • Creating Tablespaces
    • Locally Managed Tablespace
    • Creating a Locally Managed Tablespace
    • Segment Space management in locally managed tablespace
    • Big File tablespace
    • Creating big file Tablespace
    • Altering a Bigfile Tablespace
    • Identifying a Bigfile Tablespace
    • Dictionary Managed Tablespace
    • Creating Dictionary Managed Tablespace
    • Specifying Tablespace Default Storage Parameters
    • Coalescing Free Space in Dictionary – Managed Tablespaces
    • Manually Coalescing Free Space

5. Managing User Privileges And Roles

    • Understanding User Privileges and Roles
    • System Privileges
    • Accessing Objects in the SYS Schema
    • Object Privileges
    • User Roles
    • Creating Role
    • Granting Privileges and Roles
    • Grant With Admin O

1. Oracle Data Pump

    • Data Pump Component
    • Data Pump New Features
    • How Does Data Pump Access Data?
    • Direct Path Loads and Unloads
    • Situations in Which Direct Path Load Is Not Used
    • Situations in Which Direct Path Unload Is Not Used
    • External Tables
    • Accessing Data Over a Database Link
    • What Happens During Execution of a Data Pump Job?
    • Coordination of a Job
    • Tracking Progress within a Job
    • Filtering Data and Metadata During a Job
    • Transforming Metadata during a Job
    • Maximizing Job Performance
    • Loading and Unloading of Data
    • Monitoring Job Status
    • Monitoring the Progress of Executing Jobs
    • File Allocation
    • Specifying Files and Adding Additional Dump Files
    • Default Locations for Dump, Log, and SQL Files
    • Moving Data Between Different Database Versions
    • Original Export and Import Versus Data Pump Export and Import
    • How Data Pump Export Parameters Map to Those of the Original Export Utility
    • How Data Pump Import Parameters Map to Those of the Original Import Utility

2. RMAN Concepts

    • Configuring the Environment for RMAN Backups
    • Showing and Clearing Persistent RMAN Configurations
    • Configuring the Default Device for Backups: Disk or SBT
    • Configuring the Default Type for Backups: Backup Sets or Copies
    • Configuring Channels
    • Configuring Control File and Server Parameter File Autobackups
    • Configuring RMAN to Make Backups to a Media Manager
    • Configuring the Backup Retention Policy
    • Configuring Backup Optimization
    • Configuring Oracle Flashback Database and Restore Points
    • About RMAN Channels
    • Channel Control Options for Manual and Automatic Channels
    • Channel Failover
    • About RMAN Backups
    • About Image Copies
    • RMAN Backup Types
    • Incremental Backups
    • RMAN Backup Errors
    • Tests and Integrity Checks for Backups
    • Detecting Physical and Logical Block Corruption
    • Backup Validation with RMAN
    • Restoring Files with RMAN
    • Mechanics of Restore Operations
    • File Selection in Restore Operations
    • Datafile Media Recovery with RMAN
    • Mechanics of Recovery: Incremental Backups and Redo Logs
    • Incomplete Recovery
    • Tablespace Point-in-Time Recovery
    • Block Media Recovery with RMAN
    • Database Duplication with RMAN (CLONING)

3. User-Managed Backups

    • Cold Backup (consistent Backup)
    • Take details of database Files& proceed with backup
    • Cold Backup (inconsistent Backup)
    • Querying V$ Views to Obtain Backup Information
    • Listing Database Files Before a Backup
    • Determining Datafile Status for Online Tablespace Backups
    • Making User-Managed Backups of the Whole Database
    • Backing Up the Control File to a Binary File
    • Backing Up the Control File to a Trace File
    • Running the DBVERIFY Utility

After the course completion, an exam will be conducted to judge your knowledge along with the live project work completion check and you will be awarded a certificate from 3RI Technologies.

Yes, we provide 100% placement assistance to our students. We have a dedicated team for Placement and tie ups with 300+ MNC’s and SME companies.


Yes we conduct demo classes every weekend. Please contact us for more details.

Close Menu
Call Now ButtonCall Now


3RI Brochure