Oracle Administration Training Overview
Accelebrate's live, private Oracle for Administrators course teaches attendees the skills and best practices required for successful day-to-day database administration. This course also covers Oracle instance and database architecture.
Location and Pricing
Accelebrate offers instructor-led enterprise training for groups of 3 or more online or at your site. Most Accelebrate classes can be flexibly scheduled for your group, including delivery in half-day segments across a week or set of weeks. To receive a customized proposal and price quote for private corporate training on-site or online, please contact us.
In addition, some courses are available as live, instructor-led training from one of our partners.
Objectives
- Incorporate security
- Create and manage users
- Manage space
- Administer undo and redo
- Run utilities
- Configure Oracle networking
- Perform simple backup and recovery techniques
Prerequisites
No prior experience is presumed.
Outline
Expand All | Collapse All
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
Conclusion
Training Materials
All students receive comprehensive courseware and a related textbook.
Software Requirements
- Windows or Linux with at least 8GB RAM
- A complete installation of a modern instance of Oracle
- Please contact us for detailed setup instructions if you have purchased this class
