OraFAQ Forum: Performance Tuning » Find - Database growth monthwise

Home » RDBMS Server » Performance Tuning » Find - Database growth monthwise

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Find - Database growth monthwise [message #208363]

Sat, 09 December 2006 20:02

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

Report message to a moderator

Re: Find - Database growth monthwise [message #208365 is a reply to message #208363]

Sat, 09 December 2006 20:49

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: Find - Database growth monthwise [message #208403 is a reply to message #208363]

Sun, 10 December 2006 07:51

Mahesh Rajendran
Messages: 10708
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

Report message to a moderator

Re: Find - Database growth monthwise [message #208612 is a reply to message #208363]

Mon, 11 December 2006 09:25

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

Report message to a moderator

Re: Find - Database growth monthwise [message #208625 is a reply to message #208612]

Mon, 11 December 2006 09:57

Mahesh Rajendran
Messages: 10708
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)

Report message to a moderator

Re: Find - Database growth monthwise [message #209209 is a reply to message #208625]

Wed, 13 December 2006 15:41

orasaket
Messages: 70
Registered: November 2006

Member

Many thanks for the Reply!

Regards,
OraSaket

Report message to a moderator

Previous Topic:	Performance Issue
Next Topic:	session cached cursors

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 03:01:49 CST 2024