Performance Tuning

Oracle 12c    |    Intermediate
  • 15 videos | 1h 5m 24s
  • Earns a Badge
Rating 4.5 of 32 users Rating 4.5 of 32 users (32)
Performance tuning is an important aspect of Oracle Database 12c administration. Learn how to monitor and tune both database and memory performance in Oracle Database 12c.

WHAT YOU WILL LEARN

  • Plan, monitor, and tune performance in oracle database 12c
    Tune the performance of a database instance in oracle database 12c
    Use em database express and em cloud control to monitor database performance in oracle database 12c
    Monitor session performance in oracle database 12c
    Monitor top services in oracle database 12c
    Describe and view wait events in oracle database 12c
    Use the data dictionary views to diagnose and tune performance problems in oracle database 12c
    Identify guidelines for memory management in oracle database 12c
  • Describe automatic memory management (amm) and related memory parameters in oracle database 12c
    Enable and monitor automatic memory management (amm) in oracle database 12c
    Describe automatic shared memory management (assm) in oracle database 12c
    Describe and enable automatic segment space management (assm) in oracle database 12c
    Describe values for autotuned sga parameters in oracle database 12c
    Describe the program global area (pga) and the dynamic performance statistics available in  the oracle database 12c
    Configure awr retention parameters, generate an awr report, review server-generated alerts, and enable automatic memory management (amm) in oracle database 12c

IN THIS COURSE

  • Locked
    1.  Performance Monitoring and Tuning
    5m 18s
    Learn how to plan, monitor, and tune performance in Oracle Database 12c. FREE ACCESS
  • Locked
    2.  Instance Performance Tuning
    5m 14s
    In this video, you will learn how to tune the performance of a database instance in Oracle Database 12c. FREE ACCESS
  • Locked
    3.  Using Enterprise Manager to Manage Performance
    3m 53s
    Learn how to use Oracle Database 12c's EM Database Express and EM Cloud Control to monitor database performance. FREE ACCESS
  • Locked
    4.  Monitoring Session Performance
    4m 44s
    In this video, you will learn how to monitor session performance in Oracle Database 12c. FREE ACCESS
  • Locked
    5.  Monitoring Top Services
    2m 34s
    In this video, you will monitor the top services in Oracle Database 12c. FREE ACCESS
  • Locked
    6.  Viewing Wait Events
    3m 4s
    Upon completion of this video, you will be able to describe and view wait events in Oracle Database 12c. FREE ACCESS
  • Locked
    7.  Using Views to Tune Performance
    2m 15s
    To diagnose and tune performance problems in Oracle Database 12c, find out how to use the data dictionary views. FREE ACCESS
  • Locked
    8.  Memory Management Guidelines
    6m 41s
    During this video, you will learn how to identify guidelines for memory management in Oracle Database 12c. FREE ACCESS
  • Locked
    9.  Automatic Memory Management
    3m 55s
    Upon completion of this video, you will be able to describe Automatic Memory Management and related memory parameters in Oracle Database 12c. FREE ACCESS
  • Locked
    10.  Enabling and Monitoring AMM
    4m 41s
    During this video, you will learn how to enable and monitor Automatic Memory Management in Oracle Database 12c. FREE ACCESS
  • Locked
    11.  Automatic Shared Memory Management
    3m 3s
    Upon completion of this video, you will be able to describe Automatic Shared Memory Management in Oracle Database 12c. FREE ACCESS
  • Locked
    12.  Enabling ASSM
    7m 4s
    After completing this video, you will be able to describe and enable Automatic Segment Space Management in Oracle Database 12c. FREE ACCESS
  • Locked
    13.  Autotuned SGA Parameters
    1m 54s
    Upon completion of this video, you will be able to describe values for autotuned SGA parameters in Oracle Database 12c. FREE ACCESS
  • Locked
    14.  Managing the Program Global Area
    6m 8s
    After completing this video, you will be able to describe the program global area (PGA) and the dynamic performance statistics available in the Oracle Database 12c. FREE ACCESS
  • Locked
    15.  Exercise: Perform Database Maintenance
    4m 57s
    In this video, you will learn how to configure AWR retention parameters, generate an AWR report, review server-generated alerts, and enable Automatic Memory Management (AMM) in Oracle Database 12c. 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
Book Expert Performance Indexing in Azure SQL and SQL Server 2022: Toward Faster Results and Lower Maintenance Both on Premises and in the Cloud, 4th Edition
Book Pro Oracle SQL Development: Best Practices for Writing Advanced Queries, Second Edition

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Measuring SQL Performance
Rating 4.5 of 10 users Rating 4.5 of 10 users (10)
Course RAC Recovery Manager
Rating 4.8 of 9 users Rating 4.8 of 9 users (9)
Course Relational Database Concepts
Rating 4.4 of 649 users Rating 4.4 of 649 users (649)