Hello,
Starting with 10g, if AWR (Automatic Workload Repository) is enabled then you may query the following Table:
select snap_id, tablespace_id, tablespace_size from DBA_HIST_TBSPC_SPACE_USAGE;
Where snap_id is the AWR Snapshot id and tablespace_id is the Tablespace id.
The View DBA_HIST_SNAPSHOT will give you time information for each snap_id.
The View DBA_HIST_TABLESPACE_STAT will give you the Tablespace id (column ts# ) and Tablespace name (column tsname ).
By that way, you may have the history of the Tablespaces growth.
NB: AWR needs specific license.
Hope this help.
Best regards,
Jean-Valentin
Edited by: Lubiez Jean-Valentin on Apr 8, 2010 9:58 PM
