Oracle8 Database Administration - Manage Data Storage Structures

Audience

Database Administrators system administrators network administrators and technical support professionals. Prior to taking this course participants should be familiar with SQL and PL/SQL using Procedure Builder or have taken courses 61110 61111 61112 and 60113. In addition participants should have taken the first two parts of the Oracle8 Database Administration series courses 61311 and 61312.

Objective

• Identify how storage structure components work.
• Manage rollback segments.
• Manage temporary segments.
• Manage indexes.

Topics Include

Unit 1: Storage Structures

• Identify the correct order of the components of the storage hierarchy.
• Match the types of data segments with their features.
• Identify the uses of index segments.
• Identify the situations that lead to the creation of various non-schema object segments.
• Identify the situations that lead to the creation of various non-schema object segments.
• Identify the considerations behind the precedence order of storage parameters.
• Coalesce free space in a given tablespace by using Oracle Tablespace Manager.
• Identify the correct sets of objects and their fragmentation propensity levels.
• Match the data block contents with their features.
• Match the block space utilization parameters with the information that they provide.
• Sequence the steps used by the Oracle Server to manage data within a block.
• Retrieve the information to check the current number of extents and blocks allocated to a segment by using Oracle SQL Worksheet.
• Retrieve the information to view the extents for a given segment by using Oracle SQL Worksheet.
• Write a query to check the extents for a given segment by using Oracle SQL Worksheet.

Unit 2: Managing Rollback Segments

• Identify the purposes of rollback segments.
• Identify the rollback segment type given its description.
• Sequence the steps for the process in which rollback segments are used by transactions.
• Identify the conditions under which rollback segments shrink.
• Sequence the steps that Oracle Server uses to ensure read consistency when a transaction occurs.
• Identify the factors to be considered while planning rollback segments.
• Create a rollback segment by using Oracle Storage Manager.
• Bring a rollback segment online by using the Oracle Storage Manager.
• Sequence the steps that Oracle Instance uses to acquire rollback segments when a database opens.
• Change the rollback segment storage parameters by using Oracle Storage Manager.
• Deallocate space from a rollback segment by using Oracle Storage Manager.
• Take a rollback segment offline by using Oracle Storage Manager.
• Remove rollback segment by using Oracle Storage Manager.
• Display the general information about rollback segments by using Oracle Storage Manager.
• Retrieve the statistics about rollback segments by using Oracle SQL Worksheet.
• Retrieve information about rollback segments with currently active transactions by using Oracle SQL Worksheet.
• Identify the solutions to the insufficient space for transactions problem.
• Identify solutions to the read-consistency error.
• Identify the solutions to the blocking session problem.
• Sequence the steps to resolve the error in taking a tablespace offline.

Unit 3: Managing Temporary Segments

• Identify the statements that require the use of temporary segments.
• Identify the features of temporary segments in PERMANENT tablespaces.
• Identify the features of temporary segments in temporary tablespaces.
• Identify the guidelines for using temporary segments.
• Retrieve temporary segment statistics by using Oracle SQL Worksheet.
• Retrieve the information about temporary segment activity by using Oracle SQL Worksheet.

Unit 4: Managing Indexes

• Match the types of indexes with their features.
• Identify the characteristics of B*Tree index.
• Identify the functions of a reverse key index.
• Match the components of a Bitmap index with their contents.
• Differentiate between B*tree indexes and Bitmap indexes.
• Create a normal B*Tree index by using Oracle Schema Manager.
• Create a reverse key index by using Server Manager.
• Create a Bitmap index by using Oracle Schema Manager.
• Modify the index storage parameters by using Oracle Schema Manager.
• Allocate index space by using Server Manager.
• Deallocate index space by using Server Manager.
• Identify the situations in which indexes need to be rebuilt.
• Identify the characteristics of index rebuilds.
• Retrieve index statistics by using Oracle SQL Worksheet.
• Drop a given index by using Oracle Schema Manager.
• Retrieve index information by using Oracle SQL Worksheet.

Duration

8

Minimum Requirements

The CDROM version of this course requires:

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
• At least a double speed CDROM drive.
• An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM and 22MB available hard disk space or file server space.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).

Media

CDROM