Login     Signup
   info@zetlantechnologies.com        +91-8680961847

  /   Oracle Technical Certification   /   OD 19C PMT


Exam 1Z0-084: Oracle Database 19C Performance Management and Tunning


Exam Code Delivery format Duration No of Questions Passing Score
1Z0-084 Proctored Online Multiple Choice 90 Minutes 55 60%

Exam Overview

The Oracle Database 19c: Performance Management and Tuning OCP has demonstrated a strong understanding of performance analysis, management and tuning for optimal performance of an Oracle Database environment. They can apply a database tuning methodology by using the appropriate tools in order to monitor, diagnose and tune instance and SQL performance problems. This candidate possesses a profound knowledge of the Oracle Database architecture, great familiarity with day-to-day database administration, knowledge of which advisors can be used to inspect various aspects/areas of the Oracle Database environment, and a good working knowledge of SQL, its executions plans and generated statistics.


Course Details

1. Basic Tuning Methods and Diagnostics

  • Tuning Methodologies
  • Tuning Lifecyles phases
  • Describe the time model
  • Explain wait events
  • Diagnosing performance problems using V$ views

  • Installing and configuring Statspack
  • Diagnosing performance problem using Statspack

  • Using the Alert Log to Monitor Performance
  • Using Trace files to Monitor Performance
  • Monitoring performance using metric thresholds and alerts
  • Using AWR baselines to monitor performance

  • Diagnosing performance issues using ADDM
  • Diagnosing performance issues using ASH reports
  • Using Automated Maintenance Tasks to Manage Performance
  • Implementing Real-Time Database Operation Monitoring
  • Configuring and using services to monitor database Application performance

  • 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 Re-optimization and SQL Plan Directives

  • Explain how statistics influence the optimizer
  • Configuring parameters to influence the optimizer

  • Shrinking Segments
  • Managing Chaining and Migration
  • Configuring Index and Table Performance Options
  • Configuring table compression
  • Diagnosing and tuning space related issues

  • Using SQL Performance Analyzer to test the impact of database changes
  • Use Database Replay to check impact of system change on performance
  • 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

  • Diagnosing and resolving performance problems related to the shared pool
  • Managing and Tuning the Result Cache

  • Diagnosing and resolving performance problems related to the buffer cache
  • Diagnose database I/O issues
  • Configuring Big Table Caching
  • Configuring Flash Cache
  • Diagnosing and resolving performance issues related to PGA
  • Diagnosing and resolving performance issues related to temporary tablespace

  • Configuring Automatic Shared Memory Management
  • Configuring Automatic Memory Management
  • Configure and Use in memory columnn store to improve SQL performance
  • Use in memnory column store with other database features.


Fees Structure : 15500 INR / 185 USD
Total No of Class : 46 Video Class
Class Duration : 48:30 Working Hours
Download Feature : Download Avalable
Technical Support : Call / Whatsapp : +91 8680961847
Working Hours : Monday to Firday 9 AM to 6 PM
Payment Mode : Credit Card / Debit Card / NetBanking / Wallet (Gpay/Phonepay/Paytm/WhatsApp Pay)

Brochure       Buy Now       Sample Demo

Fees Structure : 30000 INR / 355 USD
Class Duration : 60 Days
Class Recording : Live Class Recording available
Class Time : Monday to Firday 1.5 hours per day / Weekend 3 Hours per day
Technical Support : Call / Whatsapp : +91 8680961847
Working Hours : Monday to Firday 9 AM to 6 PM
Payment Mode : Credit Card / Debit Card / NetBanking / Wallet (Gpay/Phonepay/Paytm/WhatsApp Pay)

Download Brochure       Pay Online

Information Technologies

Why People Like us!

For over a decade, we have been on a mission: helping everyone grow up in IT Industry. Today, we are asking that you join us.

Read More

More Info

About Us Contact Us Privacy Policy Terms & Condition Refund Policy FAQs & Help

Account

My Account Course Details Shopping Cart Wishlist Order History Payment Details

Contact

Address: Chennai, Tamilnadu, India

Email: info@zetlantechnologies.com

Phone: +91 8680961847

Payment Accepted

Zetlan Technologies, All right reserved.