1Z0-084: Oracle Database 19c - Performance Management and Tuning

Full Name: Oracle Database 19c - Performance Management and Tuning

Exam Code: 1Z0-084

Try Sample Exam »

Oracle 1Z0-084 Exam Details:

Exam Name	Oracle Database 19c - Performance Management and Tuning
Exam Code	1Z0-084
Exam Price	USD $245 (Pricing may vary by country or by localized currency)
Duration	90 minutes
Number of Questions	55
Passing Score	60%
Format	Multiple Choice Questions (MCQ)
Sample Questions	Oracle Certified Professional, Oracle Database 19c - Performance Management and Tuning
Recommended Practice	1Z0-084 Online Practice Exam

Oracle 1Z0-084 Syllabus Topics:

Basic Tuning Methods and Diagnostics	- Tuning Methodologies - Tuning Lifecyles phases - Describe the time model - Explain wait events - Diagnosing performance problems using V$ views
Using Statspack	- Installing and configuring Statspack - Diagnosing performance problem using Statspack
Using Log and Trace Files to Monitor Performance	- Using the Alert Log to Monitor Performance - Using Trace files to Monitor Performance
Using Metrics, Alerts and Baselines	- Monitoring performance using metric thresholds and alerts - Using AWR baselines to monitor performance
Using AWR-Based Tools	- Diagnosing performance issues using ADDM - Diagnosing performance issues using ASH reports - Using Automated Maintenance Tasks to Manage Performance
Performing Oracle Database Application Monitoring	- Implementing Real-Time Database Operation Monitoring - Configuring and using services to monitor database Application performance
Identifying Problem SQL Statements	- Understand the phases for SQL statement processing - Interpreting execution plans - Using formatted output of SQL Trace or the optimizer trace to identify poorly performing SQL statements - Monitoring Adaptive / Dynamic Execution plans - Monitoring Automatic Reoptimization and SQL Plan Directives
Influencing the Optimizer	- Explain how statistics influence the optimizer - Configuring parameters to influence the optimizer
Reducing the Cost of SQL Operations	- Shrinking Segments - Managing Chaining and Migration - Configuring Index and Table Performance Options - Configuring table compression - Diagnosing and tuning space related issues
Using Real Application Testing	- Using SQL Performance Analyzer to test the impact of database changes - Use Database Replay to check impact of system change on performance
SQL Performance Management	- Managing optimizer statistics - Using the Optimizer Statistics Advisor - Using the SQL Access and SQL Tuning advisors to Tune SQL statements - Use SQL Plan Management to tune SQL statements
Tuning the Shared Pool	- Diagnosing and resolving performance problems related to the shared pool - Managing and Tuning the Result Cache
Tuning the Buffer Cache	- Diagnosing and resolving performance problems related to the buffer cache - Diagnose database I/O issues - Configuring Big Table Caching - Configuring Flash Cache
Tuning the PGA	- Diagnosing and resolving performance issues related to PGA - Diagnosing and resolving performance issues related to temporary tablespace
Using Automatic Memory Management	- Configuring Automatic Shared Memory Management - Configuring Automatic Memory Management
Using In-Memory Features	- Configure and Use in memory columnn store to improve SQL performance - Use in memnory column store with other database features.