Provided by: 123-CBT Computer Based Training Oracle9i Database Admin Manage Storage Structures Click here for more information or to take this course

---

---

Training Provided by 123-CBT Computer Based Training

Course Overview

The Oracle 9i Database Administration: Manage Storage Structures course is the third in a five-part series covering the database administration strategies and procedures provided in Oracle9i. In this course, participants learn the concepts associated with storage structure components. In addition, this course teaches users the procedures for managing segment free space, undo space, temporary segments, and indexes.

Learn To

• Identify the types of segments in the storage hierarchy.
• Identify the benefits, working, and packages of automatic management of segment free space.
• Identify the ways in which extents are controlled by segments.
• Identify the block space utilization parameters.
• Retrieve storage structure information.
• Identify the purposes and the types of rollback segments.
• Explain the processes that rollback segments follow for transactions.
• Plan, create, and acquire rollback segments.
• Modify and remove rollback segments.
• Retrieve rollback segment information from the data dictionary.
• Describe the solutions to rollback segment problems.
• Explain the concepts of automatic management of undo space.
• Identify the purpose and the features of the various types of temporary segments.
• Retrieve temporary segment information from the data dictionary.
• Maintain indexes.
• Monitor indexes.

Audience

The intended audience for this course include Database administrators, System administrators, Network administrators, and Technical support professionals. Additionally, learners should have taken the first two parts of this series 64311 and 64312. Suggested prerequisites include Oracle SQL: Basic SELECT Statements (61110), Oracle SQL: Data Retrieval Techniques (61111), Oracle SQL: DML and DDL (61112), Oracle PL/SQL: PL/SQL Basics (61113), Oracle PL/SQL: Procedures, Functions, and Packages (61114), Oracle PL/SQL: Database Programming (61115).

Content Emphasis

Conceptual

Deployment Options

Accreditation

NASBA credits: 4 CPE Credits

Language Options

American English

Total Learning Time

6 to 8 hours

64313 Objectives

Unit 1: Storage Structures

1 - 2 hours
• Identify the correct order of the components in the storage hierarchy.
• Match the segment types with their features.
• Identify the factors that determine the order of precedence for controlling extent allocation.
• Coalesce free space in a given tablespace by using the Oracle SQL*Plus Worksheet.

Training Avaliability and Delivery

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

About 123-CBT Computer Based Training - Training Provider

More Oracle9i Training from 123-CBT Computer Based Training

• Oracle 9i New Features Backup Recovery Performance Tuning
• Oracle 9i New Features Database Administration
• Oracle9i Database Admin Create a Database
• Oracle9i Database Admin Manage an Instance
• Oracle9i Database Admin Manage Data Storage
• Oracle9i Database Admin Manage Security
• Oracle9i Database Admin Perform Database Backups
• Oracle9i Database Admin Recover Databases
• Oracle9i Database Admin Set Up Oracle Net Services
• Oracle9i Database Fundamentals I Curriculum
• Oracle9i Database Fundamentals II Curriculum
• Oracle9i Database Performance Tuning Curriculum
• Oracle9i Peformance Tuning Managing Memory and Disk I O
• Oracle9i Performance Tuning Architecture Strategy
• Oracle9i Performance Tuning Optimizing Sorts Minimizing Contention
• Oracle9i SQL Basic SELECT Statements
• Oracle9i SQL Curriculum
• Oracle9i SQL Data Retrieval Techniques
• Oracle9i SQL DML and DDL