Oracle Database Administration Workshop Level 1
Duration: 4 Days
![]() Oracle Certified Master John Watson John wrote the EXAM Guide! This course provides you with the skills necessary to create and administer an Oracle database. In this class you 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 database, but the instructors (OCM John Watson unless otherwise noted) will “back-port” the course to earlier releases where behavior has significantly changed and it is relevant to the students. Recent Review “…the instructor knew the material. He didn’t just read screens. He talked about the different points on the screen, show examples of when to use which options, and walked through the examples. He is very comfortable with the subject.” Please click on the “Reviews” tab above to see more online reviews! |
- Prepare the machine for installation
- Install the Oracle Home
- Create a database with the DBCA
- Generate database creation scripts
- Instance memory structures and background processes
- Database physical structures: datafiles, controlfile, online logfiles
- Session architecture: user processes
- The Data Dictionary
- 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
- Understand the client-server processing model
- Administer database listeners
- Configure Oracle Net clients
- Use database links
- Understand logical and physical structures
- Create tablespaces and datafiles
- Alter and drop tablespaces
- Resize and relocate datafiles
- Understand extent management
- Using compression
- Monitoring space usage
- Reclaiming space within a tablespace
- Enable resumable space allocation operations
- Manage user accounts
- Grant and revoke privileges
- Create and grant roles
- Use password profiles
- Executing SELECT and DML statements
- COMMIT and ROLLBACK processing
- Understand the purpose of undo data
- Administer undo data
- Configure undo retention
- Multiuser issues
- Types of lock
- Automatic and manual locking
- Detect and solve lock contention
- Understand the need for audit
- Privileged user audit
- Standard audit
- Fine grained audit
- Configure unified audit
- Auditing with triggers
- Manage the Automatic Workload Repository
- Use the Automatic Database Diagnostic Monitor
- Use the Advisors
- Configure the alert system
- Control the autotasks
- 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
- Understand resource management
- Configure and monitor the Resource Manager
- Investigate the supplied Resource Manager plans
- Quiesce the database
- Use instance caging
- 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
- Use SQL*Loader
- Create directory objects
- Create external tables
- Use Data Pump export and import
- Understand cost based optimization
- Manage optimizer statistics
- Display execution plans
- Use the SQL Tuning Advisor
- Use the SQL Access Advisor
- Understand instance recovery
- Define a Fast Recovery Area
- Configure the database for recoverability
- Use the RMAN recovery manager for backup, restore, and recovery
- The motivation for use of the multitenant option
- Multitenant architecture
- Space management and multitenant
- Security in a multitenant database
- Migration to multitenant