显示当前数据库的表空间名称及数据文件
sql> select file_name,tablespace_name,bytes/(1024*1024) from dba_data_files;
显示当前数据库的表空间管理方式
表空间名称、路径、类型、管理方式、区管理方式、段管理方式和是否自动增长。
select t1.tablespace_name as "表空间名称",
t2.file_name as "数据文件名",
t1.contents as "类型",
t1.extent_management as "管理方式",
t1.allocation_type as "区管理方式",
t1.segment_space_management as "段管理方式",
t2.autoextensible as "是否自动扩展",
t1.status as "是否联机"
from dba_tablespaces t1, dba_data_files t2
where t1.tablespace_name = t2.tablespace_name