RelationalDBDesign
RedhatLinuxSys Seomining
prev next prev next
Course navigation
Lesson 13
Oracle space management Conclusion
This module described how Oracle stores data in the database, how to control the way that Oracle manages the space needed for this storage, and one of the problems that can crop up with Oracle space management.
In this module, you learned:
  1. The basic concepts of Oracle storage
  2. The role of database blocks, extents, and segments
  3. How to set storage characteristics for database objects and tablespaces
  4. How to learn about storage characteristics from the data dictionary
  5. How Oracle manages free space in database objects
  6. How to learn about free space from the data dictionary
  7. How fragmentation can affect your Oracle database and how to avoid the problems that can come from fragmentation
Glossary
In this module, you learned the following glossary terms:
  1. Add-on Tuning Pack: One of any number of applets Oracle offers to extend the capabilities of the Oracle Enterprise Manager.
  2. BLOB: A binary large object (BLOB) is a large piece of data.
In the next module, you will learn to assign privileges to database objects to limit the ways that users can interact with them.
Tablespace fragmentation Quiz
Click the Quiz link below to answer a few questions about tablespace fragmentation.
Tablespace fragmentation Quiz
Course navigation