Signup as a Tutor

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

Enquire

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.

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 support@urbanpro.com 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 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

Share

Professional Training on Oracle DBA

Professional Training on Oracle DBA

Pimple Saudagar, Pune

No Reviews Yet
0 Interested

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

DBA-I

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
f. PCTUSED
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

DBA-II
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
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
Is Not Used
Unload Is Not Used
Job
Jobs
Additional Dump Files
and SQL Files
2. RMAN Concepts
• Configuring the Environment for RMAN
Backups
? 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
(CLONING)
RMAN Configurations
Backups: Disk or SBT
Backups: Backup Sets or Copies
Parameter File Autobackups
to a Media Manager
Policy
Database and Restore Points
and Automatic Channels
Backups
Corruption
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.

Pre-requisites

• 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
Content
Reviews
There are no Reviews yet. Be the First to Review
Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask


There are no Reviews yet. Be the First to Review

Date and Time

Not decided yet.

cash back100% Money Back Guarentee

About the Trainer


We have almost 25 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 may years of expertise experience, they share their knowledge as a KT sessions or visiting faculty.
Seats Left-

Students Interested 0

Course Id: 14446