A bufferpool is an area of main memory that has
been allocated by the database manager for the purpose of caching
table and index data as it is read from disk. Each new
database has a default bufferpool defined, called IBMDEFAULTBP.
Additional buffer pools can be created, dropped, and modified,
using the CREATE BUFFERPOOL, DROP BUFFERPOOL, and ALTER BUFFERPOOL
statements. A tablespace is a storage structure
containing tables, indexes, large objects, and long data. Table
spaces reside in database partition groups. They allow you to
assign the location of database and table data directly onto
containers. (A container can be a directory name, a device name, or
a file name.)
Storage Objects for
Oracle includes Datafiles, Tablespaces, Rollback Segments and Redo
Log Groups.
A datafile is a physical part of an Oracle database and it is
storage device to store Oracel data. A datafile
may be created with different block sizes, spanned upon different
disks, and use different rate levels. A Tablespace
may be created with dictionary-managed or locally–managed
Tablespaces, and a host of other tablespace options that affect the
physical design of the system.
