DBA AWR Tablespace Usage

Description
Categories: Diagnostic Pack, Enginatics, Kcapps, Toolkit - DBA
Repository: Github
Tablespace usage over time from the AWR
Run DBA AWR Tablespace Usage and other Oracle EBS reports with Blitz Report™ on our demo environment
select
x.*
from
(
select
to_char(xxen_util.client_time(to_date(dhtsu.rtime,'MM/DD/YYYY HH24:MI:SS')),'Day') day_of_week,
xxen_util.client_time(to_date(dhtsu.rtime,'MM/DD/YYYY HH24:MI:SS')) end_interval_time,
decode(ts.contents$,0,(decode(bitand (ts.flags, 16),16,'UNDO','PERMANENT')),1,'TEMPORARY') contents,
ts.name tablespace,
dhtsu.tablespace_usedsize*vp.value/1000000 used_size,
dhtsu.tablespace_size*vp.value/1000000 size_,
dhtsu.tablespace_maxsize*vp.value/1000000 max_size,
sys_context('userenv','db_name') db_name
from
(select vp.value from v$parameter vp where vp.name like 'db_block_size') vp,
v$database vd,
dba_hist_tbspc_space_usage dhtsu,
sys.ts$ ts
where
dhtsu.tablespace_id=ts.ts# and
2=2
) x
where
1=1
order by
x.contents desc,
x.tablespace,
x.end_interval_time desc
Parameter Name SQL text Validation
Date From
end_interval_time>=xxen_util.server_time(fnd_date.displaydt_to_date(:date_from))
LOV
Diagnostic Pack enabled
1=1
LOV
Container Data
vd.dbid=dhtsu.dbid
LOV