Home > Training > Database Architecture & Admin. > Page 2

Oracle8i Database Architecture & Administration

Course Topics Contd... Page2

Creating a Database
Preparing the Operating System
Preparing the Parameter File
Creating a Database

Data Dictionary Views and Standard Packages
Constructing the Data Dictionary Views
Querying the Data Dictionary
Preparing the PL/SQL Environment Using the Administrative Scripts
Administering Stored Procedures and Packages
Listing the Types of Database Event Triggers

Maintaining the Control File
Explaining the Use of the Control File
Listing the Contents of the Control File
Multiplexing the Control File
Obtaining Control File Information

Maintaining Redo Log Files
Explaining the Use of Online Redo Log Files
Obtaining Log and Archive Information
Controlling Log Switches and Checkpoints
Multiplexing and Maintaining Online Redo Log Files
Planning Online Redo Log Files
Troubleshooting Common Redo Log File Problems
Analyzing Online and Archived Redo Logs

Managing Tablespaces and Data Files
Describing the Logical Structure of the Database
Distinguishing the Different Types of Temporary Segments
Creating Tablespaces
Changing the Size of Tablespaces
Allocating Space for Temporary Segments
Changing the Status of Tablespaces
Changing the Storage Settings of Tablespaces
Relocating Tablespaces

Storage Structure and Relationships
Describing the Logical Structure of the Database
Listing the Segment Types and Their Uses
Listing the Keywords that Control Block Space Usage
Obtaining Information About Storage Structures from the Data Dictionary
Listing the Criteria for Separating Segments

Managing Rollback Segments
Creating Rollback Segments Using Appropriate Storage Settings
Maintaining Rollback Segments
Planning the Number and Size of Rollback Segments
Obtaining Rollback Segment Information from the Data Dictionary
Troubleshooting Common Rollback Segment Problems

Managing Tables
Creating Tables Using Appropriate Storage Settings
Controlling the Space Used by Tables
Analyzing Tables to Check Integrity and Migration
Retrieving Information About Tables from the Data Dictionary
Converting Between Different Formats of ROWID

Back<<|Next >>