Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.


Professional Training on Oracle DBA

No Reviews Yet

Pimple Saudagar, Pune

Course ID: 14446

Pimple Saudagar, Pune

Students Interested 0 (Seats Left 0)

No Reviews Yet

About the Course

We have designed this course specially for people who are interested to change their work domain or either they want to become a good Database Administrator in Oracle DBMS.

Topics Covered


1. Oracle 10g Installation
• Pre-Installation Tasks
a. Logging In to the System as root
b. Checking Hardware Requirement
c. Checking Software Requirement
d. Checking Network Setup
e. Creating Operating System Groups and Users
f. Configuring kernel parameters
g. Identifying Required Software Directories
h. Identifying or Creating ORACLE_BASE directory
i. Installation screens
2. Oracle Database Architect
• System Global Area (SGA)
a. Shared Pool
b. Database Buffer Cache
c. The Redo Log Buffer
d. Java Pool
e. Large pool
f. Stream Pool
• Fixed SGA
a. Automatic Shared Memory Management
b. The Oracle Background Process
3. Oracle Data Block Management
• Introduction
• Data block Overview
a. Header (Common and Variable)
b. Table Directory
c. Row Directory
d. Overhead
e. Row Data
f. Free Space
• Free Space Management
a. Availability and Optimization of Free Space in a Data Block
b. Row Chaining and Migrating
c. PCTFREE, PCTUSED, and Row Chaining
d. The PCTFREE Parameter
e. The PCTUSED Parameter
g. How PCTFREE and PCTUSED Work Together
• Extent Overview
a. When Extents Are Allocated
b. Determine the Number and Size of Extents
c. How Extents Are Allocated
d. When Extents Are Deallocated
e. Extents in Nonclustered Tables
f. Extents in Clustered Tables
g. Extents in Materialized Views and Their Logs
h. Extents in Indexes
i. Extents in Temporary Segments
j. Extents in Rollback Segments
• Segment Overview
a. Introduction to Data Segments
b. Introduction to Index Segments
c. Introduction to Temporary Segments
d. Operations that Require Temporary Segments
e. Segments in Temporary Tables and Their Indexes
f. How Temporary Segments Are Allocated
g. Allocation of Temporary Segments for Queries
h. Allocation of Temporary Segments for Temporary Tables and Indexes
• Undo Management
a. Undo Quota
b. Automatic Undo Retention
c. External Views
4. Managing Tablespaces
• Using Multiple Tablespaces
• Creating Tablespaces
• Locally Managed Tablespace
a. Creating a Locally Managed Tablespace
b. Segment Space management in locally managed tablespace
• Big File tablespace
a. Creating big file Tablespace
b. Altering a Bigfile Tablespace
c. Identifying a Bigfile Tablespace
• Dictionary Managed Tablespace
a. Creating Dictionary Managed Tablespace
b. Specifying Tablespace Default Storage Parameters
c. Specifying Tablespace Default Storage Parameters
d. Coalescing Free Space in Dictionary-Managed Tablespaces
e. Manually Coalescing Free Space
5. Managing User Privileges And Roles
• Understanding User Privileges and Roles
a. System Privileges
b. Accessing Objects in the SYS Schema
c. Object Privileges
d. User Roles
e. Creating Role
• Granting Privileges and Roles
• Grant With Admin Option

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
? Situations in Which Direct Path
? 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
? Transforming Metadata during a Job
? Maximizing Job Performance
? Loading and Unloading of Data
? Monitoring Job Status
? Monitoring the Progress of Executing
• File Allocation
? Specifying Files and Adding
? Default Locations for Dump, Log,
• Moving Data Between Different Database
• 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
Is Not Used
Unload Is Not Used
Additional Dump Files
and SQL Files
2. RMAN Concepts
• Configuring the Environment for RMAN
? Showing and Clearing Persistent
? Configuring the Default Device for
? Configuring the Default Type for
? Configuring Channels
? Configuring Control File and Server
? Configuring RMAN to Make Backups
? Configuring the Backup Retention
? Configuring Backup Optimization
? Configuring Oracle Flashback
• About RMAN Channels
? Channel Control Options for Manual
? Channel Failover
• About RMAN Backups
? About Image Copies
• RMAN Backup Types
? Incremental Backups
? RMAN Backup Errors
? Tests and Integrity Checks for
? Detecting Physical and Logical Block
? 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
? Incomplete Recovery
? Tablespace Point-in-Time Recovery
? Block Media Recovery with RMAN
• Database Duplication with RMAN
RMAN Configurations
Backups: Disk or SBT
Backups: Backup Sets or Copies
Parameter File Autobackups
to a Media Manager
Database and Restore Points
and Automatic Channels
Backups and Redo Logs

Who should attend

• Freshers to make their career into IT / Software Field as Data Base Administrator(DBA).
• BPO guys, people who are working in different fields and want to become a DBA.


• Strong knowledge of Oracle SQL
• Strong conceptual knowledge of RDBMS concepts.

What you need to bring

We will provide you all the necessary things to learn the C Programming language, you don't need to bring anything with you for this course."""

Key Takeaways

• RDMBS knowledge
• Way to proceed for the next step which is RAC

Date and Time

Not decided yet.

About the Trainer

4.52 Avg Rating

73 Reviews

96 Students

38 Courses

We have almost 70+ trainers with us for all different technologies, we have associated with so many people in the IT industry who actually works on the real-time projects have many years of expertise experience, they share their knowledge as a KT session or visiting faculty.


No reviews currently Be the First to Review


Students Interested 0 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for Oracle Database Post your requirement now


Submit your enquiry for Professional Training on Oracle DBA

Please enter valid question or comment

Please select a category

No matching category found.

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

Please check the fields again.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With 3RI Technologies

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please enter the OTP sent to your registered mobile number.

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on, to fulfill their learning requirements across 1,000+ categories. Using, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more