Oracle如何查询表空间？

Question

Oracle如何查询表空间？

Answer 1

系统数据字典 DBA_TABLESPACES 中记录了关于表空间的详细信息：select * from sys.dba_tablespaces;数据字典 DBA_TABLESPACES 中的字段和含义:TABLESPACE_NAMETablespace nameBLOCK_SIZETablespace block sizeINITIAL_EXTENTDefault initial extent sizeNEXT_EXTENTDefault incremental extent sizeMIN_EXTENTSDefault minimum number of extentsMAX_EXTENTSDefault maximum number of extentsPCT_INCREASEDefault percent increase for extent sizeMIN_EXTLENMinimum extent size for the tablespaceSTATUS"Tablespace status: "ONLINE","OFFLINE" or "READCONTENTSTablespace contents: "PERMANENT" or "TEMPORARY" or "UNDO"LOGGINGDefault logging attributeFORCE_LOGGINGTablespace force logging modeEXTENT_MANAGEMENTExtent management tracking: "DICTIONARY" or "LOCAL"ALLOCATION_TYPEType of extent allocation in effect for this tablespacePLUGGED_IN--SEGMENT_SPACE_MANAGEMENTSegment space management tracking: "AUTO" or "MANUAL"