不能向该表空间加数据文件,我使用的是bigfile表空间类型。
该表空间的数据文件在raw设备上,不能扩展数据文件。
该表空间的数据文件在raw设备上,不能扩展数据文件。
方法一、
SELECT OWNER, SEGMENT_NAME, SEGMENT_TYPE, BYTES / 1024 / 1024
FROM DBA_SEGMENTS
WHERE TABLESPACE_NAME = 'SYSAUX';
select distinct snap_id from dba_hist_snapshot order by 1;
exec dbms_workload_repository.drop_snapshot_range(low_snap_id => ???,high_snap_id => ???)
select a.tablespace_name "tablespace",trunc(a.total) "allocated(M)",ceil((1-b.free/a.total)*100) "Usage %",
trunc(b.free) " free space(M)" from
(select tablespace_name, sum(nvl(bytes,0))/1024/1024 total from dba_data_files group by tablespace_name) a,
(select tablespace_name, sum(nvl(bytes,0))/1024/1024 free from dba_free_space group by tablespace_name) b
where a.tablespace_name=b.tablespace_name order by 3 desc;
SELECT OWNER, SEGMENT_NAME, SEGMENT_TYPE, BYTES / 1024 / 1024
FROM DBA_SEGMENTS
WHERE TABLESPACE_NAME = 'SYSAUX';
select distinct snap_id from dba_hist_snapshot order by 1;
exec dbms_workload_repository.drop_snapshot_range(low_snap_id => ???,high_snap_id => ???)
select a.tablespace_name "tablespace",trunc(a.total) "allocated(M)",ceil((1-b.free/a.total)*100) "Usage %",
trunc(b.free) " free space(M)" from
(select tablespace_name, sum(nvl(bytes,0))/1024/1024 total from dba_data_files group by tablespace_name) a,
(select tablespace_name, sum(nvl(bytes,0))/1024/1024 free from dba_free_space group by tablespace_name) b
where a.tablespace_name=b.tablespace_name order by 3 desc;
select * from dba_hist_wr_control;
修改保留时间:
exec dbms_workload_repository.modify_snapshot_settings(interval=>240, retention=>3*24*60);
修改保留时间:
exec dbms_workload_repository.modify_snapshot_settings(interval=>240, retention=>3*24*60);
法二:扩展裸设备。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/20542911/viewspace-621947/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/20542911/viewspace-621947/