RE: Grid stuff that bugs me - a solution
Date: Wed, 18 Jun 2008 10:35:22 -0500 (CDT)
Ditto, but it'd be extra handy if there was a pre-rolled way instead of having to come up with this SQL for a GC Report time series line chart:
target_name, rollup_timestamp, SUM(maximum) "SIZE_MB"
target_type = 'oracle_database' AND metric_name = 'tbspAllocation' AND metric_column = 'spaceUsed'
GROUP BY target_name, rollup_timestamp
ORDER BY 2,1 (optionally add "AND target_guid = ??EMIP_BIND_TARGET_GUID??" to the WHERE clause to limit to a single database)
Also note that following the repository advice of Metalink note 430830.1 may help in order to be of long-term (>365 days) use.
> I have been able to get data about tablespace usage going back over a year.
> It is summarizing the information by day.