±³À°¸í | °í±Þ Exadata and Database Machine Administration Workshop (ExadataÀÇ ±¸Á¶¿Í ÁÖ¿ä ±â´É) 11Â÷ |
---|---|
±³À°±â°£ | 2018-10-15 ~ 2018-10-19 |
±³À°½Ã°£ | 30 ½Ã°£ |
±³À°Àå | ¿µ¿ì±Û·Î¹ú·¯´× Áöµµº¸±â |
°»ç | ¿À¶óŬ°øÀΰ»ç |
Á¤¿ø | 20¸í |
±³À°ºñ | 3,005,000¿ø (VATº°µµ) |
¡à Benefits to You
Exadata µ¥ÀÌÅͺ£À̽º ½Ã½ºÅÛÀÇ È¿À²¼º°ú È¿À²¼ºÀ» ±Ø´ëÈÇÕ´Ï´Ù. º» ÄÚ½º¿¡¼ ÇнÀÇÑ ¸ð¹ü »ç·Ê ±¸Çö¿¡ ´ëÇÑ ÀÌÇØµµ¸¦ ³ôÀÔ´Ï´Ù.
¡à Course Topics
¡Û Introduction
- Course Objectives
- Audience and Prerequisites
- Course Contents
- Terminology
- Additional Resources
- Introducing the Laboratory Environment
¡Û Exadata Database Machine Overview
- Introducing Database Machine
- Introducing Exadata Storage Server
- Exadata Storage Server Architecture: Overview
- Exadata Storage Server Features: Overview
- Exadata Storage Expansion Racks
- InfiniBand Network
- Database Machine Support: Overview
¡Û Exadata Database Machine Architecture
- Database Machine Architecture: Overview
- Database Machine Network Architecture
- InfiniBand Network Architecture
- InfiniBand Network Topology
- Interconnecting Multiple Racks
- Database Machine Software Architecture: Overview
- Disk Storage Entities and Relationships
¡Û Key Capabilities of Exadata Database Machine
- Classic Database I/O and SQL Processing Model
- Exadata Smart Scan Model
- Exadata Smart Storage Capabilities
- Exadata Hybrid Columnar Compression
- Exadata Smart Flash Cache
- Exadata Storage Index
- Database File System
- I/O Resource Management
¡Û Exadata Database Machine Initial Configuration
- Database Machine Implementation: Overview
- Database Machine Site Preparation
- Using Oracle Exadata Deployment Assistant
- Choosing the Right Disk Redundancy Setting
- Configuring Oracle Exadata Database Machine
- The Result After Installation and Configuration
- Supported Additional Configuration Activities
¡Û Exadata Storage Server Configuration
- Exadata Storage Server Administration: Overview
- Testing Storage Server Performance Using CALIBRATE
- Configuring the Exadata Cell Server Software
- Starting and Stopping Exadata Cell Server Software
- Configuring Cell Disks and Grid Disks
- Configuring ASM and Database Instances to Access Exadata Cells
- Reconfiguring Exadata Storage
- Exadata Storage Security Implementation
¡Û I/O Resource Management
- I/O Resource Management Concepts
- IORM Architecture
- Getting Started with IORM
- Enabling Intradatabase Resource Management
- Setting Database I/O Utilization Limits
- Interdatabase Plans and Database Roles
- Using Database I/O Metrics
- IORM and Exadata Storage Server Flash Memory
¡Û Recommendations for Optimizing Database Performance
- Flash Memory Usage
- Influencing Caching Priorities
- Choosing the Flash Cache Mode
- Compression Usage
- Index Usage
- ASM Allocation Unit Size
- Minimum Extent Size
- Exadata Specific System Statistics
¡Û Using Smart Scan
- Exadata Smart Scan: Overview
- Smart Scan Requirements
- Monitoring Smart Scan in SQL Execution Plans
- Smart Scan Join Processing with Bloom Filters
- Other Situations Affecting Smart Scan
- Exadata Storage Server Statistics: Overview
- Exadata Storage Server Wait Events: Overview
¡Û Consolidation Options and Recommendation
- Consolidation: Overview
- Different Consolidation Types
- Recommended Storage Configuration for Consolidation
- Alternative Storage Configurations
- Cluster Configuration Options
- Isolating Management Roles
- Schema Consolidation Recommendations
- Maintenance Considerations
¡Û 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
¡Û 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
¡Û 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
- Enterprise Manager Database Control
¡Û Configuring Enterprise Manager Cloud Control 12c to Monitor Exadata Database Machine
- Enterprise Manager Cloud Control 12c Architecture: Overview
- Cloud Control Monitoring Architecture for Exadata Database Machine
- Configuring Cloud Control to Monitor Exadata Database Machine
- Pre-discovery Configuration and Verification
- Deploying the Oracle Management Agent
- Discovering Exadata Database Machine
- Discovering Additional Targets
- Post-discovery Configuration and Verification
¡Û Monitoring Exadata Storage Servers
- Exadata Metrics and Alerts Architecture
- Monitoring Exadata Storage Server with Metrics and Alerts
- solating Faults with
- Monitoring Exadata Storage Server with Enterprise Manager: Overview
- Monitoring Hardware Failure and Sensor State
- Monitoring Exadata Storage Server Availability
- Comparing Metrics Across Multiple Storage Servers
¡Û Monitoring Exadata Database Machine Database Servers
- Monitoring Database Servers: Overview
- Monitoring Hardware
- Monitoring the Operating System
- Monitoring Oracle Grid Infrastructure
- Monitoring Oracle Database
- Monitoring Oracle Management Agent
- Database Monitoring with Enterprise Manager Cloud Control 12c
¡Û Monitoring the InfiniBand Network
- InfiniBand Network Monitoring: Overview
- InfiniBand Network Monitoring with
- Monitoring the InfiniBand Switches
- Monitoring the InfiniBand Switch Ports
- Monitoring the InfiniBand Ports
- Monitoring the InfiniBand Fabric:
- Monitoring the InfiniBand Fabric:
¡Û Monitoring Other Exadata Database Machine Components
- Monitoring the Cisco Ethernet Switch
- Monitoring the Sun Power Distribution Units
- Monitoring the KVM Switch
¡Û Other Useful Monitoring Tools
- Exachk: Overview
- Running Exachk
- Exachk Daemon
- DiagTools: Overview
- Using ADRCI on Exadata Storage Servers
- Imageinfo: Overview
- Imagehistory: Overview
- OSWatcher: Overview
¡Û Backup and Recovery
- Using RMAN with Database Machine
- General Recommendations for RMAN
- Disk-Based Backup Strategy
- Disk-Based Backup Recommendations
- Disk-Based Backup on
- Tape-Based Backup Strategy
- Tape-Based Backup Architecture and Recommendations
- Backup and Recovery of Database Machine Software
¡Û Exadata Database Machine Maintenance Tasks
- Database Machine Maintenance: Overview
- Powering Database Machine Off and On
- Safely Shutting Down a Single Exadata Storage Server
- Replacing a Damaged Physical Disk
- Replacing a Damaged Flash Card
- Moving All Disks from One Cell to Another
- Using the Exadata Cell Software Rescue Procedure
¡Û Exadata Database Machine: Patching, Automated Support Ecosystem & Cloud Service Overview
- Introducing Exadata Cloud Service
- Service Configuration Options & Service Connection Options
- Service Architecture & Availability
- Management Responsibilities
- Storage Configuration & Management Details
- Simple Web-Based Provisioning & Management
- REST APIs
- Migrating to Exadata Cloud Service
ÇпøÀÇ ¼³¸³¤ý¿î¿µ ¹× °ú¿Ü±³½À¿¡ °üÇÑ ¹ý·ü ½ÃÇà·É¿¡ µû¶ó ´ÙÀ½°ú °°ÀÌ ¼ö°·á¸¦ ȯºÒÇØµå¸³´Ï´Ù.