back to Course Categories | back | print
Oracle10g Administration Workshop I (R1 and R2)          

Duration: 5 days

Description 
This class will teach students the core skills required to manage an Oracle10g Release 2 Database Server. Oracle10g the Self-Managing database contains significant functionality to simplify database administration. Students will learn how to easily manage an Oracle Ecosystem from the Oracle Enterprise Manager Database Console as well as all the detailed commands. Students will learn how an Oracle10g 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 Oracle10g database. This class will prepare you for the Oracle Certified Associate Exam.

Topics

  • The Oracle10g architecture
  • How to Manage an Oracle10g 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
  • Oracle10g instance memory management
  • Dynamic SGA
  • Oracle10g 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
  • Oracle9i resumable space allocation
  • Security using roles, privileges and fine-grained access control
  • Methods for implementing roles
  • Object priviliges
  • 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
  • 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.

  • This is one of the "WOW" classes you will take an an IT professional.

 
 
 

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