| Rdb Internals |
This special 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 required:
 | Describe database recovery mechanisms and use RMU utilities to analyze database structure and integrity. |
| Six months experience in advanced Oracle Rdb administration |
| Introduction to Oracle Rdb: Technical Overview and SQL Language suggested |
| Rdb Performance and Tuning |
| Rdb for the Database Administrator |
Seminar Objectives
| Describe database recovery mechanisms and use RMU utilities to analyze database structure and integrity. |
| Identify key components of OracleRdb bugcheck dumps. |
Topics:
| Oracle Rdb Overview |
| Discuss images, files and processes on both OpenVMS and Digital Unix |
| 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 |
Seminar Presenter:
The instructor for this course will be Mark Bradley. Mark has a great combination of excellent presentation skills and thorough knowledge of the Rdb product. He is the author of the most recent revisions to this course.