如何查看某个数据库对象(TABLE, INDEX ....)所占得物理存储空间 SELECT SEGMENT_NAME,SEGMENT_TYPE,TABLESPACE_NAME,EXTENTS,BLOCKS,BYTES/1024/1024/1024 GB
FROM DBA_SEGMENTS
WHERE SEGMENT_NAME Upper(MTL_MATERIAL_TRANSACTIONS);Oracle逻辑结构…
Oracle allocates logical database space for all data in a database. The units of database space allocation are data blocks, extents, and segments Oracle数据库负责为所有的数据分配逻辑存储空间,数据库空间分配单位有数据库(data block&#…