Oracle块，区，段

SEGMENT_NAME?? VARCHAR2(81) Y?????????????? Name,of the segment?????????????????????????????????????????????????????????????????????????????????????????????????????????

PARTITION_NAME VARCHAR2(30) Y??????? Partition/Subpartition Name,of the segment??????????????????????????????????????????????????????????????????????????????????

SEGMENT_TYPE?? VARCHAR2(18) Y??? Type of segment: "TABLE","CLUSTER","INDEX","ROLLBACK",

"DEFERRED ROLLBACK","TEMPORARY","SPACE HEADER","TYPE2 UNDO" or "CACHE"

TABLESPACE_NAME VARCHAR2(30) Y?????????????? Name of the tablespace containing the segment????????????????????????????????????????????????????????????????????????????????????????

HEADER_FILE??? NUMBER????? Y?????????????? ID of the file containing the segment header?????????????????????????????????????????????????????????????????????????????????????????

HEADER_BLOCK?? NUMBER????? Y?????????????? ID of the block containing the segment header????????????????????????????????????????????????????????????????????????????????????????

BYTES????????? NUMBER????? Y?????????????? Size,in bytes,of the segment???????????????????????????????????????????????????????????????????????????????????????????????????????

BLOCKS???????? NUMBER????? Y?????????????? Size,in Oracle blocks,of the segment???????????????????????????????????????????????????????????????????????????????????????????????

EXTENTS??????? NUMBER????? Y?????????????? Number of extents allocated to the segment

INITIAL_EXTENT NUMBER????? Y??????? Size,of the initial extent of the segment?????????????????????????????????????????????????????????????????????????????????

（编辑：PHP编程网 - 湛江站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!