By Steve Karam, OCM, Oracle ACE
Also see
dba_hist_tablespace_stat tips and
these notes for tracking Oracle database growth. Also see
how to use v$datafile to
track database growth
Oracle provides time-series segment statistics
for tables and index in the 10g Automated workload Repository tables
(AWR). These can quickly extract data for Oracle growth
reports.
Note: for tracking table and index growth over
time, see the
dba_hist_seg_stat table.
If you are pre-Oracle10g you can write your own
tables to periodically examine and store object sizes for database
growth reports by creating your own STATSPACK extension tables (See
book "Oracle Tuning: The Definitive Reference",
for ready to use scripts to create a stats$tab_stats and
stats$idx_stats tracking tables).
In Oracle 10g, total database growth reports
are is easy because the dba_hist_seg_stat tables provides the delta
value for every table and index (Note: the "total" columns
are not implemented as of Oracle 10.0.2).
Below is a great script to display the total
Oracle growth between two periods. This script can be
modified to display overall database growth trends for capacity
planning purposes. You can also see the growth of key tables
and indexes with this Oracle growth tracking script.
Oracle growth report at the
table level
