D108103OROracleOR-D1081031.0<ul> <li>Use the Oracle Database tuning methodology appropriate to the available tools</li><li>Utilize database advisors to proactively tune an Oracle Database Instance</li><li>Use the tools based on the Automatic Workload Repository to tune the database</li><li>Diagnose and tune common SQL related performance problems</li><li>Diagnose and tune common Instance related performance problems</li><li>Use Enterprise Manager performance-related pages to monitor an Oracle Database</li></ul><h5>Suggested Prerequisite</h5><ul> <li>Oracle Database 12c R2: Install and Upgrade Workshop Ed 2</li><li>Familiarity with Oracle Database installation</li><li>Familiarity with Oracle Database configuration concepts</li></ul><h5>Required Prerequisite</h5><ul> <li>Oracle Database 18c: Administration Workshop Ed 1</li><li>Basic knowledge of Linux operating system</li><li>A working knowledge of SQL and PL/SQL packages</li><li>Basic understanding of Oracle Database architecture</li><li>Familiarity with basic database monitoring procedures</li></ul><ul> <li>Administrator</li><li>Database Administrator</li></ul><ul> <li>Introduction</li><li>Basic Tuning Diagnostics</li><li>Using Automatic Workload Repository</li><li>Defining the Scope of Performance Issues</li><li>Using Metrics and Alerts</li><li>Using Baselines</li><li>Using AWR-Based Tools</li><li>Real-Time Database Operation Monitoring</li><li>Monitoring Applications</li><li>Identifying Problem SQL Statements</li><li>Influencing the Optimizer</li><li>Reducing the Cost of SQL Operations</li><li>Using SQL Performance Analyzer</li><li>SQL Performance Management</li><li>Using Database Replay</li><li>Tuning the Shared Pool</li><li>Tuning the Buffer Cache</li><li>Tuning PGA and Temporary Space</li><li>Automatic Memory</li><li>Performance Tuning Summary with Waits</li></ul>- Use the Oracle Database tuning methodology appropriate to the available tools - Utilize database advisors to proactively tune an Oracle Database Instance - Use the tools based on the Automatic Workload Repository to tune the database - Diagnose and tune common SQL related performance problems - Diagnose and tune common Instance related performance problems - Use Enterprise Manager performance-related pages to monitor an Oracle DatabaseSuggested Prerequisite - Oracle Database 12c R2: Install and Upgrade Workshop Ed 2 - Familiarity with Oracle Database installation - Familiarity with Oracle Database configuration concepts Required Prerequisite - Oracle Database 18c: Administration Workshop Ed 1 - Basic knowledge of Linux operating system - A working knowledge of SQL and PL/SQL packages - Basic understanding of Oracle Database architecture - Familiarity with basic database monitoring procedures- Administrator - Database Administrator- Introduction - Basic Tuning Diagnostics - Using Automatic Workload Repository - Defining the Scope of Performance Issues - Using Metrics and Alerts - Using Baselines - Using AWR-Based Tools - Real-Time Database Operation Monitoring - Monitoring Applications - Identifying Problem SQL Statements - Influencing the Optimizer - Reducing the Cost of SQL Operations - Using SQL Performance Analyzer - SQL Performance Management - Using Database Replay - Tuning the Shared Pool - Tuning the Buffer Cache - Tuning PGA and Temporary Space - Automatic Memory - Performance Tuning Summary with Waits5 jours4260.00