Price: Check with seller


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



More Details

Total Views:11
Reference Id:#498038
Phone Number:8939915577
Website URL:Click To Visit
Current Rating: /5 0 Vote
Copyright © 2018 |   All Rights Reserved | |   24x7 support |   Email us : info[at]