Oracle Rdb DBA: Care & Feeding of Production Databases
Length: 5 days
Oracle Rdb databases are robust, but do require care and attention, particularly when the database plays a key role in a mission critical application.
However, often the Database Administrator is also the DBA for other database products, or even a systems manager. This seminar is designed to meet your needs with in-depth information and experience.
The seminar contains the following modules:
DBA Responsibilities This seminar is organized around the various responsibilities of a Database Administrator (DBA). The first module examines these responsibilities.
High Availability Databases Database Backup, Restore, and Recover are among the most important of the DBA tasks. They make it possible to assure the user community that the data in the database will be preserved, despite system and applications failure, and that data access paths to the database will be available when needed. In this section, you will learn how to use the Rdb tools that make this possible.
Rdb supports After Image Journaling (sometimes known as transaction logging), database and AIJ backups, and database restores and recoveries.
Using Hot Standby, Rdb supports the ability to create and maintain a standby copy of the database that is up to date, as of the last committed transaction.
High Performance Databases Monitoring performance with RMU/Show Statistics and RMU/Analyze shows where tuning may be required. This section teaches you how to develop system and database monitoring procedures for the database application.
You will learn to tune memory with local buffers, global buffers, and row caches.
Creating a Database This section includes a complete discussion of the SQL necessary to create a database. Topics include domains and data types, tables, constraints and triggers, sorted index definitions, and other performance enhancing mechanisms. You will learn how to develop a physical database design oriented toward minimal system requirements. With this knowledge you will be able to create a fully functional database.
Planning many database applications grow over time. They increase both in the amount of data being manipulated as well as in the number of accesses made to that data, both over time and concurrently. Collecting the information necessary to develop the planning functions can be accomplished, often in concert with other activities. In this section, you will learn how to plan for the resources needed for application growth and upgrades, such as: disk and tape storage, I/O requirements, processor and memory requirements, evolution of the database, programming updates to the application, and updates to the database and operating system software.
Keith W. Hare, President