Reports2017-11-18T12:27:27+00:00

DBA AWR Tablespace Usage

Description
Categories: DBA, Enginatics

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
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
vd.dbid=dhtsu.dbid and
dhtsu.tablespace_id=ts.ts#
) 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>=fnd_date.displaydt_to_date(:date_from)
LOV
Display Style
1=1

By continuing to use the site, you agree to the use of cookies. Accept