Performance, Migration, & Compression
Oracle 12c
| Intermediate
- 14 Videos | 47m 38s
- Includes Assessment
- Earns a Badge
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
-
1.Adding Indexes3m 53s
-
2.Maintaining Indexes4m 1s
-
3.Table Maintenance for Performance3m 28s
-
4.Extent Management4m 15s
-
5.The Anatomy of a Database Block2m 37s
-
6.Block Visits and Allocation1m 23s
-
7.Block Space Management with Freelists3m 24s
-
8.Automatic Segment Space Management2m 14s
-
9.Block Space Management with ASSM2m 39s
-
10.Migration and Chaining5m 3s
-
11.Shrinking Segments4m 8s
-
12.Data Compression3m 29s
-
13.Hybrid Columnar Compression2m 31s
-
14.Exercise: Influencing Performance with Statistics4m 34s
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.
