Oracle 10g Database Professional

Who should attend | Prerequisites | Content | Sample Notes | Next Class | Printer Friendly 

Class Summary

Oracle 10g is the first database product from the Oracle Corporation designed for grid computing. As a "self-managing" database, many of the features in this product have been simplified or automated. This class utilises the graphical management tools introduced with Oracle 10g to familiarise delegates with advanced concepts of the Oracle 10g database. Topics covered include advanced database performance tuning, scheduling, automated storage management and using multilingual applications.

By completing this class, and with some further hands-on practice, delegates will be prepared to undertake the Oracle Database 10g Administrator Certified Professional (OCP) Exam (code 1Z0-043). Please note that candidates who wish to obtain the OCP credential must attend one Oracle authorised instructor-led class or instructor-led online class. Further information can be obtained from the Oracle Education website. This Oracle policy may change in the future and you are advised to contact us for up-to-date information.

The class consists of a mixture of lecture and hands on lab exercises.

Who Should Attend

This class is intended for technical staff who need to configure and administer the advanced features of the Oracle 10g database.

For experienced DBA's cross training from other RDBMS products or earlier versions of Oracle, this class can be run in a accelerated three day format. Please contact us to discuss your requirements if this is of interest to you.

Prerequisites

A basic understanding of the Oracle 10g database and a familiarity with the use of graphical user interfaces for either Windows or Linux operating systems is required.

Attendance on our Oracle 10g Associate class (or the equivalent experience or training) is strongly recommended.

Each delegate will require exclusive use of a suitably equipped PC, with Oracle 10g Release 2 Enterprise Edition for Windows or Linux already installed. Please consult the Oracle TechNet website to review the Installation Notes Hardware Requirements for Windows or Linux - free registration is required to view this website. If you require installation assistance for your classroom, this can be arranged - please contact us for advice and assistance if required.

Content

• Oracle 10g Architecture Review: Memory structures, process and disk structures (data files, temp files, redo log files); instances and databases; storage structures; processing for queries, updates and transactions.
  
  
• Performance Tuning: Alert log and trace file information; Enterprise Manager alert management; metric threshold tracking; managing trace files.
  
  
• Resource Manager: Overview; configuring Resource Manager; groups and users; resource plan management; resource plan directives; enabling and disabling resource plans.
  
  
• Globalisation; setting language parameters for instances and sessions; linguistic sorting; internationalising datetime information; case and accent insensitive searches.
  
  
• Networking: Listener security; external procedures.
  
  
• Basic Recovery: configuring Recovery Manager; retention policies, channels, control file autobackups; managing flash recovery area; temporary tablespaces; redo log members; index tablespaces; read-only tablespaces; password files; parameter files.
  
  
• Recovery Manager: Database archivelogging; creating backup sets; creating image copies; block change tracking; listing and reporting on backups and image copies; parallelising backups.
  
  
• Advanced Recovery: Incomplete recovery concepts; incomplete recovery with SQL, RMAN, Enterprise Manager; new database incarnations; recovering using control file autobackups; recovery through resetlogs; point-in-time recovery; secure backup overview.
  
  
• Flashback Technology: Overview and configuration; managing Flash Recovery Area (FRA); recycle bin; change tracking file; flashback log files; monitoring flashback database; recover dropped table; recycle bin; flashback versions; flashback transactions; Enterprise Manager Recovery Wizard.
  
  
• Database Corruption: block corruption; detecting corrupted blocks; DBVERIFY utility; checking blocks during use; repairing corrupted blocks; block media recovery.
  
  
• Oracle Scheduler: Overview; creating jobs, programs and schedules; submitting and monitoring scheduler tasks; scheduler windows; monitoring job executions and instances.
  
  
• Automated Database Management: Database advisors; SQL Tuning advisors; shared memory management; memory advisor; automated PGA management; automated undo retention tuning.
  
  
• Automated Storage Management: ASM overview; setting up an ASM instance; managing ASM disk space; starting and stopping ASM instances; migrating databases to ASM; VLDB (very large database) support; using bigfiles; temporary tablespace groups; .
  
  
• Automated Performance Management: Performance principles; wait conditions; dictionary tuning views; statistic collection mechanisms; workload repository contents; advisory framework; using Automatic Database Diagnostic Monitor; SQL execution plans.
  
  
• Storage Tuning: redo logging; archiving; suspendable operations; table/index management - segment shrink; table/index size estimation; online indexing operations; optimum storage options for performance; identifying and skipping unusable indexes.
  
  
• Database security; virtual private database; policy types; implementing policy functions; monitoring policies; performance implications.
  
  
• Q&A: Where to now?; suggested reading list; further training.
  
  

Sample notes

Please contact us for a sample lesson.

Suggested next class

Further classes that focus on specific performance and tuning features of Oracle 10g are under development; please contact us for the latest information.