|
Provided by: 123-CBT Computer Based Training Oracle8i Database Admin Manage Storage Structures |
 |
Course Overview
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.
Learn To:
- Identify the database storage structures and their relationships.
- Manage rollback segments.
- Manage temporary segments.
- Manage indexes.
Content Emphasis
Skills-Based
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.
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*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
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*Plus Worksheet.
- Retrieve inf
This is primarily online training 
This is an online eLearning or CBT training program 
This program may be available on CD 
Contact 123-CBT Computer Based Training for more information Training Presented in: English
