Oracle 11g Database Professional
Who should attend | Prerequisites | Content | Sample Notes | Next Class | Printer Friendly 
Class Summary
Oracle 11g is the latest release of the acclaimed relational database
product from the Oracle Corporation. 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 11g database. Topics covered include advanced
database performance tuning, scheduling, automated storage management
and using multilingual applications. The
class has been newly updated for 2008.
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 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. Oracle's certification
for 11g is due for release in early 2008..
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.
|
