dba_hist_tbspc_space_usage视图中存放了历史信息 select a.name, b.* from v$tablespace a, (select tablespace_id, trunc(to_date(rtime, 'mm/dd/yyyy hh24:mi:ss')) datetime, round(max(tablespace_usedsize * 8 / 1024),2) used_size_MB from dba_hist_tbspc_space_usage where trunc(to_date...
观察者两个视图的运行结果,DBA_HIST_TBSPC_SPACE_USAGE视图收集到的统计大小和实际大小都存在一定的误差,但是UNDO表空间出入太明显(UNDOTBS1),特别是最大值和当前值,几乎是真实大小的两倍 4.排除原因 4.1)收集信息是否是最新 SQL> select MAX(rtime) FROM DBA_HIST_TBSPC_SPACE_USAGE; MAX(RTIME) --- 01/0...
6.74 DBA_HIST_SYSMETRIC_HISTORY 6.75 DBA_HIST_SYSMETRIC_SUMMARY 6.76 DBA_HIST_SYSSTAT 6.77 DBA_HIST_SYSTEM_EVENT 6.78 DBA_HIST_TABLESPACE 6.79 DBA_HIST_TABLESPACE_STAT 6.80 DBA_HIST_TBSPC_SPACE_USAGE 6.81 DBA_HIST_TEMPFILE 6.82 DBA_HIST_TEMPSTATXS ...
4 trunc(to_date(rtime, 'mm/dd/yyyy hh24:mi:ss')) datetime, 5 round(max(tablespace_usedsize * 8 / 1024),2) used_size_MB 6 from dba_hist_tbspc_space_usage 7 where trunc(to_date(rtime, 'mm/dd/yyyy hh24:mi:ss')) > 8 trunc(sysdate - 17) 9 group by tablespace_id, 10 tr...
dba_hist_tbspc_space_usage a join v$tablespace b on a.tablespace_id = b.ts# join dba_tablespaces c on b.name = c.tablespace_name join (select tablespace_name, sum(bytes)/1024/1024 as datafile_size from dba_data_files group by tablespace_name ...
Oracle-视图DBA_TABLESPACE_USAGE_METRICS 简单快速,查询表空间使用率。 tablespace 表空间使用率 依靠dba_hist_tbspc_space_usage视图 获得表空间的每日增长量 SQL> select a.name, b.* 2 from v$tablespace a, 3 (select tablespace_id, 4 tablespace increase sed sql nload - displays the current networ...