Oracle 11g DBA Release 2 Professional

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

Class Summary

Oracle 11g 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 11g to familiarise delegates with advanced concepts of the Oracle 11g 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 11g Administrator Certified Professional (OCP) Exam (code 1Z1-053). 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 11g 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 11g database and a familiarity with the use of graphical user interfaces for either Windows or Linux operating systems is required.

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

Each delegate will require exclusive use of a suitably equipped PC, together with an installed Oracle 11g Release 2 for Linux. Please consult the Oracle TechNet website to review the Installation Notes Hardware Requirements for Linux - free registration is required to view this website.

Content

• Oracle 11g 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; predefined resource groups and plans.
  
  
• Globalisation; setting language parameters for instances and sessions; linguistic sorting; internationalising datetime information; case and accent insensitive searches.
  
  
• Networking: Listener security; external procedures; Oracle Restart Configuration.
  
  
• Basic Recovery: configuring Recovery Manager; retention policies, channels, control file autobackups; managing fast 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 Fast 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; remote and multiple destination jobs; file watcher; email notifications.
  
  
• 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; table compression; deferred segment creation; 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; tablespace encryption; data masking.
  
  
• Resiliency and Fault Tolerance; overviews of automatic health monitor; automatic diagnostic repository; database replay and real application testing; Data Guard; Fast Application Notification.
  
  
• Database Edition Management; overviews of database editions; associated DBA tasks; setting and querying the default edition; using an edition; dictionary views.
  
  
• 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 11g are under development; please contact us for the latest information.