->
->1. Exadata Database Machine Overview
->Identify the benefits of using Database Machine for different application classes
->Describe the key capacity and performance specifications for Database Machine
->
->2. Exadata Database Machine Architecture
->Describe the Database Machine network architecture and requirements
->Describe the Database Machine software architecture
->Describe the Exadata Storage Server storage entities and their relationships
->Describe how multiple Database Machines can be interconnected and scaled up
->
->3. Key Capabilities of Exadata Database Machine
->Describe the key capabilities of Exadata Database Machine
->Describe the Exadata Smart Scan capabilities
->Describe the capabilities of hybrid columnar compression
->Describe the capabilities and uses of the Smart Flash Cache
->Describe t he capabilities of Columnar Flash Caching
->Describe the capabilities of the Smart Flash Log
->Describe the purpose and benefits of Storage Indexes
->Describe the capabilities and uses of Exadata Snapshot databases
->Describe Cell to Cell Data Transfer and Exadata Network Resource Management
->
->4. Exadata Database Machine Initial Configuration
->Describe site planning requirements for Database Machine
->Describe the installation and configuration process with the Exadata Deployment Assistant
->Describe the default configuration for Database Machine
->Describe supported and unsupported customizations for Database Machine
->
->5. Configure Exadata Storage Server
->Configure Exadata software and resources using Cellcli or other tools
->Create and configure ASM disk groups using Exadata
->Use the CellCLI, ExaCLI, DCLI and ExaDCLI Exadata administration tools
->Configure Exadata Storage Server security
->
->6.I/O Resource Management
->Use Exadata Storage Server I/O Resource Management to manage workloads within a database and across multiple databases
->Configure database resource management plans and profiles
->Configure category plans
->Configure inter-database plans
->Describe and configure the I/O resource manager objectives
->Monitor I/O using I/O Metrics
->
->7.Recommendations for Optimizing Database Performance
->Optimize database performance in conjunction with Exadata Database Machine
->Optimize Cell performance for Flash Cache and latency capping
->
->8.Using Smart Scan
->Describe Smart Scan and the query processing that can be offloaded to Exadata Storage Server
->Describe the requirements for Smart Scan
->Describe the circumstances that prevent using Smart Scan
->Identify Smart Scan in SQL execution plans including smart joins
->Use database statistics and wait events to confirm how queries are processed
->
->9.Consolidation Options and Recommendations
->Describe the options for consolidating multiple databases on Database Machine
->Describe the benefits and costs associated with different options
->Identify the most appropriate approach for consolidation in different circumstances
->
->10. Migrating Databases to Exadata Database Machine
->Describe the steps to migrate your database to Database Machine
->Explain the main approaches for migrating your database to Database Machine
->Identify the most appropriate approach for migration in different circumstances
->
->11. Bulk Data Loading
->Configure the Database File System (DBFS) feature for staging input data files
->Use external tables based on input data files stored in DBFS to perform high-performance data loads
->
->12. Exadata Database Machine Platform Monitoring
->Describe the purpose and uses of SNMP for the Database Machine
->Describe the purpose and uses of IPMI for the Database Machine
->Describe the purpose and uses of ILOM for the Database Machine
->
->13 Configuring Enterprise Manager Cloud Control 12c to Monitor Exadata Database Machine
->Describe the Enterprise Manager cloud Control architecture as it specifically applies to Exadata Database Machine
->Describe the discovery process and post discovery configurations
->
->14 Monitoring Exadata Storage Servers
->Describe Exadata Storage Server metrics, alerts, Thresholds and active requests
->Describe and use Exedata Storage Server Quarantines, Disk Scrubbing and repair
->Monitor Exadata Storage Server using Command line or Cloud control
->
->15 Monitoring Exadata Database Machine Database Servers
->Describe the monitoring recommendations for Exadata Database Machine database servers
->Use Cloud Control or DBMCLI to monitor Exadata Database Machine Database Servers
->
->16 Monitoring the InfiniBand Network
->Monitor InfiniBand switches With Cloud Control or CLI
->Monitor InfiniBand switch ports
->Monitor InfiniBand ports on the database servers ajd Cells with LIST IBPORT command
->
->17 Monitoring other Exadata Database Machine Components
->Monitor Exadata Database Machine components: Cisco Switch, Power Distribution Units
->
->18 Monitoring Tools
->Use monitoring tools: Exachk, ExaWatcher, TFA Collector DiagTools, ADRCI, Imageinfo and Imagehistory, OSWatcher
->
->19 Backup and Recovery for Exadata Database Machines
->Describe how RMAN backups are optimized using Exadata Storage Server
->Describe the recommended approaches for disk-based and tape-based backups of databases on Database Machine
->Perform backup and recovery
->Connect a media server to the Database Machine InfiniBand network
->
->20 Database Machine Maintenance tasks
->Power Database Machine on and off
->Safely shut down a single Exadata Storage Server
->Replace a damaged physical disk on a cell
->Replace a damaged flash card on a cell
->Move all disks from one cell to another
->Use the Exadata Cell Software Rescure Procedure
->
->21 Patching Exadata Database Machine
->Describe how software is maintained on different Database Machine components
->
->22 Database Machine Automated Support Ecosystem
->Describe the Auto Service Request (ASR) function and how it relates to Exadata Database Machine
->Describe the implementation requirements for ASR
->Describe the ASR configuration process
->Describe Oracle Configuration Manager (OCM) and how it relates to Exadata Database Machine
->1. Exadata Database Machine Overview
->Identify the benefits of using Database Machine for different application classes
->Describe the key capacity and performance specifications for Database Machine
->
->2. Exadata Database Machine Architecture
->Describe the Database Machine network architecture and requirements
->Describe the Database Machine software architecture
->Describe the Exadata Storage Server storage entities and their relationships
->Describe how multiple Database Machines can be interconnected and scaled up
->
->3. Key Capabilities of Exadata Database Machine
->Describe the key capabilities of Exadata Database Machine
->Describe the Exadata Smart Scan capabilities
->Describe the capabilities of hybrid columnar compression
->Describe the capabilities and uses of the Smart Flash Cache
->Describe t he capabilities of Columnar Flash Caching
->Describe the capabilities of the Smart Flash Log
->Describe the purpose and benefits of Storage Indexes
->Describe the capabilities and uses of Exadata Snapshot databases
->Describe Cell to Cell Data Transfer and Exadata Network Resource Management
->
->4. Exadata Database Machine Initial Configuration
->Describe site planning requirements for Database Machine
->Describe the installation and configuration process with the Exadata Deployment Assistant
->Describe the default configuration for Database Machine
->Describe supported and unsupported customizations for Database Machine
->
->5. Configure Exadata Storage Server
->Configure Exadata software and resources using Cellcli or other tools
->Create and configure ASM disk groups using Exadata
->Use the CellCLI, ExaCLI, DCLI and ExaDCLI Exadata administration tools
->Configure Exadata Storage Server security
->
->6.I/O Resource Management
->Use Exadata Storage Server I/O Resource Management to manage workloads within a database and across multiple databases
->Configure database resource management plans and profiles
->Configure category plans
->Configure inter-database plans
->Describe and configure the I/O resource manager objectives
->Monitor I/O using I/O Metrics
->
->7.Recommendations for Optimizing Database Performance
->Optimize database performance in conjunction with Exadata Database Machine
->Optimize Cell performance for Flash Cache and latency capping
->
->8.Using Smart Scan
->Describe Smart Scan and the query processing that can be offloaded to Exadata Storage Server
->Describe the requirements for Smart Scan
->Describe the circumstances that prevent using Smart Scan
->Identify Smart Scan in SQL execution plans including smart joins
->Use database statistics and wait events to confirm how queries are processed
->
->9.Consolidation Options and Recommendations
->Describe the options for consolidating multiple databases on Database Machine
->Describe the benefits and costs associated with different options
->Identify the most appropriate approach for consolidation in different circumstances
->
->10. Migrating Databases to Exadata Database Machine
->Describe the steps to migrate your database to Database Machine
->Explain the main approaches for migrating your database to Database Machine
->Identify the most appropriate approach for migration in different circumstances
->
->11. Bulk Data Loading
->Configure the Database File System (DBFS) feature for staging input data files
->Use external tables based on input data files stored in DBFS to perform high-performance data loads
->
->12. Exadata Database Machine Platform Monitoring
->Describe the purpose and uses of SNMP for the Database Machine
->Describe the purpose and uses of IPMI for the Database Machine
->Describe the purpose and uses of ILOM for the Database Machine
->
->13 Configuring Enterprise Manager Cloud Control 12c to Monitor Exadata Database Machine
->Describe the Enterprise Manager cloud Control architecture as it specifically applies to Exadata Database Machine
->Describe the discovery process and post discovery configurations
->
->14 Monitoring Exadata Storage Servers
->Describe Exadata Storage Server metrics, alerts, Thresholds and active requests
->Describe and use Exedata Storage Server Quarantines, Disk Scrubbing and repair
->Monitor Exadata Storage Server using Command line or Cloud control
->
->15 Monitoring Exadata Database Machine Database Servers
->Describe the monitoring recommendations for Exadata Database Machine database servers
->Use Cloud Control or DBMCLI to monitor Exadata Database Machine Database Servers
->
->16 Monitoring the InfiniBand Network
->Monitor InfiniBand switches With Cloud Control or CLI
->Monitor InfiniBand switch ports
->Monitor InfiniBand ports on the database servers ajd Cells with LIST IBPORT command
->
->17 Monitoring other Exadata Database Machine Components
->Monitor Exadata Database Machine components: Cisco Switch, Power Distribution Units
->
->18 Monitoring Tools
->Use monitoring tools: Exachk, ExaWatcher, TFA Collector DiagTools, ADRCI, Imageinfo and Imagehistory, OSWatcher
->
->19 Backup and Recovery for Exadata Database Machines
->Describe how RMAN backups are optimized using Exadata Storage Server
->Describe the recommended approaches for disk-based and tape-based backups of databases on Database Machine
->Perform backup and recovery
->Connect a media server to the Database Machine InfiniBand network
->
->20 Database Machine Maintenance tasks
->Power Database Machine on and off
->Safely shut down a single Exadata Storage Server
->Replace a damaged physical disk on a cell
->Replace a damaged flash card on a cell
->Move all disks from one cell to another
->Use the Exadata Cell Software Rescure Procedure
->
->21 Patching Exadata Database Machine
->Describe how software is maintained on different Database Machine components
->
->22 Database Machine Automated Support Ecosystem
->Describe the Auto Service Request (ASR) function and how it relates to Exadata Database Machine
->Describe the implementation requirements for ASR
->Describe the ASR configuration process
->Describe Oracle Configuration Manager (OCM) and how it relates to Exadata Database Machine
No comments:
Post a Comment