|
Provided by: 123-CBT Computer Based Training Oracle Database 10g Administration Workshop II Part 3 |
 |
Training
Provided by 123-CBT Computer Based Training
This course covers various functions of the Flashback technology. In addition to performing flashback operations at the database level, you can flash back a table or recover a table that has been dropped by mistake. The course also covers the tools used to monitor and improve database performance as well as detect and repair database corruption.
Learn To:
The target audience is Data Administrators, Technical Consultants, Support Engineers, and Sales Consultants.
Deployment:
Self-Study
Language Options:
US English
Total Learning Time:
8 hours
Objectives:
Unit 1: Flashback Technology
Learn To:
- Identify features of Flashback technology.
- Identify features of Flashback Database.
- Sequence the steps for configuring Flashback Database using SQL.
- Identify features of block corruption.
- Identify features of the DBVERIFY utility.
- Identify features of the ANALYZE command.
- Identify features of the advisory framework.
- Sequence the steps in an advisor tuning session.
- Sequence the steps for creating a custom Automatic Database Diagnostic Monitor (ADDM) task manually.
The target audience is Data Administrators, Technical Consultants, Support Engineers, and Sales Consultants.
Deployment:
Self-Study
Language Options:
US English
Total Learning Time:
8 hours
Objectives:
Unit 1: Flashback Technology
- Identify features of Flashback technology.
- Identify features of Flashback Database.
- Sequence the steps for configuring Flashback Database using SQL.
- Sequence the steps for configuring Flashback Database using Enterprise Manager (EM).
- Identify options for monitoring Flashback Database.
- Identify guidelines for managing the Flash Recovery Area.
- Identify the methods for performing a Flashback Database operation.
- Identify considerations for using the Flashback Database feature.
- Identify features of Flashback time navigation methods.
- Identify options for recovering a dropped table.
- Identify the steps to flashback dropped tables by using EM.
- Identify options for managing the Recycle Bin.
- Identify features of Flashback Versions Query.
- Sequence the steps to perform Flashback Versions Query using Enterprise Manager (EM).
- Match various pseudocolumns used in the Flashback Versions Query syntax with their descriptions.
- Identify features of Flashback Transaction Query.
- Identify features of Flashback Table.
- Identify considerations related to a Flashback Table operation.
- Identify features of guaranteed undo retention.
- Identify features of block corruption.
- Identify features of the DBVERIFY utility.
- Identify features of the ANALYZE command.
- Identify features of the DB_BLOCK_CHECKING parameter.
- Sequence the steps for using the DBMS_REPAIR package to manage data block corruption.
- Identify features of Block Media Recovery (BMR).
- Identify the features of the BMR interface.
- Identify tasks performed for handling a corrupted object.
- Identify features of the advisory framework.
- Sequence the steps in an advisor tuning session.
- Sequence the steps for creating a custom Automatic Database Diagnostic Monitor (ADDM) task manually.
- Identify features of SQL Tuning Advisor.
- Sequence the steps for using SQL Tuning Advisor.
- Sequence the steps to use the SQL Access Advisor for schema tuning.
- Identify features of Memory Advisor.
- Identify features of the Segment Advisor.
- Identify the characteristics of a growth trend report.
- Identify features of the segment resource es
This is primarily online training 
This is an online eLearning or CBT training program 
This program may be available on CD 
Contact 123-CBT Computer Based Training for more information Training Presented in: English
Oracle Database 10g Administration Workshop II Part 3
--
About The Training Provider: 123-CBT Computer Based Training
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6.10
- Access 2003
- Acrobat 6.0
- ASP
- ASP.NET
- C
- Captivate 1.0
- Crystal Reports 8.5
- Crystal Reports v10
- Dreamweaver MX
-...
