SQL Tuning

Oracle 12c    |    Intermediate
  • 10 videos | 53m 42s
  • Includes Assessment
  • Earns a Badge
Rating 3.7 of 18 users Rating 3.7 of 18 users (18)
Proper monitoring and tuning of databases significantly improves system performance. Learn how to use SQL tuning, optimizer statistics, and the range of SQL advisors included in Oracle Database 12c.

WHAT YOU WILL LEARN

  • Describe sql tuning and the optimizer statistics used in oracle database 12c
    Describe the collection of optimizer statistics in oracle database 12c
    Use the optimizer statistics console to set global preferences for optimizer statistics in oracle database 12c
    Gather optimizer statistics manually and set optimizer statistics preferences in oracle database 12c
    Describe concurrent statistics gathering in the oracle database 12c
  • Describe concurrent statistics gathering and the use of sql plan directives in the oracle database 12c
    Describe the sql advisors available in oracle database 12c
    Describe and use the sql tuning advisor in oracle database 12c
    Describe and use the sql access advisor in oracle database 12c
    Describe and use the sql performance analyzer in oracle database 12c

IN THIS COURSE

  • Locked
    1.  SQL Tuning and Optimizer Statistics Overview
    5m 14s
    Upon completion of this video, you will be able to describe SQL tuning and the optimizer statistics used in Oracle Database 12c. FREE ACCESS
  • Locked
    2.  Optimizer Statistics Collection
    4m 27s
    Upon completion of this video, you will be able to describe the collection of optimizer statistics in Oracle Database 12c. FREE ACCESS
  • Locked
    3.  Viewing and Configuring Optimizer Statistics
    3m 13s
    In this video, find out how to use the Optimizer Statistics Console to set global preferences for optimizer statistics in Oracle Database 12c. FREE ACCESS
  • Locked
    4.  Manually Gathering Optimizer Statistics
    6m 46s
    To find out how to gather optimizer statistics manually and set optimizer statistics preferences in Oracle Database 12c, consult the Oracle documentation. FREE ACCESS
  • Locked
    5.  Gathering Concurrent Statistics
    1m 21s
    After completing this video, you will be able to describe concurrent statistics gathering in Oracle Database 12c. FREE ACCESS
  • Locked
    6.  Gather Concurrent Statistics and SQL Plan Directives
    7m 30s
    Upon completion of this video, you will be able to describe concurrent statistics gathering and the use of SQL plan directives in the Oracle Database 12c. FREE ACCESS
  • Locked
    7.  Overview of SQL Advisors
    3m 15s
    Upon completion of this video, you will be able to describe the SQL Advisors available in Oracle Database 12c. FREE ACCESS
  • Locked
    8.  SQL Tuning Advisor
    7m 53s
    After completing this video, you will be able to describe and use the SQL Tuning Advisor in Oracle Database 12c. FREE ACCESS
  • Locked
    9.  SQL Access Advisor
    7m 51s
    After completing this video, you will be able to describe and use the SQL Access Advisor in Oracle Database 12c. FREE ACCESS
  • Locked
    10.  SQL Performance Analyzer
    6m 14s
    Upon completion of this video, you will be able to describe and use the SQL Performance Analyzer 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 SQL Server 2022 Query Performance Tuning: Troubleshoot and Optimize Query Performance, 6th Edition
Channel Oracle Database 12c Administrator Certified Associate
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Book Pro Oracle Database 23c Administration: Manage and Safeguard Your Organization's Data, Fourth Edition

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Oracle Database Instance Overview
Rating 4.5 of 97 users Rating 4.5 of 97 users (97)
Course SQL*Plus Commands
Rating 4.5 of 285 users Rating 4.5 of 285 users (285)
Course Oracle Database 12c R2 SQL: Using Structured Query Language (SQL)
Rating 4.6 of 255 users Rating 4.6 of 255 users (255)