Managing Storage with Oracle
The Oracle database is one of the most popular relational database management systems in the world. This course teaches you the basics of storage management in Oracle, including segment deferment, table compression, and resumable space allocation.
What you'll learn
A thorough knowledge of Oracle’s storage hierarchy is necessary for successful administration of the Oracle database.
In this course, Managing Storage with Oracle, you will learn the skills you need to manage Oracle’s logical storage components.
First, you will learn about the logical and physical storage hierarchy.
Next, you will explore segment creation, extent allocation, and space management within allocated blocks.
Finally, you will learn how to save space by compressing data.
By the end of this course, you will have a solid understanding of storage management in Oracle and the knowledge to help you mitigate space wastage in your Oracle systems, as well as reduce space related failures to a minimum.
Table of contents
- Managing Storage With Oracle 1m
- Oracle Storage Model 6m
- Segment Types 2m
- Deferring Segment Creation 1m
- One Table, Many Segments 2m
- Segments, Extents, Blocks 2m
- Physical Structure of a Database 3m
- Where Is My Table 2m
- Creating Tablespaces 2m
- Uniform vs. Autoallocate 2m
- Extent Management 3m
- Segment Space Management 4m
- Module Summary 1m
- Managing Space 3m
- Extent Management 1m
- Objects and Segments 2m
- Controlling Segment Creation 1m
- Automatic Segment Space Management 8m
- Saving Space Through Compression 3m
- Detecting Wasted Space 7m
- Reclaiming Wasted Space - Moving Tables 2m
- Reclaiming Wasted Space - Shrinking Segments 4m
- Managing Indexes 3m
- Resumable Space Allocation 3m
- Module Summary 2m
About the author
I got my start in IT administrating an Oracle 10g database on Red Hat Linux. I've come a long way since and have used Linux everyday since 2012 both personally and professionally. As an independent consultant, I'm currently responsible for no less than forty Oracle databases running on Windows and Red Hat Servers. Perhaps the only thing I love almost as much as Linux is the Cloud and the many opportunities it provides. Linux has opened a lot of doors for me, and teaching it is my favorite pas... more