Oracle Database 12c: Administration Workshop Ed 2 NEW

Course Objectives

Course Schedule

Overview of Oracle Database 12c

Overview of Oracle Cloud

Overview of the HR Schema

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

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

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

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

Database User Accounts

Predefined Administrative Accounts

Creating a User

Authentication

Unlocking a User Account and Resetting the Password

Privileges

Roles

Profiles

Overview of Locks

Locking Mechanism

Data Concurrency

DML Locks

Enqueue Mechanism

Lock Conflicts

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

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 |

Database Maintenance

Viewing the Alert History

Terminology

Automatic Workload Repository (AWR)

Statistic Levels

Automatic Database Diagnostic Monitor (ADDM)

Advisory Framework

Enterprise Manager and Advisors

Performance Monitoring

Tuning Activities

Performance Planning

Instance Tuning

Performance Tuning Methodology

Performance Tuning Data

Monitoring Performance

Managing Memory

SQL Tuning

Oracle Optimizer

SQL Plan Directives

Adaptive Execution Plans

SQL Advisors

Automatic SQL Tuning Results

Implement Automatic Tuning Recommendations SQL Tuning Advisor

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

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

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

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: General Architecture

Oracle Data Pump

SQL*Loader

External Tables

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