Oracle DBA Training

Call Us: +91 95000 19355

Untitled-2

At Essha Technologies, our training network is well-connected with the professional team of people who have in-depth knowledge in Oracle DBA and its related concepts. They can teach every part of Oracle DBA in a brilliant way with our well-organized syllabus patterns and ideal teaching methods. Our syllabus patterns are completely aimed to give a great base for students who desire to enrich their professional career with abundant knowledge in Oracle DBA.

Oracle database 11g workshop 1

Exploring the Oracle Database Architecture

Oracle Database Architecture Overview

Oracle ASM Architecture Overview

Process Architecture

Memory structures

Logical and physical storage structures

ASM storage components

Installing your Oracle Software

Tasks of an Oracle Database Administrator

Tools Used to Administer an Oracle Database

Installation: System Requirements

Oracle Universal Installer (OUI)

Installing Oracle Grid Infrastructure

Installing Oracle Database Software

Silent Install

Creating an Oracle Database

Planning the Database

Using the DBCA to Create a Database

Password Management

Creating a Database Design Template

Using the DBCA to Delete a Database

Managing the Oracle Database Instance

Start and stop the Oracle database and components

Use Oracle Enterprise Manager

Access a database with SQLPlus

Modify database installation parameters

Describe the stages of database startup

Describe database shutdown options

View the alert log

Access dynamic performance views

Manage the ASM Instance

Set up initialization parameter files for ASM instance

Start up and shut down ASM instances

Administer ASM disk groups

Configuring the Oracle Network Environment

Use Enterprise Manager to create and configure the Listener

Enable Oracle Restart to monitor the listener

Use tnsping to test Oracle Net connectivity

Identify when to use shared servers and when to use dedicated servers

Managing Database Storage Structures

Storage Structures

How Table Data Is Stored

Anatomy of a Database Block

Space Management in Tablespaces

Tablespaces in the Preconfigured Database

Actions with Tablespaces

Oracle Managed Files (OMF)

Administering User Security

Database User Accounts

Predefined Administrative Accounts

Benefits of Roles

Predefined Roles

Implementing Profiles

Managing Data Concurrency

Data Concurrency

Enqueue Mechanism

Resolving Lock Conflicts

Deadlocks

Managing Undo Data

Data Manipulation

Transactions and Undo Data

Undo Data Versus Redo Data

Configuring Undo Retention

Implementing Oracle Database Auditing

Describe DBA responsibilities for security

Enable standard database auditing

Specify audit options

Review audit information

Maintain the audit trail

Database Maintenance

Manage optimizer statistics

Manage the Automatic Workload Repository (AWR)

Use the Automatic Database Diagnostic Monitor (ADDM)

Describe and use the advisory framework

Set alert thresholds

Use server-generated alerts

Use automated tasks

Performance Management

Performance Monitoring

Managing Memory Components

Enabling Automatic Memory Management (AMM)

Automatic Shared Memory Advisor

Using Memory Advisors

Dynamic Performance Statistics

Troubleshooting and Tuning Views

Invalid and Unusable Objects

Backup and Recovery Concepts

Part of Your Job

Statement Failure

User Error

Understanding Instance Recovery

Phases of Instance Recovery

Using the MTTR Advisor

Media Failure

Archive Log Files

Performing Database Backups

Backup Solutions: Overview

Oracle Secure Backup

User-Managed Backup

Terminology

Recovery Manager (RMAN)

Configuring Backup Settings

Backing Up the Control File to a Trace File

Monitoring the Flash Recovery Area

Performing Database Recovery

Opening a Database

Data Recovery Advisor

Loss of a Control File

Loss of a Redo Log File

Data Recovery Advisor

Data Failures

Listing Data Failures

Data Recovery Advisor Views

Moving Data

Describe ways to move data

Create and use directory objects

Use SQL*Loader to move data

Use external tables to move data

General architecture of Oracle Data Pump

Use Data Pump export and import to move data

Working with Support

Use the Enterprise Manager Support Workbench

Work with Oracle Support

Log service requests (SR)

Manage patches

Course Topics Oracle     DBA Workshop 2

Oracle Database Architecture Overview

Oracle ASM Architecture Overview

Process Architecture

Memory structrues

Logical and physical storage structures

ASM storage components

Installing your Oracle Software

Tasks of an Oracle Database Administrator

Tools Used to Administer an Oracle Database

Installation: System Requirements

Oracle Universal Installer (OUI)

Installing Oracle Grid Infrastructure

Installing Oracle Database Software

Silent Install

Creating an Oracle Database

Using the DBCA to Create a Database

Password Management

Creating a Database Design Template

Using the DBCA to Delete a Database

Managing the Oracle Database Instance

Start and stop the Oracle database and components

Use Oracle Enterprise Manager

Access a database with SQLPlus

Modify database installation parameters

Describe the stages of database startup

Describe database shutdown options

View the alert log

Access dynamic performance views

Manage the ASM Instance

Set up initialization parameter files for ASM instance

Start up and shut down ASM instances

Administer ASM disk groups

Configuring the Oracle Network Environment

Use Enterprise Manager to create and configure the Listener

Enable Oracle Restart to monitor the listener

