Oracle Storage Architecture

Logical storage of the database, starting from the table space
The logical storage structure for a database object is as follows
Table Space-Segment-zone-Block

SELECT * from Dba_tablespaces;
SELECT * FROM Dba_segments
where tablespace_name= ' Kyc_veh ';
SELECT * FROM Dba_segments
where Tablespace_name= ' Kyc_veh ' and segment_name= ' vehicle_info ';
SELECT * FROM Dba_extents
where Tablespace_name= ' Kyc_veh ' and segment_name= ' vehicle_info ';

The initial is allocated according to a zone of 8 blocks, that is, 65536b,initial_extent is 65536, that is, the Initial_extent field value in Dba_segments
Select 16*8*8192 from dual;
1048576
After the initial size is occupied, the redistribution is allocated according to a zone of 128 blocks, that is, 1mb,next_extent is 1048576, that is, the Next_extent field value in Dba_segments
Select 128*8192 from dual;
1048576

A segment takes up a extents
A zone of 8 blocks, i.e. a zone is 65536 bytes
A block of 8192 bytes

BLOCK_ID are global, others are relative.
SELECT * from Dba_segments;
Focus on header_block,blocks Two field value changes and can be viewed in descending or ascending order

Oracle Storage Fabric