Eason [資料科學//Python學習/資料庫] & [拍片&剪片]

查詢表空間

select * from dba_tablespaces;

select * from v$tablespace;

查詢表空間與datafile名子

select * from dba_data_files;

查詢使用者預設表空間

select username,default_tablespace from dba_users;

查看還剩多少表空間

select   * from    dba_tablespace_usage_metrics;

查看表空間總大小，及其已使用大小

select a.tablespace_name,a.bytes/1024/1024 "Sum MB",(a.bytes-b.bytes)/1024/1024 "used MB",b.bytes/1024/1024 "free MB", round(((a.bytes-b.bytes)/a.bytes)*100,2) "percent_used" from (select tablespace_name,sum(bytes) bytes from dba_data_files group by tablespace_name) a, (select tablespace_name,sum(bytes) bytes,max(bytes) largest from dba_free_space group by tablespace_name) b where a.tablespace_name=b.tablespace_name order by ((a.bytes-b.bytes)/a.bytes) desc;

查看undo空間資料

select name,value from v$parameter where name like '%undo%';

改變undo空間位置

alter system set undo_tablespace=你制定的表空間;

undo空間統計值