Use tnsping to test Oracle Net connectivity

Identify when to use shared servers and when to use dedicated servers

Managing Database Storage Structures

Storage Structures

How Table Data Is Stored

Anatomy of a Database Block

Space Management in Tablespaces

Tablespaces in the Preconfigured Database

Actions with Tablespaces

Oracle Managed Files (OMF)

Administering User Security

Database User Accounts

Predefined Administrative Accounts

Benefits of Roles

Predefined Roles

Implementing Profiles

Managing Data Concurrency

Data Concurrency

Enqueue Mechanism

Resolving Lock Conflicts

Deadlocks

Managing Undo Data

Data Manipulation

Transactions and Undo Data

Configuring Undo Retention

Implementing Oracle Database Auditing

Describe DBA responsibilities for security

Enable standard database auditing

Specify audit options

Review audit information

Maintain the audit trail

Database Maintenance

Manage optimizer statistics

Manage the Automatic Workload Repository (AWR)

Use the Automatic Database Diagnostic Monitor (ADDM)

Describe and use the advisory framework

Set alert thresholds

Use server-generated alerts

Use automated tasks

Performance Management

Performance Monitoring

Managing Memory Components

Enabling Automatic Memory Management (AMM)

Automatic Shared Memory Advisor

Using Memory Advisors

Dynamic Performance Statistics

Troubleshooting and Tuning Views

Invalid and Unusable Objects

Backup and Recovery Concepts

Part of Your Job

Statement Failure

User Error

Understanding Instance Recovery

Phases of Instance Recovery

Using the MTTR Advisor

Media Failure

Archive Log Files

Performing Database Backups

Backup Solutions: Overview

Oracle Secure Backup

User-Managed Backup

Terminology

Recovery Manager (RMAN)

Configuring Backup Settings

Backing Up the Control File to a Trace File

Monitoring the Flash Recovery Area

Performing Database Recovery

Opening a Database

Data Recovery Advisor

Copyright © 2013, Oracle. All rights reserved. Page 4

Loss of a Control File

Loss of a Redo Log File

Data Recovery Advisor

Data Failures

Listing Data Failures

Data Recovery Advisor Views

Moving Data

Describe ways to move data

Create and use directory objects

Use SQL*Loader to move data

Use external tables to move data

General architecture of Oracle Data Pump

Use Data Pump export and import to move data

ORACLE DBA WORKSHOP 3 (PERFORMANCE TUNING)

Tuning Questions

Who tunes

What to tune

How to tune

Monitoring With Basic Tools

Monitoring tools overview

Enterprise Manager

V$ views, Statistics and Metrics

Wait Events

Time Model: Overview

Using Automatic Workload Repository

Automatic Workload Repository: Overview

Automatic Workload Repository Data

Database Control and AWR

Generating AWR Reports in SQL*Plus

Identifying the Problem

Tuning Life Cycle Phases

Identify a Tuning Issue

Remedy one problem

Identifying Problem SQL Statements

Characteristics of a bad SQL statement

Role of the Optimizer

Generate explain plan

Access Paths Choices

Trace the execution

Influencing the Optimizer

Manage Optimizer Statistics

Calibrate I/O

Optimizer Cost

Changing Optimizer Behavior

SQL Plan Management

Automatic Maintenance Tasks

SQL Profiles

SQL Access Advisor

SQL Outlines

SQL Plan Baselines

Change Management

Types of changes

SQL Performance Analyzer

DB Replay

Server-Generated Alerts

Using Metrics and Alerts

Benefits of Metrics

Database Control Usage Model

User-Defined SQL Metrics

Using AWR Based Tools

Automatic Maintenance Tasks

Using ADDM

Using Active Session History

Historical Data View

Monitoring an Application (Using Services)

Service Overview

Managing Service

Service Aggregation and Tracing

Tracing Your Session

Baselines

Working with Metric Baselines

Setting Adaptive Alert Thresholds

Configuring Normalization Metrics

Tuning the Shared Pool

Shared Pool Operation

Mutex

Statspack/AWR Indicators

Library Cache Activity

Diagnostic Tools

UGA and Oracle Shared Server

Large Pool

Tuning the Buffer Cache

Architecture

Tuning Goals and Techniques

Symptoms

Solutions

Tuning PGA and Temporary Space

Monitoring SQL Memory Usage

Temporary Tablespace Management

Automatic Memory Management

Automatic Memory Management Architecture

Dynamic SGA Feature

Managing Automatic Memory Management

Tuning Block Space Usage

Space Management

Extent Management

Anatomy of a Database Block

Block Space Management

Tuning I/O

I/O Architecture

Striping and Mirroring

Using RAID

I/O Diagnostics

Using Automatic Storage Management

: Performance Tuning: Summary

Important Initialization Parameters with Performance Impact

Database High Availability: Best Practices

Tablespace: Best Practices

Statistics Gathering

Using Statspack

Introduction to Statspack

Capturing Statspack Snapshots

Reporting with Statspack

Statspack considerations

Statspack and AWR

Do not miss bonus page with web elements and short codes for realization in your projects. You will get good content. Lorem Ipsum is simply dummy text of the printing.

Other Courses

Back to Top