Price: Check with seller

Sponsored Ads

Description

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:9
Reference Id:#498038
Phone Number: 8939915577
Website URL: Click To Visit
Current Rating: /5 0 Vote
Copyright © 2017 |   All Rights Reserved |   TuffClassified |   24x7 support |   Email us: query[at]tuffclassified.com