Oracle Database 12c: OCM Exam Preparation Workshop (D94327) – Outline

Detailed Course Outline

Basics of Multitenant Container Database and Pluggable Databases
  • New Multitenant Architecture: Benefits
  • Multitenant Container Database
  • Separating SYSTEM and User Data
  • Provisioning a Pluggable Database
  • Interacting Within Multitenant Container Database
  • Multitenant Container Database Architecture
  • Common and Local Users
  • Common and Local Privileges and Roles
Managing Tablespaces and Users in CDB and PDBs
  • Tablespaces in PDBs
  • Creating Permanent Tablespaces in a CDB
  • Creating Local Temporary Tablespaces
  • Tablespace Encryption: Advantages
  • Creating an Encrypted Tablespace
  • Common and Local Schemas/Users
  • Granting and Revoking Privileges
  • Granting Common or Local Privileges/Roles to Roles
Basics of Parallel Execution
  • Parallelizable Operations
  • Previewing Execution Plans
  • Understanding Parallel Execution: Query Coordinator (QC) and Parallel (PX) Servers
  • Parallel Execution Plans: Identifying the Producers and Consumers
  • Parallel Execution Plans: Understanding Granules
  • Example PX Parameters
  • PX Parameters for Auto DOP
  • Parameters for PX Messaging: Shared and Large Pools
In-Memory Parallel Execution & Multi-Threaded architecture
  • Direct Reads Versus Buffer Cache Reads
  • Parallel Execution and the Buffer Cache
  • In-Memory Parallel Execution
  • When In-Memory Parallel Execution Works
  • Controlling In-Memory Parallel Execution
  • Enhance In-Memory PX Using Server Pools
  • Enhance In-Memory PX: Automatic Big Table Caching
  • Using PARALLEL_FORCE_LOCAL Parameter
Moving Data
  • Oracle Data Pump: Overview
  • Directory Objects for Data Pump
  • Data Pump Export and Import Clients: Overview
  • External Tables
  • Data Pump Import: Transformations
  • SQL*Loader: Overview
  • Loading Methods
  • Transportable Tablespaces
Working with Indexes
  • Normal B*-tree Indexes
  • Index Scans
  • Index Range Scan
  • Index Range Scan: Function-Based
  • Index Fast Full Scan
  • B*-tree Indexes and Nulls
  • Index-Organized Tables
  • Bitmap Indexes
Partitioning Concepts
  • Partitioned Tables and Indexes
  • Partitioning Strategies: Single-Level Partitioning
  • Oracle Partitioning History
  • Partition Key Extensions
  • Benefits of Partitioning: Table Availability
  • Manageability: Relocate Table Data
  • Benefits of Partitioning: Performance Considerations
  • Verifying Partition Use
Dataware House Tuning and Partitioning Workloads
  • Characteristics of a Data Warehouse
  • OLTP Systems Versus Data Warehouses
  • Data Warehouse Architectures: Basic Data Warehouse with Staging Area
  • Data Warehousing Objects
  • Optimizing Star Queries: Star Transformation
  • Execution Plan Without Star Transformation
  • Star Transformation Considerations
  • Retrieving Fact Rows from All Dimensions: Phase 1
Using Flashback Technologies
  • Flashback Technologies Error Detection and Correction
  • Flashback Technology
  • Guaranteeing Undo Retention
  • Flashback Query
  • Flashback Table: Overview
  • Flashback Table: Considerations
  • Flashback Transaction Query
  • Flashing Back a Transaction
Influencing the Optimizer
  • Functions of the Query Optimizer
  • Cardinality and Cost
  • Changing Optimizer Behavior
  • Optimizer Statistics
  • Optimizer Parameters
  • Enabling Query Optimizer Features
  • Dynamic Plans
  • Cardinality Feedback: Monitoring Query Executions
SQL Performance Management and SQL Data Compression
  • Maintaining SQL Performance
  • Maintaining Optimizer Statistics
  • Automated Maintenance Tasks
  • Setting Statistic Preferences
  • Restoring Statistics
  • Deferred Statistics Publishing: Example
  • Automatic SQL Tuning: Overview
  • Plan Tuning Flow and SQL Profile Creation
