Performance, Migration, & Compression

Oracle 12c    |    Intermediate
  • 14 Videos | 54m 8s
  • 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 of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

CHANNEL Oracle Database 12c Administrator Certified Professional
Likes 34 Likes 34  
CHANNEL Apache Cassandra
Likes 20 Likes 20  
COURSE Oracle Database 12c R2 SQL: Conversion Functions & Conditional Expressions
Likes 39 Likes 39