Overview

Exadata Database Machine OverviewIdentify the benefits of using Database Machine for different application classesDescribe the key capacity and performance specifications for Database MachineExadata Database Machine ArchitectureDescribe the Database Machine network architecture and requirementsDescribe the Database Machine software architectureDescribe the Exadata Storage Server storage entities and their relationshipsDescribe how multiple Database Machines can be interconnected and scaled upKey Capabilities of Exadata Database MachineDescribe the key capabilities of Exadata Database MachineDescribe the Exadata Smart Scan capabilitiesDescribe the capabilities of hybrid columnar compressionDescribe the capabilities and uses of the Smart Flash CacheDescribe t he capabilities of Columnar Flash CachingDescribe the capabilities of the Smart Flash LogDescribe the purpose and benefits of Storage IndexesDescribe the capabilities and uses of Exadata Snapshot databasesDescribe Cell to Cell Data Transfer and Exadata Network Resource ManagementExadata Database Machine Initial ConfigurationDescribe site planning requirements for Database MachineDescribe the installation and configuration process with the Exadata Deployment AssistantDescribe the default configuration for Database MachineDescribe supported and unsupported customizations for Database MachineConfigure Exadata Storage ServerConfigure Exadata software and resources using Cellcli or other toolsCreate and configure ASM disk groups using ExadataUse the CellCLI, ExaCLI, DCLI and ExaDCLI Exadata administration toolsConfigure Exadata Storage Server securityI/O Resource ManagementUse Exadata Storage Server I/O Resource Management to manage workloads within a database and across multiple databasesConfigure database resource management plans and profilesConfigure category plansConfigure inter-database plansDescribe and configure the I/O resource manager objectivesMonitor I/O using I/O MetricsRecommendations for Optimizing Database PerformanceOptimize database performance in conjunction with Exadata Database MachineOptimize Cell performance for Flash Cache and latency cappingUsing Smart ScanDescribe Smart Scan and the query processing that can be offloaded to Exadata Storage ServerDescribe the requirements for Smart ScanDescribe the circumstances that prevent using Smart ScanIdentify Smart Scan in SQL execution plans including smart joinsUse database statistics and wait events to confirm how queries are processedConsolidation Options and RecommendationsDescribe the options for consolidating multiple databases on Database MachineDescribe the benefits and costs associated with different optionsIdentify the most appropriate approach for consolidation in different circumstancesMigrating Databases to Exadata Database MachineDescribe the steps to migrate your database to Database MachineExplain the main approaches for migrating your database to Database MachineIdentify the most appropriate approach for migration in different circumstancesBulk Data LoadingConfigure the Database File System (DBFS) feature for staging input data filesUse external tables based on input data files stored in DBFS to perform high-performance data loadsExadata Database Machine Platform MonitoringDescribe the purpose and uses of SNMP for the Database MachineDescribe the purpose and uses of IPMI for the Database MachineDescribe the purpose and uses of ILOM for the Database MachineConfiguring Enterprise Manager Cloud Control 12c to Monitor Exadata Database MachineDescribe the Enterprise Manager cloud Control architecture as it specifically applies to Exadata Database MachineDescribe the discovery process and post discovery configurationsMonitoring Exadata Storage ServersDescribe Exadata Storage Server metrics, alerts, Thresholds and active requestsDescribe and use Exedata Storage Server Quarantines, Disk Scrubbing and repairMonitor Exadata Storage Server using Command line or Cloud controlMonitoring Exadata Database Machine Database ServersDescribe the monitoring recommendations for Exadata Database Machine database serversUse Cloud Control or DBMCLI to monitor Exadata Database Machine Database ServersMonitoring the InfiniBand NetworkMonitor InfiniBand switches With Cloud Control or CLIMonitor InfiniBand switch portsMonitor InfiniBand ports on the database servers ajd Cells with LIST IBPORT commandMonitoring other Exadata Database Machine ComponentsMonitor Exadata Database Machine components: Cisco Switch, Power Distribution UnitsMonitoring ToolsUse monitoring tools: Exachk, ExaWatcher, TFA Collector DiagTools, ADRCI, Imageinfo and Imagehistory, OSWatcherBackup and Recovery for Exadata Database MachinesDescribe how RMAN backups are optimized using Exadata Storage ServerDescribe the recommended approaches for disk-based and tape-based backups of databases on Database MachinePerform backup and recoveryConnect a media server to the Database Machine InfiniBand networkDatabase Machine Maintenance tasksPower Database Machine on and offSafely shut down a single Exadata Storage ServerReplace a damaged physical disk on a cellReplace a damaged flash card on a cellMove all disks from one cell to anotherUse the Exadata Cell Software Rescure ProcedurePatching Exadata Database MachineDescribe how software is maintained on different Database Machine componentsDatabase Machine Automated Support EcosystemDescribe the Auto Service Request (ASR) function and how it relates to Exadata Database MachineDescribe the implementation requirements for ASRDescribe the ASR configuration processDescribe Oracle Configuration Manager (OCM) and how it relates to Exadata Database Machine

Skills

Reviews