|
Provided by: 123-CBT Computer Based Training Oracle8 Database Administration - Manage Storage Structures |
 |
Training
Provided by 123-CBT Computer Based Training
Course Overview
This course is the third in a five-part series covering the database administration strategies and procedures provided in Oracle8. 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.
Learn To:
- Identify how storage structure components work.
- Manage rollback segments.
- Manage temporary segments.
- Manage indexes.
Content Emphasis
Skills-Based
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 60111, 60112 and 60113. In addition, participants should have taken the first two parts of the Oracle8 Database Administration series, courses 61311 and 61312.
Total Learning Time
6 - 8 Hour(s)
Course Contents
Unit 1: Storage Structures
Duration: 1 - 2 Hour(s)- 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
Duration: 1 - 2 Hour(s)- 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
Duration: 2 Hour(s)- 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
Duration: 2 Hour(s)- 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.
|
|
||||||||||
Oracle8 Database Administration - Manage Storage Structures
--
About The Training Provider: 123-CBT Computer Based Training
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6. 10
- Access 2003
- Acrobat 6. 0
- ASP
- ASP. NET
- C
- Captivate 1. 0
- Crystal Reports 8. 5
- Crystal Reports v10
-...
