|
Provided by: 123-CBT Computer Based Training Oracle9i Performance Tuning Optimizing Sorts Minimizing Contention |
 |
Training
Provided by 123-CBT Computer Based Training
The content of this course includes details about each component of an Oracle database instance, such as data blocks, disks, memory, CPU, and dynamic views. Students learn about migration and chaining, reorganizing indexes, optimizing sort operations, tuning rollback segments, managing automatic undo, monitoring activities, implementing the Oracle shared server, and troubleshooting.
o Avoid dynamic allocation of extents by using the ALTER TABLE command.
o Avoid the dynamic allocation disadvantages by creating a locally managed tablespace.
o Sequence the steps in the sort process.
o Set the SORT_AREA_SIZE parameter by using the ALTER SESSION command.
o Identify the tuning sort goals.
o Match the uses of rollback segments with their definitions.
o Select the characteristics of rollback segment activity.
o Identify the characteristics of rollback segment growth.
o Identify the locking mechanism characteristics.
o Select the statements that characterize DML and DDL locks.
o Identify the DML lock characteristics.
o Sequence the process steps of the Oracle shared server configuration.
o Identify the characteristics of the Oracle shared server.
o Query a dispatcher process to determine the process status using the V$DISPATCHER view.
o Match the component of database storage with its definition.
o Avoid dynamic allocation of extents by using the ALTER TABLE command.
o Avoid the dynamic allocation disadvantages by creating a locally managed tablespace.
o Select the advantages of incorporating large extents into the database design.
o Reclaim the space from the high water mark by using an ALTER TABLE command.
o Query the results of an ANALYZE command to evaluate Oracle data block usage.
o Match the actions for recovering space with their description.
o Identify the characteristics of the Oracle block size.
o Identify the advantages and disadvantages of small data block and large data block sizes.
o Identify the functions of the PCTFREE and PCTUSED parameters.
o Identify the guidelines fo
Learn To:
o Match the component of database storage with its definition.o Avoid dynamic allocation of extents by using the ALTER TABLE command.
o Avoid the dynamic allocation disadvantages by creating a locally managed tablespace.
o Sequence the steps in the sort process.
o Set the SORT_AREA_SIZE parameter by using the ALTER SESSION command.
o Identify the tuning sort goals.
o Match the uses of rollback segments with their definitions.
o Select the characteristics of rollback segment activity.
o Identify the characteristics of rollback segment growth.
o Identify the locking mechanism characteristics.
o Select the statements that characterize DML and DDL locks.
o Identify the DML lock characteristics.
o Sequence the process steps of the Oracle shared server configuration.
o Identify the characteristics of the Oracle shared server.
o Query a dispatcher process to determine the process status using the V$DISPATCHER view.
Audience
The intended audience for this course includes database administrators and application developers, regardless of role or experience level.Deployment Options
Internet / Intranet, Download, LAN, WorkstationAccreditation
NASBA credits: 4 CPE CreditsLanguage Options
American English, Brazilian Portuguese, SpanishTotal Learning Time
6 to 8 hours64333 Objectives
Unit 1: Using Oracle Data Blocks Efficiently 1.5 - 2 hourso Match the component of database storage with its definition.
o Avoid dynamic allocation of extents by using the ALTER TABLE command.
o Avoid the dynamic allocation disadvantages by creating a locally managed tablespace.
o Select the advantages of incorporating large extents into the database design.
o Reclaim the space from the high water mark by using an ALTER TABLE command.
o Query the results of an ANALYZE command to evaluate Oracle data block usage.
o Match the actions for recovering space with their description.
o Identify the characteristics of the Oracle block size.
o Identify the advantages and disadvantages of small data block and large data block sizes.
o Identify the functions of the PCTFREE and PCTUSED parameters.
o Identify the guidelines fo
|
|
||||||||||
Oracle9i Performance Tuning Optimizing Sorts Minimizing Contention
--
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
-...
