Online Alter Session eLearning Training

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

Oracle8i Performance Tuning Optimizing Sorts Minimizing Contention Course Overview This course is the third in a three-part Oracle8i Performance Tuning series. This interactive course introduces the participants improving performance for sort operations. The student will be able to identify the SQL operations that require sorts, ensure that sorting is done in memory where possible, use direct writes for large sorts and allocate temporary space appropriately. more...

Oracle8 Database Administration - Manage an Instance Course Overview This course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course, participants will learn about the concepts and procedures associated with Oracle architectural components, using the database administration tools, managing an Oracle instance, and using National Language Support. L earn To:  more...