LOGICAL STRUCTURE OF DATABASE

数据库的逻辑结构解析

最新推荐文章于 2025-05-26 10:46:29 发布

原创最新推荐文章于 2025-05-26 10:46:29 发布 · 358 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#Oracle database

Oracle数据库专栏收录该内容

1 篇文章

订阅专栏

本文详细阐述了数据库的逻辑结构，包括表空间、段、扩展和Oracle数据块等核心概念，帮助理解数据库内部的工作原理。

http://www.oraclefaq.net/logical-structure-of-database/

Logical structure mainly consists of tablespace, segments, extents, and oracle data blocks

TABLESPACE

Each database is logically divided into one or more tablespaces. One or more datafiles are explicitly created for each tablespace to physically store the data of all logical structures in a tablespace. The combined size of the datafiles in a tablespace is the total storage capacity of the tablespace.

SEGMENT

A segment is a set of extents allocated for a certain logical structure. The segments can be of one of following type data segment,index segment,temporary segment,rollback segment.

EXTENT

The next level of logical database space is an extent. An extent is a specific number of contiguous data blocks, obtained in a single allocation, used to store a specific type of information.

ORACLE DATABLOCKS

At the finest level of granularity, Oracle database data is stored in data blocks. One data block corresponds to a specific number of bytes of physical database space on disk. The standard block size is specified by the DB_BLOCK_SIZE initialization parameter. In addition, you can specify up to five other block sizes.