Tablespace usage over time
Posted by Superadmin on January 03 2016 10:26:13

---

Tablespace usage over time
If you have OEM, this repository query may be very helpful:

SELECT KEY_VALUE Tablespace_Name,
ROLLUP_TIMESTAMP Sample_date,
METRIC_COLUMN metric,
AVERAGE
FROM sysman.MGMT$METRIC_DAILY
WHERE metric_name='tbspAllocation'
and TARGET_NAME=''
and KEY_VALUE = ''
ORDER BY 1,2,3;