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 53sAfter completing this video, you will be able to describe how adding indexes can improve SQL performance. FREE ACCESS
-
2. Maintaining Indexes4m 1sAfter completing this video, you will be able to describe how index maintenance operations can improve SQL Server performance. FREE ACCESS
-
3. Table Maintenance for Performance3m 28sAfter completing this video, you will be able to describe how table space usage can impact performance. FREE ACCESS
-
4. Extent Management4m 15sIn this video, you will learn about extents and how they relate to the performance of SQL operations. FREE ACCESS
-
5. The Anatomy of a Database Block2m 37sAfter completing this video, you will be able to describe the structure of a database table. FREE ACCESS
-
6. Block Visits and Allocation1m 23sUpon 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
-
7. Block Space Management with Freelists3m 24sAfter completing this video, you will be able to describe block space management using freelists. FREE ACCESS
-
8. Automatic Segment Space Management2m 14sAfter completing this video, you will be able to describe the concept of automatic storage management. FREE ACCESS
-
9. Block Space Management with ASSM2m 39sUpon completion of this video, you will be able to describe block space management with Automatic Segment Space Management. FREE ACCESS
-
10. Migration and Chaining5m 3sLearn how to define the concepts of block migration and chaining. FREE ACCESS
-
11. Shrinking Segments4m 8sAfter completing this video, you will be able to describe how using fewer segments can improve the performance of SQL statements. FREE ACCESS
-
12. Data Compression3m 29sUpon completion of this video, you will be able to describe how data compression can help improve the performance of SQL statements. FREE ACCESS
-
13. Hybrid Columnar Compression2m 31sUpon completion of this video, you will be able to describe the concept of HCC and how to use the compression advisor. FREE ACCESS
-
14. Exercise: Influencing Performance with Statistics4m 34sIn 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.
