Home » RDBMS Server » Server Administration » Database Growth Report (Oracle 10.2.0.2, Solaris 10)
Database Growth Report [message #415047] Fri, 24 July 2009 08:43 Go to next message
pokhraj_d
Messages: 117
Registered: December 2007
Senior Member
Hi ,

I require one script that will generate report for database growth on Monthly basis.

Can someone help me out to resolve this issue, as I need this report urgently.


Thanks-

Pokhraj Das
Re: Database Growth Report [message #415049 is a reply to message #415047] Fri, 24 July 2009 08:49 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 Report [message #415056 is a reply to message #415047] Fri, 24 July 2009 09:25 Go to previous messageGo to next message
pokhraj_d
Messages: 117
Registered: December 2007
Senior Member
Hi,

I am not able to login into the DBA village forum.
Please help me out to generate the report.

Pokhraj
Re: Database Growth Report [message #415058 is a reply to message #415056] Fri, 24 July 2009 10:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Create your account and you will be.

Regards
Michel
Re: Database Growth Report [message #415150 is a reply to message #415047] Sat, 25 July 2009 07:13 Go to previous messageGo to next message
pokhraj_d
Messages: 117
Registered: December 2007
Senior Member
Hi, Thanks for the help.
Is there is any script for 10g database? As at 10g the dba_hist_seg_stat can be used to check the db growth.

Pokhraj
Re: Database Growth Report [message #415164 is a reply to message #415150] Sat, 25 July 2009 09:14 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
As at 10g the dba_hist_seg_stat can be used to check the db growth.

You have to first define what is database space and growth for you.

Regards
Michel

[Updated on: Sat, 25 July 2009 09:15]

Report message to a moderator

Previous Topic: Migrating from 9.2.0.4(32-bit) to 10.2.0.4(64-bit)
Next Topic: Oracle 11g with compression feature
Goto Forum:
  


Current Time: Sun Dec 01 17:27:08 CST 2024