> SELECT NULL LINK, null, tablespace_name AS label, ROUND(
> SUM(on_disk_size_mb ) / 1024 ) AS space_gb FROM
> tab$database_tablespaces WHERE ( database_name, tablespace_name,
> last_seen )
>         IN (SELECT database_name, tablespace_name, MAX(last_seen) FROM tab$database_tablespaces
>             GROUP BY database_name, tablespace_name)
>        GROUP BY NULL, tablespace_name UNION ALL SELECT NULL LINK, null, 'Free' "Database", ROUND(MAX(on_disk_free_mb)/1024) AS "Space
> (GB)" FROM tab$database_tablespaces WHERE (database_name,
> tablespace_name, last_seen)
>        IN (SELECT database_name, tablespace_name, MAX(last_seen) FROM tab$database_tablespaces
>        GROUP BY NULL, database_name, tablespace_name)

SELECT 'f?p=' || :APP_ID || ':5:' || :APP_SESSION || '::NO:::' LINK,
SUM( ON_DISK_SIZE_MB ), SUM( ON_DISK_FREE_MB ), TO_CHAR(TRUNC( LAST_SEEN), 'DD/MM/YYYY' ) FROM tab$database_tablespaces
WHERE LAST_SEEN > SYSDATE - 180 AND Tablespace_name = 'CSP_DATA'
GROUP BY TRUNC(LAST_SEEN)
ORDER BY TRUNC(LAST_SEEN) ASC