Re: growth metrics

From: Lei Zeng <leizeng2003_at_yahoo.com>
Date: Mon, 7 Jan 2013 22:21:53 -0800 (PST)
Message-ID: <1357626113.29108.YahooMailNeo_at_web140005.mail.bf1.yahoo.com>

Would you please try DBspeed? One year free trial. You can use it to graph database/tablespace size growth as long as you have AWR data collected.

http://dbspeed.com/case_study/graph_size_growth.html

DBspeed  http://dbspeed.com/index.html

There are some case studies on the website. If you are familiar with AWR and ASH reports, you know this tool.

Regards,

Lei

---

 From: oracledba <oracledba71_at_gmail.com> To: Oracle-L_at_freelists.org
Sent: Monday, January 7, 2013 7:40 AM
Subject: growth metrics  

All,
In my shop we do collect database growth info every 1st of a month.In addition to that we do collect all tablespace's growth info everyday and also stores file system's used and free space info everyday.

The table has
servername,dbname,tsname,filename,allocatedspace,freespace,date columns and populated everyday.
The filesystem storage info table has
dbname,servername,allocatedspace,freespace,mountpoint,date columns and populated everyday.

I would like to report database growth weekly like week1,week2,week3,week4,monthy,quarterly,yearly and estimate for the next quarter and project when to order storage.

any help would be appreciated.

Thanks

--

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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Jan 08 2013 - 07:21:53 CET