Implementing Performance Tuning

Oracle 12c    |    Intermediate
  • 11 videos | 28m 12s
  • Includes Assessment
  • Earns a Badge
Rating 4.3 of 6 users Rating 4.3 of 6 users (6)
Oracle Enterprise Manager gives you a central area for managing Oracle tools. Learn about OEM architecture and pages, as well as using alerts in tuning, user trace files, common tuning problems, and service requests.

WHAT YOU WILL LEARN

  • Describe oracle enterprise manager
    Describe the oracle em architecture
    Use oem to view the performance hub page
    Use oem or command-line tools to view the alert log
    Describe user trace files
    Describe how to define and limit the scope of a problem
  • List common tuning problems
    List the tuning life cycle phases
    Evaluate the balance between performance and business requirements
    Work with oracle support to file a performance service request
    Use sql commands to query the dynamic performance views to view tuning information

IN THIS COURSE

  • Locked
    1.  Enterprise Manager Overview
    1m 49s
    After completing this video, you will be able to describe what Oracle Enterprise Manager is. FREE ACCESS
  • Locked
    2.  Oracle EM Architecture
    2m 17s
    After completing this video, you will be able to describe the Oracle Enterprise Manager architecture. FREE ACCESS
  • Locked
    3.  Viewing the Performance Hub Page
    3m 13s
    In this video, you will use the OEM to view the performance hub page. FREE ACCESS
  • Locked
    4.  Using the Alert Log In Tuning
    2m 16s
    Learn how to use OEM or command-line tools to view the alert log. FREE ACCESS
  • Locked
    5.  User Trace Files
    2m 9s
    After watching this video, you will be able to describe user trace files. FREE ACCESS
  • Locked
    6.  Defining the Scope of a Problem
    2m 40s
    After completing this video, you will be able to describe how to define and limit the scope of a problem. FREE ACCESS
  • Locked
    7.  Common Tuning Problems
    2m 9s
    After completing this video, you will be able to list common tuning problems and how to fix them. FREE ACCESS
  • Locked
    8.  Tuning Life Cycle Phases
    2m 54s
    Upon completion of this video, you will be able to list the phases of the tuning life cycle. FREE ACCESS
  • Locked
    9.  Performance vs. Business Requirements
    1m 52s
    Learn how to evaluate the balance between performance and business requirements. FREE ACCESS
  • Locked
    10.  Filing a Performance Service Request
    2m 15s
    In this video, find out how to work with Oracle support to file a service request for performance issues. FREE ACCESS
  • Locked
    11.  Exercise: View Diagnostic Information
    4m 40s
    During this video, you will learn how to use SQL commands to query the dynamic performance views to view tuning information. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Book Modern Oracle Database Programming: Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, PL/SQL, and JSON
Course Decision Analysis and Management: Technical Monitoring
Rating 3.0 of 1 users Rating 3.0 of 1 users (1)
Book Database Performance at Scale: A Practical Guide

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course AWS SysOps Associate 2022: Architecting AWS to Meet Business Needs
Rating 4.6 of 91 users Rating 4.6 of 91 users (91)
Course SQL Diagnostics
Rating 4.2 of 10 users Rating 4.2 of 10 users (10)
Course AWS Cloud Practitioner 2023: AWS Network Services
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)