{"course":{"productid":32677,"modality":6,"active":true,"language":"en","title":"Oracle Database: Performance Management and Tuning","productcode":"D108103","vendorcode":"OR","vendorname":"Oracle","fullproductcode":"OR-D108103","courseware":{"has_ekit":true,"has_printkit":false,"language":""},"url":"https:\/\/portal.flane.ch\/course\/oracle-d108103","objective":"<ul>\n<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>","essentials":"<h5>Suggested Prerequisite<\/h5><ul>\n<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>\n<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>","audience":"<ul>\n<li>Administrator<\/li><li>Database Administrator<\/li><\/ul>","contents":"<ul>\n<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>","objective_plain":"- Use the Oracle Database tuning methodology appropriate to the available tools\n- Utilize database advisors to proactively tune an Oracle Database Instance\n- Use the tools based on the Automatic Workload Repository to tune the database\n- Diagnose and tune common SQL related performance problems\n- Diagnose and tune common Instance related performance problems\n- Use Enterprise Manager performance-related pages to monitor an Oracle Database","essentials_plain":"Suggested Prerequisite\n\n\n- Oracle Database 12c R2: Install and Upgrade Workshop Ed 2\n- Familiarity with Oracle Database installation\n- Familiarity with Oracle Database configuration concepts\nRequired Prerequisite\n\n\n- Oracle Database 18c: Administration Workshop Ed 1\n- Basic knowledge of Linux operating system\n- A working knowledge of SQL and PL\/SQL packages\n- Basic understanding of Oracle Database architecture\n- Familiarity with basic database monitoring procedures","audience_plain":"- Administrator\n- Database Administrator","contents_plain":"- Introduction\n- Basic Tuning Diagnostics\n- Using Automatic Workload Repository\n- Defining the Scope of Performance Issues\n- Using Metrics and Alerts\n- Using Baselines\n- Using AWR-Based Tools\n- Real-Time Database Operation Monitoring\n- Monitoring Applications\n- Identifying Problem SQL Statements\n- Influencing the Optimizer\n- Reducing the Cost of SQL Operations\n- Using SQL Performance Analyzer\n- SQL Performance Management\n- Using Database Replay\n- Tuning the Shared Pool\n- Tuning the Buffer Cache\n- Tuning PGA and Temporary Space\n- Automatic Memory\n- Performance Tuning Summary with Waits","skill_level":"Intermediate","version":"1.0","duration":{"unit":"d","value":5,"formatted":"5 days"},"pricelist":{"List Price":{"DE":{"country":"DE","currency":"EUR","taxrate":19,"price":4260}}},"lastchanged":"2025-07-29T12:18:18+02:00","parenturl":"https:\/\/portal.flane.ch\/swisscom\/en\/json-courses","nexturl_course_schedule":"https:\/\/portal.flane.ch\/swisscom\/en\/json-course-schedule\/32677","source_lang":"en","source":"https:\/\/portal.flane.ch\/swisscom\/en\/json-course\/oracle-d108103"}}