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 performancedescribe how index maintenance operations can improve SQL performancedescribe how space usage of tables can impact performancedefine the concept of extents and how they relate to the performance of SQL operationsdescribe the structure of a database blocklist the ways of reducing block visits and describe the methods of block allocationdescribe block space management with freelists
-
describe the concept of ASSMdescribe block space management with ASSMdefine the concepts of block migration and chainingdescribe how shrinking segments can improve the performance of SQL statementsdescribe how data compression can assist in improving the performance of SQL statementsdescribe the concept of HCC and using the compression advisorexamine 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 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
Channel
Wintellect SQL Server
Likes 1