Query to retrieve average growth
609621Sep 29 2011 — edited Sep 29 2011Dear all,
10.2.0.5 on solaris
Table script :
DB_SPACE_HIST
(
TIMESTAMP DATE,
TOTAL_SPACE NUMBER(8),
USED_SPACE NUMBER(8),
FREE_SPACE NUMBER(8),
PCT_INUSE NUMBER(5,2),
NUM_DB_FILES NUMBER(5)
);
Sample data :
Time stamp : /16/2010 12:57:52 AM
Totak space : 678017
Used space : 235612
Free space : 442405
Pct in use : 34.75
number of files : 60
We have the timestamp stored in the table for morethan 3 years. The requirement is that we need to get the average growth in the database/month.
Any idea how I can do this ?
Kai