首页 > Linux操作系统 > Linux操作系统 > 查询表空间的详细信息脚本
--表空间每日状态监控
spool e:\qin_daily\表空间状态监控_script004
set wrap off
set linesize 1000
set timing on
col force_loggin for a13
select
tablespace_name,
status,
contents,
logging,
force_logging,
extent_management,
allocation_type,
segment_space_management
from dba_tablespaces
order by status desc;
spool off
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/12330444/viewspace-434590/ ,如需转载,请注明出处,否则将追究法律责任。