JCC Seminar Description

This seminar will introduce participants to Oracle Rdb data structures, internal algorithms and implementation details. Participants will use Oracle Rdb utilities to examine locks, analyze the database and its structures, identify key components of Oracle Rdb bugcheck dumps and understand database recovery mechanisms.

Audience
Technical Support Professionals
System Administrators
Network Administrators
Database Administrators

Prerequisites

• Six months experience in advanced Oracle Rdb administration
• Four previous JCC seminars on Rdb database administration and query tuning or the equivalent

Topics

• Oracle Rdb Overview
• Discuss images, files and processes
• Outline DSRI components
• Develop an understanding of dispatch functionality
• Examine the Engine
• Compile the request
• Describe static optimization
• Understand how Oracle Rdb uses query outlines
• Execute the request
• Detail dynamic optimization
• Utilize record versioning for online metadata updates
• Target page selection
• Discuss Locking
• Review locking concepts
• Observe how object manager locks key database structures
• View lock structures
• Determine when to use adjustable lock granularity
• Examine On-Disk Structures and Algorithms
• View on-disk root structures
• Describe and display page and index structures
• Study snapshots and read-only transactions
• Discuss how Oracle Rdb manages pages and buffers
• Describe Environment and Integrity
• Detail the steps Oracle Rdb follows to access the database and start a transaction
• Discuss how Oracle Rdb performs after-image and recovery unit journaling
• Specify Oracle Rdb monitor responsibilities