Oracle9i Database: Data Types and Storage Internals

Have you ever wondered how Oracle stores its data? Have you ever contacted Oracle Support Services, but wished you had the knowledge to answer your own questions? After completing this course, attendees will gain in-depth knowledge of the internal storage of Oracle9i data types that are used in defining database structures. The implementation and internal structure of large objects, collections, and user-defined data types will be discussed.

Understanding the internal storage components of Oracle9i block structures such as data, index, and cluster blocks, and undo segment blocks will provide you with significant insight into the functioning of the Oracle server, and thereby minimize support calls and turnaround time for resolving problems. This seminar is a must for every experienced Oracle database administrator.

A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

Audience

• Database Administrators

Course Topics Implementation of Built-In Data Types

• Storage of Internal Knowledge
• Oracle and Built-In Data Types
• Date-time and Interval Data Types
• CHAR and VARCHAR2
• NUMBER
• LONG, RAW, and LONG RAW
• DATE and TIMESTAMP

LOBs and User-Defined Data Types

• Large Objects Storage
• Large Objects: Locators
• Collections: VARRAY and Nested Tables
• User-Defined Data Types (UDTs)
• Object Table
• REFs
• REF Components

Block Space Management

• Oracle Data Blocks
• Transaction Layer Dump
• Data Layer Dump
• Row Data
• Row Migration, Chaining and Block Chaining
• Implications of Chaining and Migration
• Intra-Block Chaining
• Drop Column Versus Set Unused

Table and Partition Implementation

• Reasons for Partitioning
• Mapping Rows to Partitions
• Range and Hash Partitioning
• List Partitioning
• Query OBJ$
• Warehouse Builder Run Time
• Dependency Management and Scheduling
• Oracle Workflow and Life Cycle Management

Cluster Implementation

• Format of Clustered Data Blocks
• Cluster Key and Index
• Hash Clusters
• Hashing Versus Indexing
• Hash Key Values, Functions, and Cluster Space Allocation
• Single Table Hash Clusters
• A Single Table Hash Cluster Block Dump

Index Implementation

• Building and Rebuilding an Index Online
• B*-Tree and Bitmap Indexes
• Initialization Parameters for Bitmap Index
• Bitmap Join Index
• Index-Organized Tables
• Function-Based Indexes
• LOBs and LOB indexes
• Partitioned Indexes

Undo Segment Implementation

• Undo Segment Structures
• Establishing Undo Segments in different modes
• Transaction Identifiers
• Undo Block
• Transaction Undo Chain
• Undo Chain of the Transaction Table

Course Objectives

• Describe the internal storage of all Oracle data types
• Explain the implementation of large objects, collections, and user-defined data types
• Identify the internal components of data blocks, index, cluster, and undo blocks