Home » RDBMS Server » Performance Tuning » Find - Database growth monthwise
Find - Database growth monthwise [message #208363] Sat, 09 December 2006 20:02 Go to next message
orasaket
Messages: 70
Registered: November 2006
Member
Hi,
i want to how much my database size is increasing each month.
i want to find this for last 6 months

Please suggest how to find out this.
I am using Oracle 9i R2 on Linux

Thanks and Regards,
OraSaket
Re: Find - Database growth monthwise [message #208365 is a reply to message #208363] Sat, 09 December 2006 20:49 Go to previous messageGo to next message
BlackSwan
Messages: 25037
Registered: January 2009
Location: SoCal
Senior Member
>i want to find this for last 6 months
Either break out your crystal ball or learn how to time travel.
Re: Find - Database growth monthwise [message #208403 is a reply to message #208363] Sun, 10 December 2006 07:51 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
As usual a little search might have helped.
http://www.orafaq.com/forum/m/193198/42800/?srch=rate+of+growth#msg_193149
Re: Find - Database growth monthwise [message #208612 is a reply to message #208363] Mon, 11 December 2006 09:25 Go to previous messageGo to next message
orasaket
Messages: 70
Registered: November 2006
Member
Hi,

Thanks for your reply

i read the thread as directed by you.

however have a query here
the query is not returning incremental growth for existing files in the tablespace.

if datafile is added to tablespace Tbs1 in October itself and i want to know how much growth Tbs1 had in November (i.e. Regardless of File Creation time)

how do i find it out.

Thanks and Regards,
Pratap
Re: Find - Database growth monthwise [message #208625 is a reply to message #208612] Mon, 11 December 2006 09:57 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
That is because it is grouping by month
use
to_char(creation_time, 'Month dd RRRR')


>>i want to know how much growth Tbs1 had in Novembe
That is what that whole discussion was about.
Unless you pull your stats out of database and generate a report,
No such information is recorded historically.
The above report is based on FILE CREATION DATE (allocated space. Not the actual space used inside the tablespace)
Re: Find - Database growth monthwise [message #209209 is a reply to message #208625] Wed, 13 December 2006 15:41 Go to previous message
orasaket
Messages: 70
Registered: November 2006
Member
Many thanks for the Reply!

Regards,
OraSaket

Previous Topic: Performance Issue
Next Topic: session cached cursors
Goto Forum:
  


Current Time: Mon Dec 05 08:44:21 CST 2016

Total time taken to generate the page: 0.15189 seconds