Course Overview
This course provides students with the skills necessary to create and administer an Oracle database.
In this class they will concentrate on the skills and best practices required for day-to-day database administration tasks such as security, creating and managing users, space management, administering undo and redo, running utilities, configuring Oracle networking, and simple backup and recovery techniques. An in-depth discussion of Oracle instance and database architecture is also provided. The final three topics are optional for this course, as they are covered in real detail elsewhere in the curriculum. However, if time permits and students are interested, they may be covered to a certain extent.
The course is run on the current release of the database, but the instructors will “back-port” the course to earlier releases where behavior has significantly changed and it is relevant to the students.
Curriculum
- 1 Section
- 18 Lessons
- 2 Days
- Topics18
- 1.1Software installation and database creation Prepare the machine for installation Install the Oracle Home Create a database with the DBCA Generate database creation scripts
- 1.2Database and instance architecture Instance memory structures and background processes Database physical structures: datafiles, controlfile, online logfiles Session architecture: user processes The Data Dictionary
- 1.3Instance management Instance parameters SPFILEs and PFILEs Instance startup and shutdown Database mount, open, and close The administration roles and privileged users Operating system and password file privileged user authentication Data dictionary views and dynamic performance views The alert log and trace files
- 1.4Oracle Net Understand the client-server processing model Administer database listeners Configure Oracle Net clients Use database links
- 1.5Physical storage structures Understand logical and physical structures Create tablespaces and datafiles Alter and drop tablespaces Resize and relocate datafiles
- 1.6Space management Understand extent management Using compression Monitoring space usage Reclaiming space within a tablespace Enable resumable space allocation operations
- 1.7Managing Users and Security Manage user accounts Grant and revoke privileges Create and grant roles Use password profiles
- 1.8Undo management Executing SELECT and DML statements COMMIT and ROLLBACK processing Understand the purpose of undo data Administer undo data Configure undo retention
- 1.9Locking and concurrency Multiuser issues Types of lock Automatic and manual locking Detect and solve lock contention
- 1.10Audit Understand the need for audit Privileged user audit Standard audit Fine grained audit Configure unified audit Auditing with triggers
- 1.11Monitoring and tuning Manage the Automatic Workload Repository Use the Automatic Database Diagnostic Monitor Use the Advisors Configure the alert system Control the autotasks
- 1.12Memory management Understand how memory is used in an Oracle instance Manage SGA and PGA structures individually Enable Automatic Shared Memory Management Enable Automatic Memory Management Use the memory advisors
- 1.13The Resource Manager Understand resource management Configure and monitor the Resource Manager Investigate the supplied Resource Manager plans Quiesce the database Use instance caging
- 1.14The Job Scheduler Run local jobs through the Scheduler Launch jobs on remote systems Use job chains to run a series of tasks Assign priorities to jobs Use windows to enable Resource Manager plans
- 1.15Bulk data loading and extraction Use SQL*Loader Create directory objects Create external tables Use Data Pump export and import
- 1.16SQL performance Understand cost based optimization Manage optimizer statistics Display execution plans Use the SQL Tuning Advisor Use the SQL Access Advisor
- 1.17Backup and recovery Understand instance recovery Define a Fast Recovery Area Configure the database for recoverability Use the RMAN recovery manager for backup, restore, and recovery
- 1.18Understanding and Managing Multitenant Architecture (CDB) The motivation for use of the multitenant option Multitenant architecture Space management and multitenant Security in a multitenant database Migration to multitenant
Instructor
