back to Course Categories | back | print
Oracle11g Administration Workshop I          

Duration: 5 days

Description 
This class will teach students the core skills required to manage an Oracle11g Release 2 Database Server. Students will learn how to install, manage and configure an Oracle Database server using best practices. Students will learn how an Oracle11g database works (architecture), storage management, configuring an instance, security, data management, user management, configuring self-management, advisors, diagnostic tools, performance monitoring and backup/recovery techniques. By the end of the class each student will have gone through the main tasks necessary to administer an Oracle11g database.

Topics

  • The Oracle 11g architecture
  • How to Manage an Oracle11g Database
  • The role of an Oracle DBA
  • Tasks and responsibilities
  • Mastering the self managing database
  • Creating an Oracle database
  • Developing a management philosophy
  • DBA tools
  • SQL*Plus and iSQL*Plus
  • SQL Interfaces
  • The Oracle Enterprise Manager Console
  • Starting and stopping the agent
  • Starting and stopping the OEM console
  • Working with listeners
  • Oracle11g instance memory management
  • Dynamic SGA
  • Oracle11g background processes
  • Shared vs. Dedicated servers
  • Configuring shared servers
  • Monitoring shared servers
  • Managing the Oracle database
  • Optimal Flexible Architecture
  • PL/SQL in the Oracle database
  • Managing Java in the database
  • Database Configuration Assistant
  • Oracle Universal Installer
  • Oracle Managed files
  • Managing control files
  • Adding and removing control files
  • Managing redo log files
  • Working with redo log groups
  • Adding and removing redo log files
  • Archiving redo log files
  • Management of schema objects
  • System versus non-system tablespaces
  • Working with datafiles
  • Locally Managed tablespaces
  • Local vs. Dictionary Managed tablespaces
  • Automatic undo management
  • Undo segment management
  • The undo advisor
  • Starting an Oracle instance
  • Shutting down an Oracle instance
  • Temporary tablespaces
  • Temporary tablespace groups
  • Multiple block sizes
  • Managing an spfile
  • Initialization file and parameters
  • Parameter file persistence
  • Spfile versus Initialization file
  • Managing tables and indexes
  • Block, extent, segment and tablespace configuration
  • Managing schema objects
  • Managing tables
  • Managing constraints
  • Managing indexes
  • Maintaining tables
  • Maintaining indexes
  • Working with views
  • Automatic segment free space including DBMS_SPACE and DBMS_REPAIR
  • Setting physical storage characteristics
  • Using the DBMS_STATS package to generate statistics
  • Automatic generation of statistics
  • Execution plan cache
  • Resumable space allocation
  • Security using roles, privileges and fine-grained access control
  • Methods for implementing roles
  • Object privileges
  • System privileges
  • Resource Manager and consumer groups
  • Troubleshooting an Oracle server
  • Successful Self-Management
  • Setting warnings and alert thresholds
  • Collecting and using baseline metrics
  • Tuning and diagnostic advisors
  • Automatic Database Diagnostic Monitor (ADDM)
  • Automatic Workload Repository
  • Working with data dictionary views
  • Monitoring the alert log and trace files
  • Database triggers
  • Oracle utilities
  • ASM fundamentals
  • Using export
  • Using import
  • Using SQL loader
  • Using external tables
  • Performance monitoring
  • Gathering statistics
  • Evaluating statistics
  • Tuning advisors
  • Backup and Recovery Fundamentals
  • Database fundamentals
  • ARCHIVELOG vs. NOARCHIVELOG mode
  • Creating backups
  • Incremental backups
  • Managing the flash recovery area
  • Database recovery
  • Recovering from a lost control file
  • Recoverying from a lost data file
  • Recovering from a lost redo log file

Prerequisites

  • Introduction to Oracle Fundamentals class or equivalent experience. Attendees should have a solid understanding of SQL and computer fundamentals.


 
 
 

Trubix Inc. P.O. Box 2235 Littleton, CO 80161 | 1.866.4-TRUBIX • 303.730.6800
email: info@trubix.com
....................................................................................................................................................................

Training Service | Consulting / Mentoring | Public Schedule | Course Listings | Tru iLearning | About Us | Contact Us
Oracle DBA Classes | Oracle Dev Classes | Oracle App Server Classes | Linux / Unix Classes
SQL Server / .NET / Tools / DB2 Classes / Public Classes

 

 
all content property © 2006, 2007Trubix Inc.| site design by Art Z design