Tel: 01423 534630 • Email: info@tts-uk.com
This Oracle Database 18c Administration course is designed to give the Oracle database administrator practical experience in administering, monitoring, tuning and troubleshooting an Oracle database.
A database administrator will gain an understanding of the architecture and processes of the Oracle database server. The delegate will learn how to ensure the integrity and availability of a company’s data within the Oracle environment. The delegate will also learn how to monitor the performance of a database, allocate resources with the Resource Manager and schedule jobs with the Oracle Job scheduler.
Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.
Versions supported 12cR2, 18c, 19c.
This course aims to provide the delegate with the knowledge required to maintain successful and efficient day-to-day operations of an Oracle database. The delegate will gain practical experience in administering and monitoring an Oracle database.
This Oracle Database 18c Administration course is for anyone who needs to administer, monitor and support an Oracle database.
The delegate will learn and acquire skills as follows:
Administering an Oracle Database Instance
Monitoring an Oracle Database
Configuring the Oracle Network Environment
Creating and Managing Database Storage Structures
Managing Users, Profiles, Privileges and Roles
Managing Undo Data and Temporary Segments
Monitoring and Resolving Lock Conflicts
Maintaining Database Security
Implementing Database Auditing
Monitoring the Performance of the Database
Loading and Unloading Data
Using the Job Scheduler
Configuring a Database for Backup and Recovery
Delegates who wish to attend the Oracle Database 18c Administration course should have an understanding of relational database concepts and good operating system knowledge. They should have attended the Oracle SQL course or have a good working knowledge of Oracle SQL. The ability to describe and use Oracle built-in PL/SQL packages would be highly advantageous but is not essential.
This course is run on a Linux operating system, a basic knowledge of Linux/UNIX is recommended but is not essential.
This course will aid the delegate in their preparation for the following exam:
Oracle Database Administration I: 1Z0-082
Attending this course together with the Oracle SQL Fundamentals course will help delegates gain many of the skills and product knowledge requirements as outlined in the exam objectives. Studying this course and its associated reference materials can form part of the preparation to achieve certification. Experience, practice, self-study and aptitude are also key requirements for exam success.
Before taking any exam, ensure you have the recommended experience. The Oracle website lists all exam requirements and these are updated regularly.
Exams are not included as part of the course.
Administration and Course Materials
Course Structure and Agenda
Delegate and Trainer Introductions
Overview of the Oracle database
Overview of the Oracle Cloud
Relational database concepts
Database administration tasks
Overview of the Oracle database architecture
The Oracle database instance
Oracle Database memory structures
Process architecture and structures
Server and client processes
The Oracle database storage architecture
Connect to the Oracle database instance
Administrative tools available to a DBA
Use SQL*Plus in Oracle to manage a database instance
Use SQL Developer to manage a database instance
Administer the database using Enterprise Manager (EM)
Overview of the Enterprise Manager framework
Access Enterprise Manager Database Express
The Enterprise Manager Database Express Home Page
Enterprise Manager Cloud Control
Initialization parameter files
Overview of network configuration
Oracle Net Listener configuration and management
Oracle Net naming methods
Tools for configuring and managing the Oracle network
Using the Net Configuration Assistant
Configure client connections with Net Manager
View listener configuration
Start and stop the Oracle listener
Use TNSPING to test Oracle Net connectivity
Connect to the database
Configure Net Services with Enterprise Manager
Overview of data storage
The database block
Overview of tablespaces and datafiles
Use Enterprise Manager to view the storage structure of the database
Create and alter tablespace commands
Temporary tablespaces
Create and manage datafiles
Use OMF
Drop tablespaces and datafiles
Predefined database administration accounts
User accounts
Create a user account
User authentication
Change a user’s password
Manage a user account
Drop a user account
Monitor user information
Terminate user sessions
Create a Schema Only Account
Database access
Oracle supplied roles
System and object level privileges
The grant and revoke commands
Create, modify and drop roles
Use predefined roles
Overview of user profiles
Profile resource parameters
Create profile command
Manage passwords with profiles
Control resource usage with profiles
Maintain profiles
Overview of database security
Overview of database auditing
Security compliance
Standard auditing
Unified audit trail
Separation of audit responsibilities with the AUDIT_ADMIN and AUDIT_VIEWER roles
Configure the audit trail
Specify audit options
Levels of locking in Oracle
Methods used to acquire locks
Data concurrency
Possible causes of contention
DML locks
Prevent locking problems
Detect lock contention
Resolve conflicts
Undo data overview
Monitor and administer undo
Configure undo retention
Switch undo tablespaces
Specify the retention period
Guarantee undo retention
Retention period for flashback queries
View undo space information
Use the undo advisor
Size the undo tablespace
Alter an undo tablespace to a fixed size
Oracle backup solutions
Oracle suggested backup strategy
Overview of database backup, restore and recover
Flashback technology
Types of failure
Instance recovery
Tune instance recovery
The MTTR Advisor
Media failure
Configure a database for recoverability
Database Maintenance
View the alert log
The Automatic Workload Repository
Statistic levels
The Automatic Database Diagnostic Monitoring
Monitor an Oracle database
Use the Advisors
Set up notification rules
Tuning information sources
Performance monitoring
Tuning activities
Performance planning
Instance tuning
Performance tuning methodology
Performance tuning data
Monitoring performance
Managing memory
Manage Private Temporary Tables
SQL tuning
Cancel a SQL Statement in a Session
The Oracle Optimizer
SQL Plan directives
Adaptive execution plans
SQL Advisors
Automatic SQL Tuning results
Implement automatic tuning recommendations
SQL Tuning Advisor
Create directory objects
Data Pump architecture
Data Pump data dictionary views
Data Pump interactive mode
Data Pump API
Use Data Pump to export data
Use Data Pump to import data
Overview of SQL Loader
Command line parameters
Record filtering
Control file keywords
Datafiles
SQL Loader data paths
External Tables
Overview of the Database Resource Manager
Use the Resource Manager
Create Resource Plans
The default maintenance resource manager plan
Create Resource Plan Directives
Allocate resources for Resource Plans
Introduction to the Scheduler
Access Rights
Scheduler components and workflow
Create a Job
Job Classes
Use time based, event based schedules
Create an event based schedule
Overview of space management
Block space management within segments
Segment types
Allocate extents
Allocate space
Row chaining and migration
Create tables without segments
The Enterprise Manager Support Workbench
Register for security updates
Work with Oracle Support
My Oracle Support integration
Log Service Requests
Manage patches
Apply a patch