segment(段) 包含 extent 盘区 包含block 数据块
数据块大小取决于操作系统,包含块头,表目录,行目录,空闲空间,数据。
In summary, the hierarchy of storage in Oracle is as follows:
1. A database is made up of one or more tablespaces.
2. A tablespace is made up of one or more data files. A tablespace contains segments.
3. A segment (TABLE, INDEX, and so on) is made up of one or more extents. A
segment exists in a tablespace, but may have data in many data files within that
tablespace.
4. An extent is a contiguous set of blocks on disk. An extent is in a single tablespace
and furthermore, is always in a single file within that tablespace.
5. A block is the smallest unit of allocation in the database. A block is the smallest unit
of I/O used by a database.创建表空间 http://www.cnblogs.com/netsql/articles/1745978.html
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28728816/viewspace-757280/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/28728816/viewspace-757280/