Online Pctused eLearning - Training Resources

Oracle9i Performance Tuning Optimizing Sorts Minimizing Contention 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. Learn To:  more...

Oracle8i Performance Tuning Optimizing Sorts Minimizing Contention ...a block sizes. Identify the functions of the PCTFREE and PCTUSED parameters. Identify the guidelines for setting the PCTFREE parameter. Calculate and set the PCTFREE parameter when creating a table. Identify the guidelines for setting the PCTUSED parameter. Calculate and set the PCTUSED parameter when creating a table. Identify the characteristics of row migration and chaining. Query a  more...

Oracle8 Performance Tuning Optimizing Sorts and Minimizing Contention ... the report.txt. Identify characteristics of PCTFREE and PCTUSED parameters. Calculate and set the PCTFREE parameter when creating a table. Calculate and set the PCTUSED parameter. Select the situations in which Oracle8 Server coalesces the free space of a data block. Identify characteristics of row migration and chaining. Query a table to display chained rows. Remove migrated rows from  more...