Home » RDBMS Server » Server Administration » database growth size (oracle database 9i)
database growth size [message #388278] Tue, 24 February 2009 02:08 Go to next message
juniordba
Messages: 12
Registered: February 2009
Location: malaysia
Junior Member
hi,

I would like to check if i can get any script to check the database growth monthly for oracle database. thanks in advanced.

regards,
juniordba
Re: database growth size [message #388287 is a reply to message #388278] Tue, 24 February 2009 02:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
How to follow the growth of your database

Regards
Michel
Re: database growth size [message #388308 is a reply to message #388287] Tue, 24 February 2009 03:48 Go to previous messageGo to next message
juniordba
Messages: 12
Registered: February 2009
Location: malaysia
Junior Member
hi,

actually i need something like this...(space/% growth in 6 months)

Tablespace Name
Tblspc size. 6 mths ago (GB)
Tblspc size. 5 mths ago (GB)
Tblspc size. 4 mths ago (GB)
Tblspc size. 3 mths ago (GB)
Tblspc size. 2 mths ago (GB)
Tblspc size. 1 mths ago (GB)
Tblspc size. current (GB)

regards,
Re: database growth size [message #388313 is a reply to message #388308] Tue, 24 February 2009 03:53 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Yes, and the previous post contains the answer to do this but there is no answer for the past, you can just implement it to be able to answer to the question in the next months.

Regards
Michel

[Updated on: Tue, 24 February 2009 03:54]

Report message to a moderator

Previous Topic: Execution plan - parameters
Next Topic: SHUTDOWN IMMEDIATE
Goto Forum:
  


Current Time: Sun Dec 01 20:02:34 CST 2024