About table Spaces
Starting with Oracle8i, Oracle supports two types of tablespaces:
Dictionary Management table Space: the management information for all storage spaces in a tablespace is stored in the data dictionary.
Local Administration Table Space: Management information for all storage spaces on a tablespace is stored in the bitmap in the header of the data file.
2, local management table space
Create Tablespace ...
DataFile ' ... ' Size ... unuse
Extent management local Autoallocate/unform size ...
Segment Space Management Manual/auto
. autoallocate
Oracle is responsible for automating the allocation of the zone. In the autoallocate mode, the smallest area in the table space is 64KB
. Uniform size ...
The biggest advantage is that there is no storage fragmentation in the tablespace, and you can avoid the waste of storage space.
. Segment Space Management manual (default method)
Oracle will use the available lists (free list) to manage the free blocks of data in the segment.
. Segment Space Management Auto
Oracle will use bitmaps (BITMAP) to manage the used data blocks and busy blocks in the segment.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
