> > > D78846DE10 Detailed outline

Oracle Database 12c: Administration Workshop (D78846DE10)

Course Description Schedule Course Outline

Detailed Course Outline

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
 

Accessing our website tells us you are happy to receive all our cookies. However you can change your cookie settings at any time. Find out more.   Got it!