Lesson 1
Oracle space management
One of the biggest advances of relational databases is to free end users from the need to understand the physical storage of
their information.
Someone who is simply using the data in an Oracle database has no need to understand the way that Oracle stores its data.
This does not mean that the database administrator, can afford to ignore the way Oracle stores information. Even though Oracle will manage its own physical storage, you can shape the way this space management occurs.
To effectively manage an Oracle database, you must understand the way that an Oracle database stores information.
Someone who is simply using the data in an Oracle database has no need to understand the way that Oracle stores its data.
This does not mean that the database administrator, can afford to ignore the way Oracle stores information. Even though Oracle will manage its own physical storage, you can shape the way this space management occurs.
To effectively manage an Oracle database, you must understand the way that an Oracle database stores information.
This module gives you a firm foundation for understanding how Oracle manages its storage space. You will learn:
- The basic concepts of Oracle storage
- The role of database blocks, extents, and segments
- How to set storage characteristics for database objects and tablespaces
- How to learn about storage characteristics from the data dictionary
- How Oracle manages free space in database objects
- How to learn about free space from the data dictionary
- How fragmentation can affect your Oracle database and how to avoid the problems this can cause