RE: Grid stuff that bugs me - a solution

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:

SELECT
        target_name,
        rollup_timestamp,
        SUM(maximum) "SIZE_MB"
FROM sysman.mgmt$metric_daily
WHERE
        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.

Rich

> I have been able to get data about tablespace usage going back over a year.
> It is summarizing the information by day.
>
>
> Pat


--
http://www.freelists.org/webpage/oracle-l

Other related posts: