Oracle Internal Architecture

• - consists of tablespaces, segments, extents and blocks.

• - a DB has several tablespaces. This is for efficiency and ease of administration. For example, Purchase, Accounts and System tablespaces.

• - tablespace is nothing but one or more OS files on one or more disks.

• - extent : contiguous set of DB blocks.

• - segment types : table, index, etc.

Previous slide

Next slide

Back to first slide

View graphic version