1. A data file can only belong to one table space at a time
2. Segments are data files that can be cross-domain. However, you cannot generally cross a table space. Partitioned tables can span table spaces, and heap tables cannot span table spaces.
3. The district is composed of contiguous blocks and cannot cross-domain files. There are two different ways to manage a zone table space:Local management methods andHow data dictionaries are managed. When setting up a table space, you can set which method to use
Data dictionary form uet$ used fer$ free is not suitable for high concurrency situations
Local management uses bit map (bitmap): If you use a representation of 1, no use is expressed as 0, as long as 0 is continuous, the representation is continuous space, there is no need to merge
See how table spaces are managed, and see how each table space is managed
> SELECT tablespace_name,extent_management from Dba_tablespaces;
management of segment space, that is, the data block of the segment
Blocks are divided into size, space, and data. Oracle believes this is the most space-saving way
Mainly divided into Pctfree and pctused
Free 10% means that only 90% of the space can be deposited
If the original cannot be written, a row migration action is made, and the entire row is migrated to another block
Setting a pctfree is to some extent avoiding the migration of this kind of situation to produce
Used 40% indicates that the data will not be inserted until it drops to 40%
This is to prevent a frequent rise and fall
Block parameters
Initrans: Initial
Maxtrans: Max
viewing standard block sizes
> Show Parameter Block
An explanation of Oracle storage architecture
