Oracle8i Database Administration: Manage Storage Structures

This course is the third in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course participants will learn the concepts associated with storage structure components. In addition this course will teach users how to create and maintain rollback segments temporary segments and indexes.

This is primarily online training This is an online eLearning or CBT training program Contact Serebra Learning Corporation for more information

Duration: 8 hours Training Presented in: English

Audience

Database Administrators System Administrators Network Administrators Technical Support Professionals. Participants should have taken Oracle SQL and SQL*Plus: Basic SELECT Statements (61110) Oracle SQL and SQL*Plus: Data Retrieval Techniques (61111) Oracle SQL and SQL*Plus: DML and DDL (61112) Oracle PL/SQL: Basics (60113) Oracle8i Database Administration: Manage an Instance (63311) and Oracle8i Database Administration: Create a Database (63312). This course will help candidates prepare for the Oracle8i Certified DBA Architecture and Administration exam 1Z0-023.

Objective

• Identify the database storage structures and their relationships.
• 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*Plus Worksheet.
• Retrieve the information to view the extents for a given segment by using Oracle SQL*Plus Worksheet.
• Write a query to check the extents for a given segment by using Oracle SQL*Plus 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*Plus Worksheet.
• Retrieve information about rollback segments with currently active transactions by using Oracle SQL*Plus 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*Plus Worksheet.
• Retrieve the information about temporary segment activity by using Oracle SQL*Plus 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*Plus Worksheet.
• Drop a given index by using Oracle Schema Manager.
• Retrieve index information by using Oracle SQL*Plus 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

• Oracle8i Database Administration: Create a Database
• Oracle8i Database Administration: Manage an Instance
• Oracle8i Database Administration: Manage Data Storage
• Oracle8i Database Administration: Manage Security