Oracle Database 19c: Performance Management and Tuning

This is a high-level list of topics covered in this course. Please see the detailed Agenda below  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 Database

  • No Rating
  • (0 Reviews)
  • 0 Students enrolled

Hours :

Hands on Labs

Requirements

  • Required Prerequisite  Oracle Database 18c: Administration hands on lab  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 Audience: This course is intended for  Administrator  Database Administrator

Description

Working in a hands-on learning environment, led by our Oracle Database instructor, students will learn about and explore:  Use the Oracle tuning methodology  Use Oracle-supplied tools for monitoring and diagnosing SQL and instance tuning issues  Use database advisors to proactively correct performance problems  Identify problem SQL statements  Tune SQL performance problems  Monitor instance performance by using Enterprise Manager  Tune instance components by primarily using instance parameters

Course Content

Recent Courses

blog
Last Updated 28th September 2020
  • 0
  • Free
blog
Last Updated 28th September 2020
  • 0
  • Free
blog
Last Updated 25th September 2020
  • 0
  • Free
blog
Last Updated 25th September 2020
  • 0
  • Free
blog
Last Updated 25th September 2020
  • 0
  • Free

About the Instructor

instructor
About the Instructor

Ernesto Lee is an impassioned blockchain entrepreneur and technologist from the Miami/Fort Lauderdale Area. For over 25 years Ernesto has been asking hard questions and pursuing tough answers. Ernesto was an original founding member, co-owner and the CTO of Blockchain Training Alliance and former Chief Solutions Architect at TechBlue.com. Presently, Ernesto is the CEO at Ernesto.Net and Engineer at Kaiser Permanente.  Ernesto’s career illustrates a lifelong commitment to pushing the envelope on innovation and growing opportunities for all around him.

As a graduate of Old Dominion University (BS, Physics), Virginia Tech (MS, Software Engineering), and Harvard Extension School (Graduate Certificate, Business Communication), Ernesto has always had a passion for technology and teaching. It has been a cornerstone of Ernesto’s career.