In-Memory Column Store
  • Goals of In-Memory Column Store
  • Store Versus Column Store: 2D Vision
  • In-Memory Column Unit
  • Dual Format In Memory
  • Deploying IM Column Store
  • Objects Candidates for IM Column Store
  • Defining IM Column Store Priority
  • Default In-Memory Setting
Introduction to Oracle Data Guard
  • What Is Oracle Data Guard?
  • Types of Standby Databases
  • Role Transitions: Switchover and Failover
  • Choosing an Interface for Administering a Data Guard Configuration
  • Primary Database Processes
  • Standby Database Processes
  • Physical Standby Database: Redo Apply Architecture
  • Automatic Gap Detection and Resolution
Using Oracle Active Data Guard
  • Using Real-Time Query
  • Disabling Real-Time Query
  • Checking the Standby’s Open Mode
  • Monitoring Apply Lag: V$DATAGUARD_STATS
  • Allowed Staleness of Standby Query Data
  • Setting STANDBY_MAX_DATA_DELAY by Using an AFTER LOGON Trigger
  • Forcing Redo Apply Synchronization
  • Creating an AFTER LOGON Trigger for Synchronization
Creating a Logical Standby Database
  • Benefits of Implementing a Logical Standby Database
  • Logical Standby Database: SQL Apply Architecture
  • Preparing to Create a Logical Standby Database
  • Unsupported Data Types
  • Checking for Tables with Unsupported Data Types
  • Unsupported PL/SQL-Supplied Packages
  • Adding a Disabled Primary Key RELY Constraint
  • Creating a Logical Standby Database by Using SQL Commands
Enabling Fast-Start Failover
  • When Does Fast-Start Failover Occur?
  • Installing the Observer Software
  • Fast-Start Failover Prerequisites
  • Configuring Fast-Start Failover
  • Step 1: Specify the Target Standby Database
  • Setting the Lag-Time Limit
  • Configuring the Primary Database to Shut Down Automatically
  • Configuring Automatic Reinstatement of the Primary Database
Introduction to Clusterware
  • Clusterware Architecture and Cluster Services
  • Goals for Oracle Clusterware
  • Oracle Clusterware Fencing
  • Cluster Time Synchronization
  • Oracle Clusterware Networking
  • Grid Naming Service (GNS)
  • Grid Naming Service Configuration Options
  • Single-Client Access Name
ASM Overview
  • What Is Oracle ASM?
  • ASM Features and Benefits
  • ASM Instance Designs: Clustered ASM for Clustered Databases
  • ASM Components: Software
  • ASM Components: ASM Instance Primary Processes
  • ASM Components: Configuration Files
  • ASM Disk Group: Failure Groups
  • ASM Files: Extents and Striping
Flex Clusters
  • Flex Clusters: Overview
  • Flex Cluster Scalability
  • Leaf Node Characteristics
  • Cluster Mode: Overview
  • Configuring the Cluster Mode
  • Configuring Miss Count for Leaf Nodes
  • Configuring a Flex Cluster with OUI: Configuring GNS
  • Configuring a Flex Cluster with OUI: Selecting the Node Type
Flex ASM
  • Flex ASM: Overview
  • ASM Instance Changes
  • Configuring Flex ASM on a Standard Cluster
  • Configuring Flex ASM on a Flex Cluster
  • Stopping, Starting, and Relocating Flex ASM Instances
  • Setting the Cardinality for Flex ASM Instances
  • Monitoring Flex ASM Connections
  • Relocating an ASM Client
RAC Databases Overview and Architecture
  • Typical Oracle RAC Architecture
  • Oracle RAC One Node
  • Cluster-Aware Storage Solutions
  • Oracle RAC and Network Connectivity
  • Clusters and Scalability
  • Levels of Scalability
  • Speedup/Scaleup and Workloads
  • Necessity of Global Resources
Upgrading and Patching Oracle RAC
  • Patch and Patch Set: Overview
  • Configuring the Software Library
  • Reduced Down-Time Patching for Cluster Environments
  • Out-of-Place Database Upgrades
  • OPatch: Overview
  • Before Patching with OPatch
  • OPatch Automation: Examples
  • OPatch Log and Trace Files