Oracle Database 12c: Administration Workshop

Suggested Prerequisite

• A working knowledge of SQL and PL/SQL packages is very helpful in the course.
• Basic knowledge of Linux operating system

Audience

• Data Warehouse Administrator
• Support Engineer
• Database Administrators
• Database Designers
• Technical Administrator

Course Topics

Introduction

• Course Objectives
• Course Schedule
• Overview of Oracle Database 12c
• Overview of Oracle Cloud
• Overview of the HR Schema

Exploring the Oracle Database Architecture

• Oracle Database Architecture: Overview
• Oracle Database Instance Configurations
• Connecting to the Oracle Database Instance
• Oracle Database Memory Structures
• Process Architecture
• Process Structures
• Process Startup Sequence
• Database Storage Architecture

Managing the Database Instance

• Introducing Oracle Database Management Tools
• Understanding the Enterprise Manager Management Framework
• Logging in to Oracle Enterprise Manager Database Express
• Using the Enterprise Manager Database Express Home Page
• Using Enterprise Manager Cloud Control
• Using SQL*Plus
• Using SQL Developer
• Initialization Parameter Files

Configuring the Oracle Network Environment

• Oracle Net Services Overview
• Oracle Net Listener Overview
• Establishing Oracle Network Connections
• Tools for Configuring and Managing the Oracle Network
• Using the Listener Control Utility
• Using Oracle Net Configuration Assistant
• Using Oracle Net Manager
• Using Enterprise Manager Cloud Control

Managing Database Storage Structures

• Understanding Storage of Data
• Database Block Contents
• Exploring the Storage Structure
• Creating a New Tablespace
• Overview of Tablespaces Created by Default
• Managing Tablespaces
• Viewing Tablespace Information
• Using Oracle Managed Files

Administering User Security

• Database User Accounts
• Predefined Administrative Accounts
• Creating a User
• Authentication
• Unlocking a User Account and Resetting the Password
• Privileges
• Roles
• Profiles

Managing Data Concurrency

• Overview of Locks
• Locking Mechanism
• Data Concurrency
• DML Locks
• Enqueue Mechanism
• Lock Conflicts

Managing Undo Data

• Undo Data Overview
• Transactions and Undo Data
• Storing Undo Information
• Comparing Undo Data and Redo Data
• Managing Undo
• Configuring Undo Retention
• Guaranteeing Undo Retention
• Changing an Undo Tablespace to a Fixed Size

Implementing Oracle Database Auditing

• Separation of Responsibilities
• Database Security
• Monitoring for Compliance
• Standard Database Auditing
• Unified Audit Data Trail
• Separation for Duties for Audit Administration (AUDIT_ADMIN and AUDIT_VIEWER roles)
• Configuring the Audit trail
• Specifying Audit Options

Performing Database Maintenance

• Database Maintenance
• Viewing the Alert History
• Terminology
• Automatic Workload Repository (AWR)
• Statistic Levels
• Automatic Database Diagnostic Monitor (ADDM)
• Advisory Framework
• Enterprise Manager and Advisors

Managing Performance

• Performance Monitoring
• Tuning Activities
• Performance Planning
• Instance Tuning
• Performance Tuning Methodology
• Performance Tuning Data
• Monitoring Performance
• Managing Memory

Managing Performance: SQL Tuning

• SQL Tuning
• Oracle Optimizer
• SQL Plan Directives
• Adaptive Execution Plans
• SQL Advisors
• Automatic SQL Tuning Results
• Implement Automatic Tuning Recommendations
• SQL Tuning Advisor

Managing Resources by Using Database Resource Manager

• Database Resource Manager Overview
• Database Resource Manager Concepts
• Using the Resource Manager
• Default Maintenance Resource Manager Plan
• Default Plan Example
• Resource Manager Workflow
• Specifying Resource Plan Directives
• Resource Allocation Methods for Resource Plans

Automating Tasks by Using Oracle Scheduler

• Simplifying Management Tasks
• Understanding a Simple Job
• Core Components
• Basic Work Flow
• Persistent Lightweight Jobs
• Using a Time-Based or Event-Based Schedule
• Creating a Time-Based Job
• Creating an Event-Based Schedule

Managing Space

• Space Management Overview
• Block Space Management
• Row Chaining and Migration
• Free Space Management Within Segments
• Types of Segments
• Allocating Extents
• Allocating Space
• Creating Tables Without Segments

Backup and Recovery Concepts

• Categories of Failures
• Flashback Technology
• Understanding Instance Recovery
• Phases of Instance Recovery
• Tuning Instance Recovery
• Using the MTTR Advisor
• Media Failure
• Configuring for Recoverability

Moving Data

• Moving Data: General Architecture
• Oracle Data Pump
• SQL*Loader
• External Tables

Working with Oracle Support

• Using the Support Workbench
• Using Enterprise Manager
• Working with Oracle Support
• My Oracle Support Integration
• Researching an Issue
• Logging Service Requests
• Managing Patches
• Applying a Patch Release