Performance, Migration, & Compression

Oracle 12c    |    Intermediate
  • 14 videos | 47m 38s
  • Includes Assessment
  • Earns a Badge
Likes 5 Likes 5
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

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

Course Data Engineering on Microsoft Azure: Data Solution Optimization
Likes 29 Likes 29  
Channel Wintellect SQL Server
Likes 1 Likes 1  
Course Connectivity & Space Management
Likes 9 Likes 9