DBA_TABLESPACE_USAGE_METRICS
select * from DBA_TABLESPACE_USAGE_METRICS;
The size is base on the block.
DBA_HIST_TBSPC_SPACE_USAGE
DBA_HIST_TBSPC_SPACE_USAGE contains the historical usage information collect by AWR.
select TABLESPACE_ID,NAME,TABLESPACE_SIZE,TABLESPACE_USEDSIZE,RTIME from DBA_HIST_TBSPC_SPACE_USAGE,v$tablespace where TABLESPACE_ID=TS# order by RTIME,dba_hist_tbspc_space_usage.tablespace_id;
This select * from DBA_TABLESPACE_USAGE_METRICS; cause ora-1000 : Maximum open cursors exceeded.
ReplyDelete