**NEW** Rdb V6.0 Internals Course Available in UK
Lilian Hobbs
Engineering in September in the UK. This is currently the only scheduled
European event.
To make a reservation call Oracle on:
In the UK: 0345 777 711
Outside UK: +44 1344 383 800
Dates for the other Rdb courses in the UK are also included in this
message.
Lilian Hobbs
Oracle Rdb Engineering
NEW COURSE: Oracle Rdb Internals V6
-----------------------------------
Oracle Rdb Internals V6 (RDBE) has been added to the Oracle Education
curriculum. This course gives experienced Rdb database administrators an
insight into the internal structures and mechanisms of Rdb, to aid them
in
maximising the performance and availability of their Rdb databases. It
will
also help them to resolve complex problems.
The full course synopsis is included in this message. The first run is
scheduled for Bracknell, 25th September. The price is 1050 pounds excl
VAT.
Oracle Education's other public scheduled Rdb courses Dates
----------------------------------------------------- -----
RDBA (5 days) Oracle Rdb for Application Programmers 11/9 ,
30/10
RDBB (4 days) Oracle Rdb Physical Database Design and 4/12
Implementation
RDBC (4 days) Oracle Rdb Administration 29/8,
13/11
RDBD (5 days) Oracle Rdb Database and Performance Tuning 14/8,
11/12
Course title: ORACLE RDB INTERNALS V6
---------------------------------------
Code: RDBE
Duration: 5 days
Synopsis Version: 1.0
OVERVIEW
This course will enable experienced Oracle Rdb database administrators or
support technicians to understand Oracle Rdb's internal implementation.
This will help them to maximize the performance and availability of their
database and participate in complex problem identification and
resolution. The course will also examine how to define and implement a
database maintenance and recovery strategy which best fits a given
application environment.
PREREQUISITES
Delegates should have the following skills :
* An understanding of VMS utilities and commands.
* The ability to use Oracle Rdb's RMU utility.
* Familiarity with the operation of the Oracle Rdb
strategy optimizer.
* An understanding of Oracle Rdb database structure.
* At least 6 months tuning, support, or advanced DBA experience.
OBJECTIVES
Upon successful completion of this course, delegates should be able to :
* Use Oracle Rdb utilities to view and and explain the various locks
and their use.
* Use the RMU utilities to analyze the database, its structure and
integrity.
* Use various tools provided by Oracle Rdb and OpenVMS to isolate
problems and determine behavior and potential corrective action.
* Describe the work the static and dynamic optimizer must do to
retrieve data.
* Look at an Oracle Rdb bugcheck dump and identify key structures used
by Oracle Rdb and their function, use, and impact.
* Describe concepts of various database recovery mechanisms.
COURSE CONTENTS:
* Architecture
- Components
- The DSRI (Database Standard Relational Interface)
- The dispatcher
* Relational Engine
- Request Compilation
- Static Optimization
- Code Generation
- Request execution
* Record Storage Subsystem
- On-disk structures
- Physical Storage Interface (PSI) layer
- Data I/O (DIO) layer
- Physical I/O (PIO) layer: local and global buffers,
asynchronous and synchronous I/Os
* Transactions
- Local transactions
- Distributed transactions
* Locking
- Locking Theory
- Distributed Lock Manager
- Specific Locks
* Database Integrity
- After-Image Journaling (fast commit, circular AIJ,
journal fail-over)
- Recovery-Unit Journaling
- Monitor
- Recovery Processes
* Troubleshooting
- Debugging logicals
- Database verification
- Repairing and altering databases
- Reading Bugchecks
PRESENTATION STYLE: This event is presented as a series of lectures with
demonstrations.
Dougall Squair
>Subject: **NEW** Rdb V6.0 Internals Course Available in UK
>Date: 14 Aug 1995 22:49:55 GMT
>The Rdb V6.0 Internals Course will be delivered by Phil Grice of Rdb
>Engineering in September in the UK. This is currently the only scheduled
>European event.
Any possiblity of getting hold of an updated Rdb/Internals reference manual
for version 6.0.
I have an old copy for Rdb 4.1 which I got after attending the Internals
course a few years ago.
Dougall
