Online Using Oracle Data eLearning Training
From 123-CBT Computer Based Training
Oracle9i Performance Tuning Optimizing Sorts Minimizing Contention

... Learning Time 6 to 8 hours 64333 Objectives Unit 1: Using Oracle Data Blocks Efficiently 1.5 - 2 hours 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
more...
Oracle8i Performance Tuning Optimizing Sorts Minimizing Contention

...rning Time 6 - 8 Hour(s) Course Contents Unit 1: Using Oracle Data Blocks Efficiently Duration: 1.5 - 2 Hour(s) Match the component of database storage with its definition. Avoid dynamic allocation of extents by using the ALTER TABLE command. Avoid the dynamic allocation disadvantages by creating a locally managed tablespace. Select the advantages of incorporating large
more...
Oracle8 Performance Tuning Optimizing Sorts and Minimizing Contention

...ning Time
6 - 7 Hour(s)
Course Contents
Unit 1: Using Oracle Data Blocks Efficiently
Duration: 1 Hour(s)
Match components of database storageunits to their definition.
Query the dba_tables to display segments with less than 10% free blocks.
Manually allocate an extent.
Choose the advantages of incorporating large extents into database design.
Identify characteristics of
more...
Oracle8 Database Administration - Manage Data

...ize performance of SQL*Loader.
Load data into a table by using Oracle Data Manager.
Identify the methods of troubleshooting the problems that may occur during a SQL*Loader data load.
Identify the uses of the export and import utilities.
Identify the objects that can be exported using different export modes.
Identify the features of the export paths.
Match the command line parameters for
more...
