|
Provided by: Serebra Learning Corporation Oracle 8i DBA - Oracle Storage ArchitectureOracle8i |
 |
This course is designed to give an Oracle DBA the necessary knowledge and skills to manage data storage. It will provide detailed information about logical structures such as tablespaces segments extents and Oracle data blocks. The creation and management of rollback segments will also be covered. The course also provides a list of data dictionary views that help in managing these logical structures. The course initiates you the learner into hands-on learning by helping you the learner to type-in the commands to perform administrative tasks. Related Exam: Oracle Exam #1Z0-023: Oracle 8i: Architecture and Administration.
|
|
||||||||||
Audience
This course is designed for database administrators application developers business and systems analysts MIS managers and technical support professionals and ordinary Oracle users. It will prepare students for the Oracle8i: Architecture and Administration Exam.
Prerequisites
The audience should be familiar with RDBMS concepts Graphical User Interfaces (GUIs) SQL and basics of PL/SQL.
Objective
Upon completion of this course the student will be able to:
Topics Include
Unit 1: Tablespaces
- Database Storage Hierarchy
- An Overview of Tablespaces
- Creating Tablespaces
- Altering Tablespaces
Unit 2: Datafiles
- Automatically Resizing Tablespaces
- Manually Resizing Tablespaces
- Moving Datafiles
- Maintaining Tablespaces Guidelines
Unit 3: Logical Structures
- Introduction to Segments
- Extent Allocation
- Data Blocks
- Storage Structures Information
- Planning Segment Allocation
Unit 4: Rollback Segment Concepts
- An Overview of Rollback Segments
- Allocating Rollback Segments
- Planning Rollback Segments
Unit 5: Working with Rollback Segments
- Creating Rollback Segments
- Modifying Rollback Segments
- Changing the Status of Rollback Segments
- Obtaining Information About Rollback Segments
- Troubleshooting Rollback Segments
Duration
5 Hours
Minimum Requirements
IBM-compatible PC with 166 MHz or higher processor 32 MB RAM (64 MB RAM recommended); 800x600 SVGA color monitor with 16-bit high color display; Internet Explorer 4 or Netscape Navigator 4 or later with Shockwave 7.0.1; Windows 95 Windows 98 Windows NT; 3.5 diskette (for tracking); 28.8 kbps connection or higher for on-line use.
Media
CDROM
Web Based Training
Serebra Learning Corporation 119 - 7565 132nd Street Surrey BC V3W 1K5 Canada
