Oracle DBA Training In Chennai Adyar With Placement - Greens Tech

Sponsored Ads

Price: Check with seller

Oracle DBA Training Course ContentsOracle Database 11g Administration Workshop I TrainingExploring the Oracle Database A...

  • Category: Language Classes
  • Published: 29/10/2014
  • Current Rating: /5 0 Vote


    Oracle DBA Training Course Contents

    Oracle Database 11g Administration Workshop I Training

    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


    Related Ads

    Leave your comment

    Copyright © 2017 |   All Rights Reserved | |   24x7 support |   Email us: query[at]