[重庆思庄每日技术分享]-依靠dba_hist_tbspc_space_usage视图获得表空间的历史使用情况

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(rtime, 'mm/dd/yyyy hh24:mi:ss')) >

trunc(sysdate - 17)

group by tablespace_id,

trunc(to_date(rtime, 'mm/dd/yyyy hh24:mi:ss'))

order by tablespace_id,

trunc(to_date(rtime, 'mm/dd/yyyy hh24:mi:ss'))) b

where a.ts# = b.tablespace_id and a.name='USERS';

NAME TABLESPACE_ID DATETIME USED_SIZE_MB

------------------------------ ------------- --------- ------------

USERS 4 07-MAR-22 7240.67

USERS 4 08-MAR-22 7252.05

USERS 4 09-MAR-22 7320.55

USERS 4 10-MAR-22 7404.98