Performance, Migration, & Compression

Oracle 12c    |    Intermediate
  • 14 videos | 47m 38s
  • Includes Assessment
  • Earns a Badge
Rating 4.0 of 2 users Rating 4.0 of 2 users (2)
Better tune your Oracle 12c database by understanding index maintenance, extent management, database blocks, Automatic Segment Space Management, migration and chaining, and data compression.

WHAT YOU WILL LEARN

  • Describe how adding indexes can improve sql performance
    Describe how index maintenance operations can improve sql performance
    Describe how space usage of tables can impact performance
    Define the concept of extents and how they relate to the performance of sql operations
    Describe the structure of a database block
    List the ways of reducing block visits and describe the methods of block allocation
    Describe block space management with freelists
  • Describe the concept of assm
    Describe block space management with assm
    Define the concepts of block migration and chaining
    Describe how shrinking segments can improve the performance of sql statements
    Describe how data compression can assist in improving the performance of sql statements
    Describe the concept of hcc and using the compression advisor
    Examine how inaccurate statistics can mislead the optimizer and rectifying the problem

IN THIS COURSE

  • Locked
    1.  Adding Indexes
    3m 53s
    After completing this video, you will be able to describe how adding indexes can improve SQL performance. FREE ACCESS
  • Locked
    2.  Maintaining Indexes
    4m 1s
    After completing this video, you will be able to describe how index maintenance operations can improve SQL Server performance. FREE ACCESS
  • Locked
    3.  Table Maintenance for Performance
    3m 28s
    After completing this video, you will be able to describe how table space usage can impact performance. FREE ACCESS
  • Locked
    4.  Extent Management
    4m 15s
    In this video, you will learn about extents and how they relate to the performance of SQL operations. FREE ACCESS
  • Locked
    5.  The Anatomy of a Database Block
    2m 37s
    After completing this video, you will be able to describe the structure of a database table. FREE ACCESS
  • Locked
    6.  Block Visits and Allocation
    1m 23s
    Upon completion of this video, you will be able to list the ways of reducing block visits and describe the methods of block allocation. FREE ACCESS
  • Locked
    7.  Block Space Management with Freelists
    3m 24s
    After completing this video, you will be able to describe block space management using freelists. FREE ACCESS
  • Locked
    8.  Automatic Segment Space Management
    2m 14s
    After completing this video, you will be able to describe the concept of automatic storage management. FREE ACCESS
  • Locked
    9.  Block Space Management with ASSM
    2m 39s
    Upon completion of this video, you will be able to describe block space management with Automatic Segment Space Management. FREE ACCESS
  • Locked
    10.  Migration and Chaining
    5m 3s
    Learn how to define the concepts of block migration and chaining. FREE ACCESS
  • Locked
    11.  Shrinking Segments
    4m 8s
    After completing this video, you will be able to describe how using fewer segments can improve the performance of SQL statements. FREE ACCESS
  • Locked
    12.  Data Compression
    3m 29s
    Upon completion of this video, you will be able to describe how data compression can help improve the performance of SQL statements. FREE ACCESS
  • Locked
    13.  Hybrid Columnar Compression
    2m 31s
    Upon completion of this video, you will be able to describe the concept of HCC and how to use the compression advisor. FREE ACCESS
  • Locked
    14.  Exercise: Influencing Performance with Statistics
    4m 34s
    In this video, you will examine how inaccurate statistics can mislead the optimizer and how to rectify the problem. 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 DBA Essentials for 21c: Installing Oracle Database 21c on OCI Compute
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