Oracle Database Administration Workshop Level 1

Software installation and database creation

• Prepare the machine for installation
• Install the Oracle Home
• Create a database with the DBCA
• Generate database creation scripts

Database and instance architecture

• Instance memory structures and background processes
• Database physical structures: datafiles, controlfile, online logfiles
• Session architecture: user processes 
• The Data Dictionary

Instance 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

Oracle Net

• Understand the client-server processing model
• Administer database listeners
• Configure Oracle Net clients
• Use database links

Physical storage structures

• Understand logical and physical structures
• Create tablespaces and datafiles
• Alter and drop tablespaces
• Resize and relocate datafiles

Space management

• Understand extent management
• Using compression
• Monitoring space usage
• Reclaiming space within a tablespace
• Enable resumable space allocation operations

Managing Users and Security

• Manage user accounts
• Grant and revoke privileges
• Create and grant roles
• Use password profiles

Undo management

• Executing SELECT and DML statements
• COMMIT and ROLLBACK processing
• Understand the purpose of undo data
• Administer undo data
• Configure undo retention

Locking and concurrency

• Multiuser issues
• Types of lock
• Automatic and manual locking
• Detect and solve lock contention

Audit

• Understand the need for audit
• Privileged user audit
• Standard audit
• Fine grained audit
• Configure unified audit
• Auditing with triggers

Monitoring and tuning

• Manage the Automatic Workload Repository
• Use the Automatic Database Diagnostic Monitor
• Use the Advisors
• Configure the alert system
• Control the autotasks

Memory 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

The Resource Manager

• Understand resource management
• Configure and monitor the Resource Manager
• Investigate the supplied Resource Manager plans
• Quiesce the database
• Use instance caging

The 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

Bulk data loading and extraction

• Use SQL*Loader
• Create directory objects
• Create external tables
• Use Data Pump export and import

SQL performance

•  Understand cost based optimization
• Manage optimizer statistics
• Display execution plans
• Use the SQL Tuning Advisor
• Use the SQL Access Advisor

Backup 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

Understanding 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