Online Training Oracle Applications

Course	Oracle Exadata	Time converter at worldtimebuddy.com
Cost Of The Training	INR: 10,000
Total Duration	2 Weeks
Each Session	---
Trainer	---
Start Date And Time	---

Course Description

1.	Exadata Database Machine Initial Configuration
	Database Machine Implementation: Overview
	Pre-Installation
	Installation
	Additional Configuration
	Post Installation
	Using Oracle Exadata Deployment Assistant (OEDA)
	DBM Hardware Installation: Overview
	OneCommand Process overview
	Supported Additional Configuration Activities
	Unsupported Configuration Activities
2.	Powering Database Machine ON/OFF
	Powering Database Machine On
	Powering Database Machine Off
	Shutting Down a Single Exadata Storage Server
	Starting a Single Exadata Storage Server
3.	Exadata Storage Server (Cell) Administration
	Exadata Storage Server Administration: Overview
	Configuring DB Servers to access Exadata Cells
	Configuring ASM and Database Instances to Access Exadata Cells
	Configuring Cell Server to send E-mail notifications
	Starting/Stopping Cell Services
	Configuring DCLI utility on Cell nodes & DB nodes
	Adding Physical Disks & Flash Disks to the Cell Server
	Creating Hard Disk & Flash Disk based Cell Disks
	Creating Grid Disks based on Hard Disks & Flash Disks
	Creating ASM Diskgroups using Grid Disks based on Hard Disks & Flash Disks
	Testing Automatic Exadata Storage Management Features
	Reconfiguring Flash Storage
	Dropping Flash Cache & Flash Log
	Recreating Flash Cache & Flash Log
	Online Reconfiguration of Exadata Storage
	Recommended Storage Configuration for Consolidation
	Alternative Storage Configurations
4.	Exadata Smart Flash Cache & Flash Log
	Use of Flash Storage in Exadata
	Overview of Exadata Smart Flash Cache & Flash Log
	Overview of Intelligent Caching
	Influencing the Caching decisions
	Write-Through Flash Cache mode
	Write-Back Flash Cache mode
	Observing the Cached Objects
5.	Exadata Smart Scan / Offloading
	Overview of Exadata Smart Scan feature
	Traditional I/O and SQL Processing
	Exadata Smart Scan processing
	Smart Scan Requirements
	Smart Scan disablers
	Observing Smart Scan operations in Query Execution Plans
	Statistics & Wait Events related to Smart Scan
	Other Smart Scan Optimizations
	Compression/Decompression
	Encryption/Decryption
	Virtual Columns
	Other Non-Smart Scan Optimizations
	Smart/Fast File creation
	RMAN Incremental Backup
	RMAN Backup Restores
6.	Exadata Hybrid Columnar Compression
	Compression Methods in Oracle
	Basic Compression, OLTP compression
	Exadata Hybrid Columnar Compression (EHCC)
	Data organization using EHCC
	Compression Unit
	EHCC Types
	Warehouse Compression
	Archival Compression
	Enabling EHCC
	DMLs on EHCC Tables
	Comparing different Compression Methods
7.	Exadata Storage Indexes
	Overview of Exadata Storage Indexes
	Conceptual view of Storage Indexes
	Requirements for Storage Indexes
	Statistics related to Storage Indexes
8.	Exadata I/O Resource Management (IORM)
	I/O Resource Management Concepts
	IORM Architecture
	Intradatabase Vs Interdatabase plans
	Setting IORM objective
	Implementing Intradatabase plans (DB Plans)
	Implementing Interdatabase Plans (IORM Plans)
	DB Plans, Category Plans
	Using Database I/O Metrics
	IORM and Exadata Storage Server Flash Memory
9.	Exadata Database Machine Platform Monitoring Introduction
	Monitoring Technologies and Standards
	Simple Network Management Protocol (SNMP)
	Intelligent Platform Management Interface (IPMI)
	Integrated Lights Out Manager (ILOM)
	Exadata Storage Server Metrics, Thresholds, and Alerts
	Automatic Diagnostic Repository (ADR)
	Enterprise Manager Cloud Control 12c
10.	Monitoring Exadata Storage Servers
	Exadata Metrics and Alerts Architecture
	Monitoring Exadata Storage Server with Metrics and Alerts
	Listing Metric definition and current metrics
	Listing Alert history, Active Requests
	Listing & Setting thresholds
11.	Other Useful Monitoring Tools
	Exachk: Overview
	Running Exachk
	Exachk Daemon
	DiagTools: Overview
	Using ADRCI on Exadata Storage Servers
	Imageinfo: Overview
	Image history: Overview
	OSWatcher: Overview
12.	Exadata Database Machine Backup and Recovery
	DBM Backup & Recovery Overview
	Backup of Software on DB nodes
	Recovering DB nodes using LVM snapshot based Backups
	Reimaging a DB node
	Overview Cell Backup
	Understanding Cell Disk Layout
	Cell System Volumes
	Creating Cell Rescue Image using External USB
	Recovering Storage Server
	Cell Rescue Procedure
	Reimaging Cell Server
	Using RMAN to perform Database backups on DBM
	Understanding Read I/O optimizations provided by Exadata for RMAN incremental backups
	Understanding Recovery Optimizations provided by Exadata for RMAN
	General Recommendations for RMAN
	Disk-Based Backup Strategy
	Disk-Based Backup Recommendations
	Disk-Based Backup on non-exadata storage
	Tape-Based Backup Strategy
	Tape-Based Backup Architecture and Recommendations
13.	Patching & Updating Exadata Database Machine
	Patching and Updating: Overview
	Rolling Vs Non-Rolling Methods
	Maintaining Database Server Software
	Bundle Patches, QDPE, QFSDP
	Assisted Patching Using OPlan
	Maintaining Exadata Storage Server Software
	Understanding Internals of Storage Server Patching
	Maintaining Firmware/Software on Other Components of DBM
	Recommended Patching Process
	Test System Recommendations
	Understanding Application Downtime requirements for various Patching activities on DBM
14.	Migrating Databases to Exadata Database Machine
	Migration Best Practices: Overview
	Performing Capacity Planning
	Database Machine Migration Considerations
	Choosing the Right Migration Path
	Logical Migration Approaches
	Physical Migration Approaches
	Post-Migration Best Practices
	Migrating to Database Machine Using Transportable Tablespaces
15.	Bulk Data Loading using Oracle DBFS
	Bulk Data Loading Using Oracle DBFS: Overview
	Preparing the Data Files
	Staging the Data Files
	Configuring the Staging Area
	Configuring the Target Database
	Loading the Target Database
16.	Exadata Database Machine Maintenance Tasks
	Database Machine Maintenance: Overview
	Replacing a Damaged Physical Disk
	Replacing a Damaged Flash Card
	Moving All Disks from One Cell to Another
17.	Exadata Storage Security
	Overview of Exadata Storage Security
	Exadata Storage Open Security
	Overview of ASM Scoped Security
	Overview of Database Scoped Security
	Implementing ASM Scoped Security
	Implementing Database Scoped Security

	Thank You

Course Description